AlliedModders - [Wc3FT] Issue with Mysql database

AlliedModders (https://forums.alliedmods.net/index.php)

- Suggestions / Requests (https://forums.alliedmods.net/forumdisplay.php?f=12)

- - [Wc3FT] Issue with Mysql database (https://forums.alliedmods.net/showthread.php?t=199087)

[Wc3FT] Issue with Mysql database

Hello all,

I'm currently setting a new warcraft3 mod for my server, but I have an issue with my database.
After starting the server, I get this error:

Code:

[WAR3FT] MySQL X database connection successful

L 10/24/2012 - 07:57:42: [war3ft.amxx] [MYSQLX] Error in querying database, location: 1

L 10/24/2012 - 07:57:42: [MYSQLX] Error in querying database, location: 1

L 10/24/2012 - 07:57:42: [war3ft.amxx] [MYSQLX] Message: 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 '(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)

L 10/24/2012 - 07:57:42: [MYSQLX] Message: 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 '(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)

L 10/24/2012 - 07:57:42: [war3ft.amxx] [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`pL 10/24/2012 - 07:57:42: [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), L 10/24/2012 - 07:57:43:

The plugin, could not create the needed tables.
I also tried manually importing them in the DB, but there were other errors there.

MySQL version: 5.5.20

A friend gave me a DB with the tables already created. The same error appears.

Re: [Wc3FT] Issue with Mysql database

It has to do with MySQL 5.5 I believe. Use a previous MySQL version or create the tables manually and remove the automatic creation steps from the plugin

Re: [Wc3FT] Issue with Mysql database

Quote:

Originally Posted by YamiKaitou (Post 1824597)

It has to do with MySQL 5.5 I believe. Use a previous MySQL version or create the tables manually and remove the automatic creation steps from the plugin

A little hint for the second option?
I tried editing the db_mysqlx.inl file, but without any success.

Re: [Wc3FT] Issue with Mysql database

i resolved that error, pm me if you need anything, i am afraid to post because i got banned when i posted the resolvation of that error

Re: [Wc3FT] Issue with Mysql database

Not sure why you think that. We don't ban people for fixing old plugins

Re: [Wc3FT] Issue with Mysql database

Ive bumped into same problem now.
ak3xx if you know how to fix it, tell us, because i see you say in other forums too that you know how to fix it...

Quote:

Originally Posted by YamiKaitou (Post 1824597)

It has to do with MySQL 5.5 I believe. Use a previous MySQL version or create the tables manually and remove the automatic creation steps from the plugin

how to do that ? ^ :)

Or is there any other way i can fix this problem?

Heres my problem:

Quote:

[WAR3FT] MySQL X database connection successful
L 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Error in querying database, location: 1
L 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Message: 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 '(14) NOT NULL, PRIMARY KEY (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)
L 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY (`player_id`), KEY `player_name` (`pL 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Error in querying database, location: 7
L 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Message: Table 'wc3exp.wc3_config' doesn't exist (1146)
L 01/17/2014 - 13:42:39: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' );
Connection to Steam servers successful.
VAC secure mode is activated.

Re: [Wc3FT] Issue with Mysql database

Quote:

Originally Posted by fjollerik (Post 2098384)

bump :attack:

I'm with you my friend... bump. I've been on google, war3 forums and other random forums for the past 45 minutes without finding the answer to this.

Can someone provide us with a solution or the table sql import code.

Re: [Wc3FT] Issue with Mysql database

Ohh mann.. I thought this thread was dead

jungojang, Would you tell me if you get any news??

So sad to get stuck here :(

Re: [Wc3FT] Issue with Mysql database

PHP Code:


		
			
"CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KEY `player_ip` (`player_ip`), KEY `player_steamid` (`player_steamid`) )",
    "CREATE TABLE IF NOT EXISTS `wc3_player_extra` ( `player_id` INT( 8 ) UNSIGNED NOT NULL , `player_steamid` VARCHAR( 25 ) NOT NULL , `player_ip` VARCHAR( 20 ) NOT NULL , `player_name` VARCHAR( 35 ) NOT NULL , PRIMARY KEY ( `player_id` ))",
    "CREATE TABLE IF NOT EXISTS `wc3_player_race` ( `player_id` int(8) unsigned NOT NULL default '0', `race_id` tinyint(4) unsigned NOT NULL default '0', `race_xp` int(8) default NULL, PRIMARY KEY  (`player_id`,`race_id`) )",
    "CREATE TABLE IF NOT EXISTS `wc3_player_skill` ( `player_id` int(8) unsigned NOT NULL default '0', `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_level` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY  (`player_id`,`skill_id`) )",
    "CREATE TABLE IF NOT EXISTS `wc3_web_race` ( `race_id` tinyint(4) unsigned NOT NULL default '0', `race_lang` char(2) NOT NULL default '', `race_name` varchar(100) default NULL, `race_description` text NOT NULL, PRIMARY KEY  (`race_id`,`race_lang`) )",
    "CREATE TABLE IF NOT EXISTS `wc3_web_skill` ( `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_lang` char(2) NOT NULL default '', `skill_name` varchar(100) default NULL, `skill_description` text NOT NULL, `skill_type` tinyint(4) unsigned NOT NULL default '0', `skill_owner` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY  (`skill_id`,`skill_lang`) )",
    "CREATE TABLE IF NOT EXISTS `wc3_config` ( `config_id` varchar(50) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY  (`config_id`) )"
};

edit in db_mysqlx.inl file.