advanced menu for ezportal sql fout

[Php]

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:

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;

[Paul]

PRobeer:

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`)
) ;
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`)
) ;

[Php]

Dit werkt.