Problems with XP Load/save

gs560 · Post by **gs560** » Sat Nov 10, 2007 6:29 pm

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.

Post by **YamiKaitou** » Sat Nov 10, 2007 7:46 pm

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

gs560 · Post by **gs560** » Sun Nov 11, 2007 10:06 am

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...

Post by **YamiKaitou** » Sun Nov 11, 2007 11:19 am

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

gs560 · Post by **gs560** » Sun Nov 11, 2007 12:07 pm

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)

gs560 · Post by **gs560** » Sun Nov 11, 2007 12:10 pm

HERE is Error log

gs560 · Post by **gs560** » Sun Nov 11, 2007 12:21 pm

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

Post by **YamiKaitou** » Sun Nov 11, 2007 12:36 pm

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

gs560 · Post by **gs560** » Sun Nov 11, 2007 1:44 pm

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...

gs560 · Post by **gs560** » Sun Nov 11, 2007 1:48 pm

Code: Select all

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...

Post by **YamiKaitou** » Sun Nov 11, 2007 2:19 pm

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

gs560 · Post by **gs560** » Sun Nov 11, 2007 2:26 pm

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

Post by **YamiKaitou** » Sun Nov 11, 2007 2:52 pm

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

gs560 · Post by **gs560** » Mon Nov 12, 2007 5:09 pm

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

slmclarengt · Post by **slmclarengt** » Tue Nov 13, 2007 12:18 am

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

gs560 · Post by **gs560** » Tue Nov 20, 2007 4:43 am

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?

Post by **Geesu** » Wed Nov 21, 2007 2:37 pm

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

Warcraft 3 MODs

Problems with XP Load/save

Problems with XP Load/save

HERE is Error Log

My server hosting provider

Error again

shit...