18th January 2018, 11:19
|
Senior Member
|
|
Join Date: Jul 2008
Posts: 34
|
|
Quote:
Originally Posted by DjBlack
Hi when install this script show me this
Processing file: torrent.sql
Starting at the line: 1
Error at the line 17: ) TYPE=MyISAM;
Query: CREATE TABLE `addedrequests` ( `id` int(10) unsigned NOT NULL auto_increment, `requestid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`id`), KEY `userid` (`userid`), KEY `requestid_userid` (`requestid`,`userid`) ) TYPE=MyISAM;
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Stopped on error
whats is wrong how to fix
|
TYPE is depracated. Use ENGINE=MyISAM everywhere
|