Xp loading problem at mapchange

Senne · Post by **Senne** » Sun Mar 04, 2007 1:49 pm

Hi,

the new mod war3ft is working fine, only i'm getting a problem with the first round after a mapchange.
Everyone types then changerace bec the menu doesnt come up automatically.
And then it looks like the war3 database (mysql 5.0) gets overloaded orso (about 8 players wanting to changerace at the same moment).
And the changerace menu doesnt pop up. Then one round later it does pop-up but it gives the players all a 0 xp race while they did level it before. If i then changemap or restart round, that races xp is gone but the other races are fine.

Here is the errorlog file :

Code: Select all

L 03/04/2007 - 13:38:18: Start of error session.
L 03/04/2007 - 13:38:18: Info (map "de_dust") (logfile "error_030407.log")
L 03/04/2007 - 13:38:18: [MySQL] Invalid handle: 0
L 03/04/2007 - 13:38:18: [AMXX] Displaying debug trace (plugin "war3ft.amxx")
L 03/04/2007 - 13:38:18: [AMXX] Run time error 10: native error (native "log_amx")
L 03/04/2007 - 13:38:18: [AMXX]    [0] db_mysqlx.inl::MYSQLX_Close (line 347)
L 03/04/2007 - 13:38:18: [AMXX]    [1] db_common.inl::DB_Close (line 133)
L 03/04/2007 - 13:38:18: [AMXX]    [2] war3ft.sma::plugin_end (line 271)

here is the normal log f ile :

Code: Select all

L 03/04/2007 - 13:35:27: -------- Mapchange to de_dust --------
L 03/04/2007 - 13:35:30: [AMXX] Failed to open dictionary file: cstrike\addons\amxmodx\data\lang\admin_allinone.txt
L 03/04/2007 - 13:35:40: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2013] Lost connection to MySQL server during query
L 03/04/2007 - 13:35:40: [admin.amxx] Login: "[S:S] Retard On Bicycle<79><STEAM_0:1:9507118><>" became an admin (account "STEAM_0:1:9507118") (access "acdefijmnopqrsu") (address "71.112.76.21")
L 03/04/2007 - 13:35:40: [admin.amxx] Login: "Senne<58><STEAM_0:0:3637317><>" became an admin (account "STEAM_0:0:3637317") (access "abcdefghijklmnopqrstu") (address "81.164.42.109")
L 03/04/2007 - 13:35:41: [admin.amxx] Login: "[S:S] Retard On Bicycle<79><STEAM_0:1:9507118><>" became an admin (account "STEAM_0:1:9507118") (access "acdefijmnopqrsu") (address "71.112.76.21")
L 03/04/2007 - 13:35:41: [admin.amxx] Login: "Senne<58><STEAM_0:0:3637317><>" became an admin (account "STEAM_0:0:3637317") (access "abcdefghijklmnopqrstu") (address "81.164.42.109")
L 03/04/2007 - 13:35:41: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:41: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:41: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:41: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:41: [mapmanager.amxx] DeagsMapManager - Found 12 Maps in your mapcycle.txt/allmaps.txt file, 12 are available for filling slots.
L 03/04/2007 - 13:35:42: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:42: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:42: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:42: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:42: [mapmanager.amxx] DeagsMapManager - Did not ban any maps from mapstoban.ini file.
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:43: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:47: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:47: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:47: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:47: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:48: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:48: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:48: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:48: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:51: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:51: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:51: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:51: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:52: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:52: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:52: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:52: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:55: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:55: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:55: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:55: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:35:56: [mapmanager.amxx] DeagsMapManager - Loaded 3 maps into the maps that will be picked for the vote.
L 03/04/2007 - 13:35:56: [mapmanager.amxx] DeagsMapManager - 2 Maps were not loaded because they were the last maps played, or defined twice, or banned.
L 03/04/2007 - 13:35:56: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:35:56: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:35:56: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:35:56: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:00: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:36:00: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:00: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:00: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:01: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:36:01: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:01: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:01: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:02: [amxbans.amxx] [AMXBANS] AMXBans 5.0 is online
L 03/04/2007 - 13:36:02: [amxbans.amxx] [AMXBANS] No reasons found in data base. Static reasons was loaded instead
L 03/04/2007 - 13:36:34: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:36:34: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:34: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:34: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:38: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:36:38: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:38: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:38: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:46: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:36:46: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:46: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:46: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:49: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:36:49: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:49: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:49: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:53: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:36:53: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:53: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:53: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:36:58: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:36:58: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:36:58: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:36:58: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:03: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:04: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:04: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:04: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:04: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:05: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:05: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:05: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:05: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:06: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:06: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:06: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:06: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:07: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:08: [adminchat.amxx] Chat: "Senne<58><STEAM_0:0:3637317><>" tsay "just wait a sec it will come up"
L 03/04/2007 - 13:37:08: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:08: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:08: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:08: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:09: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:09: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:09: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:09: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:10: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:10: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:10: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:10: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:11: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:16: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:16: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:16: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:16: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:23: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:23: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:23: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:23: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:24: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:24: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:24: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:24: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:25: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:30: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:30: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:30: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:30: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:34: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:35: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:35: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:35: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:35: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:36: [war3ft.amxx] [MYSQLX] Threaded query error, location: 5
L 03/04/2007 - 13:37:36: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:36: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:36: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:39: [adminchat.amxx] Chat: "Senne<58><STEAM_0:0:3637317><>" tsay "try changngrace again and see what it says"
L 03/04/2007 - 13:37:39: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:39: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:39: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:39: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:40: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:40: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:40: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:40: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:41: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:42: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:42: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:42: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:42: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:46: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:47: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:47: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:47: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:47: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:49: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:49: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:49: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:49: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:50: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:50: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:50: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:50: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:51: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:51: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:51: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:51: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:52: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:53: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:54: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:37:54: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:54: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:54: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:55: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:55: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:55: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:55: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:56: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:57: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:37:57: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:57: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:57: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:58: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:37:58: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:58: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:58: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:37:59: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:37:59: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:37:59: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:37:59: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:03: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:07: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:07: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:07: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:07: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:08: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:15: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:16: [admincmd.amxx] Cmd: "Senne<58><STEAM_0:0:3637317><>" changelevel "de_dust2"
L 03/04/2007 - 13:38:16: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:16: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:16: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:16: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:17: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:17: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:17: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:17: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:18: [mapmanager.amxx] DeagsMapManager - |.desi.| - Snakieeee has left; de_dust2 is no longer nominated
L 03/04/2007 - 13:38:18: [war3ft.amxx] [ERROR] '[MySQL] Invalid handle: 0' '10' '1' 'Run time error 10: native error (native "SQL_FreeHandle")'
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 3
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Threaded query error, location: 2
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Message: Unknown column '' in 'where clause' (1054)
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:38:28: [war3ft.amxx] [MYSQLX] Fail state: Query Failed
L 03/04/2007 - 13:38:28: -------- Mapchange to de_dust2 --------
L 03/04/2007 - 13:38:29: [AMXX] Failed to open dictionary file: cstrike\addons\amxmodx\data\lang\admin_allinone.txt
L 03/04/2007 - 13:38:31: [admin.amxx] Login: "[S:S] Retard On Bicycle<79><STEAM_0:1:9507118><>" became an admin (account "STEAM_0:1:9507118") (access "acdefijmnopqrsu") (address "71.112.76.21")
L 03/04/2007 - 13:38:31: [admin.amxx] Login: "Senne<58><STEAM_0:0:3637317><>" became an admin (account "STEAM_0:0:3637317") (access "abcdefghijklmnopqrstu") (address "81.164.42.109")
L 03/04/2007 - 13:38:32: [mapmanager.amxx] DeagsMapManager - Found 12 Maps in your mapcycle.txt/allmaps.txt file, 12 are available for filling slots.
L 03/04/2007 - 13:38:33: [mapmanager.amxx] DeagsMapManager - Did not ban any maps from mapstoban.ini file.
L 03/04/2007 - 13:38:45: [amxbans.amxx] [AMXBANS] AMXBans 5.0 is online
L 03/04/2007 - 13:38:45: [amxbans.amxx] [AMXBANS] No reasons found in data base. Static reasons was loaded instead
L 03/04/2007 - 13:38:47: [mapmanager.amxx] DeagsMapManager - Loaded 4 maps into the maps that will be picked for the vote.
L 03/04/2007 - 13:38:47: [mapmanager.amxx] DeagsMapManager - 1 Maps were not loaded because they were the last maps played, or defined twice, or banned.
L 03/04/2007 - 13:41:56: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 03/04/2007 - 13:41:56: [war3ft.amxx] [MYSQLX] Message: Lost connection to MySQL server during query (2013)
L 03/04/2007 - 13:41:56: [war3ft.amxx] [MYSQLX] Query statement:  
L 03/04/2007 - 13:41:56: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed

