RC11
AMX Mod X 1.8.0
MetaMod v1.19p32
MySQL 5.0.45
I've a problem with XP save to MySQL
Code: Select all
[WAR3FT] MySQL X database connection successful
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Error in querying database, location: 1
L 06/08/2008 - 11:47:33: [MYSQLX] Error in querying database, location: 1
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Message: near "unsigned": syntax error (1)
L 06/08/2008 - 11:47:33: [MYSQLX] Message: near "unsigned": syntax error (1)
L 06/08/2008 - 11:47:33: [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 06/08/2008 - 11:47:33: [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 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Error in querying database, location: 7
L 06/08/2008 - 11:47:33: [MYSQLX] Error in querying database, location: 7
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Message: no such table: wc3_config (1)
L 06/08/2008 - 11:47:33: [MYSQLX] Message: no such table: wc3_config (1)
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' );
L 06/08/2008 - 11:47:33: [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' );
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Error in querying database, location: 12
L 06/08/2008 - 11:47:33: [MYSQLX] Error in querying database, location: 12
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Message: no such table: information_schema.tables (1)
L 06/08/2008 - 11:47:33: [MYSQLX] Message: no such table: information_schema.tables (1)
L 06/08/2008 - 11:47:33: [war3ft.amxx] [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'pr0' AND table_name = 'war3users';
L 06/08/2008 - 11:47:33: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'pr0' AND table_name = 'war3users';