Hi!

While installing "comprofiler.zip" on mambo 4.6.2 the following error occures:

Fatal: Installer error with /home/lagzi/public_html/test/media/install_471775139d268/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


It sais smething is wrong with sql..
Does anybody know what can be the problem?


thanks in advance,
andrew