I need Help with MySQL for Warcraft 3 FT

[shivarulez]

Hi,

thanks @ Lazarus Long for this Howto, it helped me a lot.

viewtopic.php?t=31

But i have a little Problem on Point VI 3.2; Converting Warcraft 3 FT vault.ini.

If i use

CREATE TABLE war3users ( playerid varchar(35) NOT NULL default '', playername varchar(35) NOT NULL default '', xp int(11) NOT NULL default '0', race tinyint(4) NOT NULL default '0', skill1 tinyint(4) NOT NULL default '0', skill2 tinyint(4) NOT NULL default '0', skill3 tinyint(4) NOT NULL default '0', skill4 tinyint(4) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (playerid,race) ) ENGINE=MyISAM ;
quit

i got the Error 1064.

ERROR 1064: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (pla

What im doing wrong?

OS: Debian 3.1 (Sarge)

Thanks a lot for your answer!

Greetz

Shiva

[Lazarus Long]

shivarulez:

And how about your MySQL server version? Debian Sarge carries 2 of them 4.0 and 4.1 so it matters.

You can always replace that SQL statement removing the "on update CURRENT_TIMESTAMP" and it should work for version 4.0.x.

I hope this helps,