I am trying to up grade my site to version 4.4 and getting errors with mysql...this is one of them:
ySQL Create Database Error!
CREATE TABLE `ban` ( `id` smallint(6) unsigned NOT NULL auto_increment, `ip` varchar(15) NOT NULL default '', `userid` smallint(8) unsigned NOT NULL default '0', UNIQUE KEY `id` (`id`,`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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 'DEFAULT CHARSET=latin1' at line 6
The old database also needs to be restored and this needs to be done:
You need to re-create the backup with:
-Q, --quote-names Quote table and column names with a `
The quote on the project must be to get site back up and running with version 4.4 the script I am using is Gamescript....