Possible Error in RC1 SQL?

[almambo]

Using phpMyAdmin, I create the database and try to run the mambo SQL file (mambo.sql) for a fresh Mambo 4.5.1 RC1 install, I get the following error:

INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO CREATE TABLE `#__menu` (

`id` int( 11 ) NOT NULL auto_increment,
`menutype` varchar( 25 ) default NULL ,
`name` varchar( 100 ) default NULL ,
`link` text,
`type` varchar( 50 ) NOT NULL default '',
`published` tinyint( 1 ) NOT NULL default '0',
`parent` int( 11 ) unsigned NOT NULL default '0',
`componentid` int( 11 ) unsigned NOT NULL default '0',
`sublevel` int( 11 ) default '0',
`ordering` int( 11 ) default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int( 11 ) NOT NULL default '0',
`browserNav` tinyint( 4 ) default '0',
`access` tinyint( 3 ) unsigned NOT NULL default '0',
`utaccess` tinyint( 3 ) unsigned NOT NULL default '0',
`params` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `componentid` ( `componentid` , `menutype` , `published` , `access` ) ,
KEY `menutype` ( `menutype` )
) TYPE = MYISAM

MySQL said:


You have an error in your SQL syntax near 'INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT I' at line 1


Afer investigating mambo.sql, I see the following in the file:
INSERT INTO #__mambots VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0, '0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (4,'BB Code support','mosbbcode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (5,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (6,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (7,'Search Content','content.searchbot','search',0,1,1,1,0,0, '0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (8,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0, 0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (9,'Code support','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');

INSERT INTO #__mambots VALUES (10,'No Editor','none','editors',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (11,'RTE Editor','rte','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO #__mambots VALUES (12,'TinyMCE Editor','tinymce','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');

# --------------------------------------------------------

#
# Table structure for table `#__menu`
#

As you can see, the quotes are missing in the Insert statements.

[almambo]

In case you encounter the same problem with mambo.sql, replace the INSERT statements at lines 347-359 with:
INSERT INTO `#__mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0, '0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (4,'BB Code support','mosbbcode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (5,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (6,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (7,'Search Content','content.searchbot','search',0,1,1,1,0,0, '0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (8,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0, 0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (9,'Code support','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');

INSERT INTO `#__mambots` VALUES (10,'No Editor','none','editors',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (11,'RTE Editor','rte','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO `#__mambots` VALUES (12,'TinyMCE Editor','tinymce','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');

This worked for me and I succeded in creating the database.

[Se7eN]

Same error exists in the sample data file (sample_data.sql)

change :
UPDATE #__categories SET count=5 WHERE id=1;
into
UPDATE `#__categories` SET count=5 WHERE id=1;
and you're set.

Se7eN

[mgerrard]

I'm a bit confused. If you do a manual install of the DB are you supposed to replace the #_ with mos or whatever you want as a table prefix? I can't get the sql to run without getting rid of the # (it probably automatically replaces it in the auto installation)

[SvenErik]

Yes, you have to change the #__ into the tableprefix you choose, usually it is mos_ . The DB file is meant to be used by the installer and it will change the #__ prefix based on your choice during installation. I guess it would be easier if they had included a /sql folder in the root with DB files meant for manual installation in addition to the /installation/sql folder meant for the installer.