I unstalled mambo and reinstalled it, starting clean, tried to install 1.1 and got the following error on installing the first part (comprofiler.zip). Any advice would be greatly appreciated!!!!!
Copyright 2004 - 2007 MamboJoe/JoomlaJoe, Beat and CB team on joomlapolis.com . This component is released under the GNU/GPL version 2 License and parts under Community Builder Free License. All copyright statements must be kept. Derivate work must prominently duly acknowledge original work and include visible online links. Official site:
www.joomlapolis.com
Installation Process:
Start correcting icons in administration backend.
FINISHED: Image of menu entry 0 has been corrected.
FINISHED: Image of menu entry 1 has been corrected.
FINISHED: Image of menu entry 2 has been corrected.
FINISHED: Image of menu entry 3 has been corrected.
FINISHED: Image of menu entry 4 has been corrected.
FINISHED: Image of menu entry 5 has been corrected.
1.0 Beta 4 to 1.0 RC 1 Upgrade Applied Successfully!
1.0 RC 1 to 1.0 RC 2 part 1 Upgrade Applied Successfully!
1.0 RC 1 to 1.0 RC 2 part 2 Upgrade Applied Successfully!
1.0 RC 1 to 1.0 RC 2 part 3 failed! SQL error:DB function failed with error number 1146
Table 'jplagard_mamb1.mos_comprofiler_members' doesn't exist SQL=ALTER TABLE `mos_comprofiler_members` ADD `reason` MEDIUMTEXT default NULL AFTER `membersince`
SQL =
ALTER TABLE `mos_comprofiler_members` ADD `reason` MEDIUMTEXT default NULL AFTER `membersince`
1.0 RC 1 to 1.0 RC 2 part 3 Upgrade Applied Successfully!
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1146
Table 'jplagard_mamb1.mos_comprofiler_members' doesn't exist SQL=ALTER TABLE `mos_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
SQL =
ALTER TABLE `mos_comprofiler_members` ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1146
Table 'jplagard_mamb1.mos_comprofiler_members' doesn't exist SQL=ALTER TABLE `mos_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
SQL =
ALTER TABLE `mos_comprofiler_members` ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 failed! SQL error:DB function failed with error number 1146
Table 'jplagard_mamb1.mos_comprofiler_members' doesn't exist SQL=ALTER TABLE `mos_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` );
SQL =
ALTER TABLE `mos_comprofiler_members` ADD INDEX `membrefid` ( `memberid` , `referenceid` );
1.0 RC 2, 1.0 and 1.0.1 to 1.0.2 Upgrade Applied Successfully!
1.0.2 to 1.1 Upgrade Applied Successfully!
/home/jplagard/public_html/avemux//images/comprofiler/ Successfully added!
/home/jplagard/public_html/avemux//images/comprofiler/gallery/ Successfully added!
airplane.gif Successfully added to the gallery!
ball.gif Successfully added to the gallery!
butterfly.gif Successfully added to the gallery!
car.gif Successfully added to the gallery!
dog.gif Successfully added to the gallery!
duck.gif Successfully added to the gallery!
fish.gif Successfully added to the gallery!
frog.gif Successfully added to the gallery!
guitar.gif Successfully added to the gallery!
kick.gif Successfully added to the gallery!
pinkflower.gif Successfully added to the gallery!
redflower.gif Successfully added to the gallery!
skater.gif Successfully added to the gallery!
index.html Successfully added to the gallery!
Installation finished. Important: Please read README.TXT and manual for further settings.
Upload universal - Failed
Fatal: Installer error with /home/jplagard/public_html/avemux/media/install_46bb488e9c028/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.
[ Continue ... ]
EDIT: Changed title and made thread sticky.
Post edited by: beat, at: 2007/08/11 13:29