Msql foutje hacks list mod
Geplaatst: 26 jun 2004, 12:16
Kan iemand mij helpen?, ik krijg een fout bij het uitvoeren van deze sql:
staat in nivisec_install.php, maar ik krijg deze fout:
PLZ, I NEED HELP
tnx!
Code: Selecteer alles
$sql_queue = array(
"CREATE TABLE `phpbb_hacks_list` (
`hack_id` mediumint(8) unsigned NOT NULL auto_increment,
`hack_name` varchar(255) NOT NULL default '',
`hack_desc` varchar(255) NOT NULL default '',
`hack_author` varchar(255) NOT NULL default '',
`hack_author_email` varchar(255) NOT NULL default '',
`hack_author_website` tinytext NOT NULL,
`hack_version` varchar(32) NOT NULL default '',
`hack_hide` enum('Yes','No') NOT NULL default 'No',
`hack_download_url` tinytext NOT NULL,
`hack_file` varchar(255) NOT NULL default '',
`hack_file_mtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`hack_id`),
UNIQUE KEY `hack_name` (`hack_name`),
KEY `hack_file` (`hack_file`)
KEY `hack_hide` (`hack_hide`)
) TYPE=MyISAM"
);Code: Selecteer alles
[FAILED] :: CREATE TABLE `flex_hacks_list` ( `hack_id` mediumint(8) unsigned NOT NULL auto_increment, `hack_name` varchar(255) NOT NULL default '', `hack_desc` varchar(255) NOT NULL default '', `hack_author` varchar(255) NOT NULL default '', `hack_author_email` varchar(255) NOT NULL default '', `hack_author_website` tinytext NOT NULL, `hack_version` varchar(32) NOT NULL default '', `hack_hide` enum('Yes','No') NOT NULL default 'No', `hack_download_url` tinytext NOT NULL, `hack_file` varchar(255) NOT NULL default '', `hack_file_mtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`hack_id`), UNIQUE KEY `hack_name` (`hack_name`), KEY `hack_file` (`hack_file`) KEY `hack_hide` (`hack_hide`) ) TYPE=MyISAM
Reason:You have an error in your SQL syntax near 'KEY `hack_hide` (`hack_hide`) ) TYPE=MyISAM' at line 16
tnx!