In Progress

Game

Hi...

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

Skills:

See more: 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, game line, ban script mysql, table error, backup sql script, sql error site, game database

About the Employer:
( 159 reviews ) Craighall, South Africa

Project ID: #198128

Awarded to:

anode

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

$30 USD in 1 day
(210 Reviews)
5.4