Warcraft 3 MODs

So server starting new map, exp loaded and can be saved but after 5 minutes of map start people who connect don't get exp and server writing that XP cannon be loaded from database please contact admin...

so can somebody help me please./\
all my configs are here.

Please only post in one location.


Please provide us with more details, such as wc3ft version, amxx version


And, if the server is Steam or Non-Steam

WAR3FT Version RC8
AMXX 1.76d
Server : Steam


i use 1 database for amxbans and war3ft.. is it okey?(Amxbans 5.0 and war3ft RC8) ?

and im using WAR3FT + CSDM maybe this is problem as well...

No, that should be fine. Although, I had looked at your config files, you missed on, your war3ft.cfg. If you are going to give use your config files, that one is the most important.


Look in the configs/wc3_error.log file to see if there is an exact message being printed

L 11/11/2007 - 18:57:08: [MYSQLX] Error in querying database, location: 12
L 11/11/2007 - 18:57:08: [MYSQLX] Message: SELECT command denied to user 'gs560_stats'@'195.242.238.210' for table 'tables' (1142)
L 11/11/2007 - 18:57:08: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'gs560_stats' AND table_name = 'war3users';


=================

L 11/11/2007 - 19:10:59: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/11/2007 - 19:10:59: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:16898903';
L 11/11/2007 - 19:10:59: [ERROR] Unable to retreive user's (1) Unique ID, trying again...
L 11/11/2007 - 19:10:59: [MYSQLX] Error in querying database, location: 2
L 11/11/2007 - 19:10:59: [MYSQLX] Message: MySQL server has gone away (2006)

HERE is Error log

My hosting provider is http://www.inx-gaming.co.uk/
there is free webhosting as well so maybe they block something...

Look here. viewtopic.php?p=16587#16587

I did that and recompile plugin but got another error


L 11/11/2007 - 20:40:03: [MYSQLX] Error in querying database, location: 2
L 11/11/2007 - 20:40:03: [MYSQLX] Message: MySQL server has gone away (2006)
L 11/11/2007 - 20:40:03: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:16881063';
L 11/11/2007 - 20:40:03: [ERROR] Unable to retreive user's (10) Unique ID, trying again...

There is nothing we can do about that error. The server is loosing connection to the MySQL database

why it happend like this? something wrong with webhosting provider or with server?

Firewall issues, timeout settings, etc. It could be either side or a combination of both

Is it okey if in database are not recorded any names and ips but only steam_id?

YamiKaitou wrote:There is nothing we can do about that error. The server is loosing connection to the MySQL database

It seems this issue is quite a bit more prevalent in v3.0 but as far as I recall 2.3.2 was not so problematic - I'm wondering if 3.0 still needs quite a bit more work before being even suitable to be released because it seems to have had such a major overhaul, many issues are popping up not in 2.3.2. I was told by Bail to start programming again because I let myself drop it so now I may start actually writing again depending on the amount of time I have available... So I may do some work on WC3FT as it seems Geesu is also quite busy/bored maybe.

Slmclarengt

If i change from 3.0RC8 version to 2.3.2 is there some way to save xp?
or just keep same database and only reinstall plugins and exp will be loaded without any problems?

Started a thread on AMX X:

http://forums.alliedmods.net/showthread.php?t=63460

I'm confused as to what to do - i could catch the error, close the mysql connection, and try to re-open... But I'd hate to do that b/c it seems like a hack to fix it