as you can see its pretty odd...

Anyway to fix this?

I thought icould maybe disable savingxp at the nd of each round, so if they get 0 xp they just need to reconnect. But then i should be able to enable the /savexp command. How do i do this?

--- Please enter the following information for support ---
War3ft Version: 3.0 RC5
Amxmodx Version: 1.76c
Metamod Version:
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Sun Mar 04, 2007 2:06 pm

Well, your problem is the third line in your log. This one

L 03/04/2007 - 13:35:40: [war3ft.amxx] [MYSQLX] Database Connection Failed: [2013] Lost connection to MySQL server during query

Find out why it can't connect and you can fix it

Senne · Post by **Senne** » Sun Mar 04, 2007 4:01 pm

could it be that the mysql is to far ?

the gameserver is in Chicago and the mysql is in holland, so i'm guessing its located to far?
i had no idea this would have been an issue tho.

Could i correct this issue by letting the xp only save at the end of the map? Is there then an option to enable the savexp command, so ppl can say savexp when they leave and the xp still saves?

erik2k3 · Post by **erik2k3** » Mon Mar 05, 2007 8:06 pm

no, it doesnt matter WHERE the SQL server is located at.

once you have the gameserver and the sql server running on different machines, a new problem comes up :

the SQL-Server most likely will not accept any connections except localhost, meaning :

your gameserver tries to establish a connection with your SQL-Server, the SQL-Server refuses the connection because it is not coming from the localhost. Go to phpmy admin and set the host field for the database to either "%" or the specific ip of your gameserver.

otherwise :

disable SQL and use the vault file....

Post by **YamiKaitou** » Mon Mar 05, 2007 10:11 pm

No, don't use nVault. I am trying to save people the torment of losing their xp. nVault is disappearing in RC6.

Yes, it does matter where the SQL is located in releation to the gameserver. The furthur it is, the longer the query takes. Though it is slight, it does make a difference.

His error is saying that he did get connected, just connection was lost. They said they are using AmxBans on the SQL and it is connecting fine, so it is not the initial connection.

I believe the option to save xp using the savexp command was abandon a while ago.

Senne · Post by **Senne** » Tue Mar 06, 2007 5:16 am

ok.

like you said my mysql and gameserver were doing fine,untill 8+ ppl joined... then the connection got lost.

Ill try to wait on the SQLITE maker to give me a hand if he wants

to bad the savexp option is abbandonned , i still see many users typing savexp when they leave lol.