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....


Näytä lisää: n .game-server, syntax, null, grade, grade 8, game server, game script, mysql create database engine, backup sql mysql, game server mysql, sql backup mysql, check table mysql script, mysql backup table, sql syntax error, mysql sql syntax, error sql syntax site, userid, game error, sql syntax, mysql script check table

Tietoa työnantajasta:
( 159 arvostelua ) Craighall, South Africa

Projektin tunnus: #198128

Myönnetty käyttäjälle:


Can do this. I faced similar problems in one of my projects. Thanks.

$30 USD 1 päivässä
(210 Arvostelua)