I need help please totally lost. I tried and had problems installing this cb earlyer now i am retrying and when i go to insatll comfiler this is what i get. Using latest mambo and cb1.1
[code:1]Fatal: Installer error with /home/vintagem/public_html/Mambo/media/install_46bf08e880ef4/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 N 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.
[ Continue ... ]

[/code:1]

Post edited by: Mayhem100, at: 2007/08/12 14:57

Post edited by: Mayhem100, at: 2007/08/12 15:19

I have tried to enter the sql data please look at the attched picture and tell me if i did it correctly. Also is this all the error wants me to do?

Post edited by: Mayhem100, at: 2007/08/12 16:34