Fatal Error, SQL Mambo 4.6.2 (elaborated)

16 years 7 months ago #43041 by allmylove
Fatal: Installer error with /home2/allmylo/public_html/goodies/media/install_46c4377cb6d06/com_comprofiler/comprofiler.xml: component com_comprofiler SQL error DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOTEXISTS `mos_comprofiler_members` (`referenceid` int(11) NOT NULL default '0',' at line 1 SQL=CREATE TABLE IF NOTEXISTS `mos_comprofiler_members` (`referenceid` int(11) NOT NULL default '0',`memberid` int(11) NOT NULL default '0',`accepted` tinyint(1) NOT NULL default '1',`pending` tinyint(1) NOT NULL default '0',`membersince` date NOT NULL default '0000-00-00',`description` varchar(255) default NULL,`type` MEDIUMTEXT default NULL,PRIMARY KEY (`referenceid`,`memberid`)) TYPE=MyISAM ;
SQL =

CREATE TABLE IF NOTEXISTS `mos_comprofiler_members` (`referenceid` int(11) NOT NULL default '0',`memberid` int(11) NOT NULL default '0',`accepted` tinyint(1) NOT NULL default '1',`pending` tinyint(1) NOT NULL default '0',`membersince` date NOT NULL default '0000-00-00',`description` varchar(255) default NULL,`type` MEDIUMTEXT default NULL,PRIMARY KEY (`referenceid`,`memberid`)) TYPE=MyISAM ;

Information: Joomla/Mambo Community Builder 1.1 for Joomla! 1.0, 1.5 RC1 and Mambo 4.5.2 - 4.6.2.


Hmm k perhaps I should elaborate.

I'm hosting my website through HostRocket and running Mambo 4.6.2 I've referred to a similar post I've seen yet the fix to that didn't help me much, just cleared up some other errors I've had. Post was located:
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,42367/catid,41/

I tried uninstalling and reinstalling twice
Changed the function to:

function character_data ($parser, $data) {
if ($this->errors->getMaxLevel() >= _MOS_ERROR_FATAL) return;
$this->chardata .=$data;
}

and had no luck, I'm still getting the same fatal message
any help would be greatly appreciated

Post edited by: allmylove, at: 2007/08/16 13:46

Please Log in to join the conversation.

16 years 7 months ago #43289 by beat
Sorry, If you get that exact error ("NOTEXISTS" in one word), then somehow you didn't apply the bug fix for mambo 4.6 as suggested.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.639 seconds

Facebook Twitter LinkedIn