advanced menu for ezportal sql fout
Geplaatst: 09 sep 2005, 03:28
Ikprobeer de advanced menu for ezportal te installeren, maar krijg een sql foutmelding:
#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 'ENGINE=MyISAM' at line 7
M'n root is phpbb_
Dit is de sql opdracht:
#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 'ENGINE=MyISAM' at line 7
M'n root is phpbb_
Dit is de sql opdracht:
Code: Selecteer alles
CREATE TABLE `phpbb_portal_menu_categories` (
`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(100) default NULL,
`cat_order` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM;
CREATE TABLE `phpbb_portal_menu` (
`menu_id` mediumint(8) unsigned NOT NULL auto_increment,
`menu_name` varchar(255) NOT NULL default '',
`menu_url` varchar(255) NOT NULL default '',
`menu_target` tinyint(1) NOT NULL default '0',
`menu_auth` tinyint(1) NOT NULL default '0',
`cat_id` mediumint(8) NOT NULL default '0',
`menu_order` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM;