Player cant choose or change race?

Daver · Post by **Daver** » Tue Aug 07, 2007 11:01 pm

I have a player who became admin in my War3ft server and he suddenly cant chosse or change to any race. He was playing fine saving XP and he said all of the sudden this just happened.

Any ideas?

Strange problem but I was in the same server at the same time and all my races are fine...

Thx in advance,

Daver

--- Please enter the following information for support ---
War3ft Version: 2.3.2
Amxmodx Version: 1.75a
Metamod Version: 1.19p28
amxx list:
amxx modules:

meta list:Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.75a ini ANY ANY
[ 2] SBSRV RUN - sbsrv_mm_i386.so v3.4 ini Start Never
[ 3] POD-Bot mm RUN - podbot_mm_i386.s vR2b46d ini Chlvl ANY
[ 4] Fun RUN - fun_amxx_i386.so v1.75 pl1 ANY ANY
[ 5] Engine RUN - engine_amxx_i386 v1.75 pl1 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx_i3 v1.75 pl1 ANY ANY
[ 7] MySQL RUN - mysql_amxx_i386. v1.75 pl1 ANY ANY
[ 8] CStrike RUN - cstrike_amxx_i38 v1.75 pl1 ANY ANY
[ 9] CSX RUN - csx_amxx_i386.so v1.75 pl1 ANY ANY
[10] War3ft RUN - war3ft_amxx_i386 v2.2.5 pl1 ANY ANY
10 plugins, 10 running

DesasterUK · Post by **DesasterUK** » Wed Aug 08, 2007 7:51 am

Have u made any updates/changes to your server?
amxx update or something else?

maybe there is the problem.
not sure, but i think war3ft 2.3.2 is developed for amxx 1.71
otherway your meta list shows v2.2.5 for war3ft

Post by **YamiKaitou** » Wed Aug 08, 2007 8:49 am

Way outdated version of War3FT. Either upgrade to 2.3.2 or upgrade 3.0RC8

Daver · Post by **Daver** » Wed Aug 08, 2007 8:05 pm

I know the version is way outa date, but my players didnt want to lose the XP and I thought the new and older version were not compatable to keep the xp.

Ok, Ive have upgraded now to the 3.0 rc8 version and the plugin is running but there is no race choice so you cant choose a race still. I used the download with all the stuff in it from metamod and amxmodx too. If i give xp it show getting it but says you cant use it till you pick a race...
Could it be in the data base? I checked that and it said for version there where I was using it on another server that ity was that old version rc 6 beta6 Can I just edit that to rc 8? Or do I need to change something in the mysql...

Daver

Post by **YamiKaitou** » Wed Aug 08, 2007 10:31 pm

If you don't want to lose xp, just upgrade to 2.3.2. Then, once the conversion script has been fixed and confirmed that it works, upgrade to 3.0

Daver · Post by **Daver** » Thu Aug 09, 2007 9:37 pm

OK, I dont even care about converting the xp.. I will start out fresh. I have version 3.0 rc8 insatlled and niow here is part of the error log:

L 08/09/2007 - 19:20:11: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:3691859';
L 08/09/2007 - 19:20:11: [ERROR] Unable to retreive user's (5) Unique ID, trying again...
L 08/09/2007 - 19:20:11: [MYSQLX] Error in querying database, location: 2
L 08/09/2007 - 19:20:11: [MYSQLX] Message: MySQL server has gone away (2006)
L 08/09/2007 - 19:20:11: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:8830399';
L 08/09/2007 - 19:20:11: [ERROR] Unable to retreive user's (3) Unique ID, trying again...
L 08/09/2007 - 19:20:11: [MYSQLX] Error in querying database, location: 2
L 08/09/2007 - 19:20:11: [MYSQLX] Message: MySQL server has gone away (2006)
L 08/09/2007 - 19:20:11: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = '';
L 08/09/2007 - 19:20:11: [ERROR] Unable to retreive user's (4) Unique ID, trying again...
L 08/09/2007 - 19:20:11: [MYSQLX] Error in querying database, location: 2
L 08/09/2007 - 19:20:11: [MYSQLX] Message: MySQL server has gone away (2006)
L 08/09/2007 - 19:20:11: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:3691859';
L 08/09/2007 - 19:20:11: [ERROR] Unable to retreive user's (5) Unique ID, trying again...
L 08/09/2007 - 19:20:11: [MYSQLX] Error in querying database, location: 2
L 08/09/2007 - 19:20:11: [MYSQLX] Message: MySQL server has gone away (2006)
L 08/09/2007 - 19:20:11: [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:1:12062892';
L 08/09/2007 - 19:20:11: [ERROR] Unable to retreive user's (6) Unique ID, trying again...
L 08/09/2007 - 19:20:11: ** Map 'de_simpsons' ended
L 08/09/2007 - 19:20:54: ** Map 'de_cpl_strike' started
L 08/09/2007 - 19:20:54: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 20:02:20: ** Map 'de_cpl_strike' ended
L 08/09/2007 - 20:13:03: ** Map 'de_dust4' started
L 08/09/2007 - 20:13:03: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 20:22:30: ** Map 'de_dust4' ended
L 08/09/2007 - 20:22:57: ** Map 'aim_ak-colt' started
L 08/09/2007 - 20:22:57: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 20:55:43: ** Map 'aim_ak-colt' ended
L 08/09/2007 - 21:12:10: ** Map 'de_dust' started
L 08/09/2007 - 21:12:10: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 21:14:10: ** Map 'de_dust' ended
L 08/09/2007 - 21:14:20: ** Map 'cs_italy' started
L 08/09/2007 - 21:14:20: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 21:15:06: ** Map 'de_dust' started
L 08/09/2007 - 21:15:06: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 21:19:32: ** Map 'de_dust' ended
L 08/09/2007 - 21:20:51: ** Map 'de_dust' started
L 08/09/2007 - 21:20:51: ** Plugin version: '3.0 RC8'
L 08/09/2007 - 21:54:31: ** Map 'de_dust' ended
L 08/09/2007 - 21:55:39: ** Map 'de_dust' started
L 08/09/2007 - 21:55:39: ** Plugin version: '3.0 RC8'

It keeps crashing and restarting.

Any ideas? Should I completely redo the database? Is there a sql script to setup the tables through phpmyadmin?

Thx,
Daver

Daver · Post by **Daver** » Sun Aug 12, 2007 9:46 pm

Any suggestions???

HaNz_BrIx · Post by **HaNz_BrIx** » Mon Aug 13, 2007 10:17 pm

please some one help daver, everybody is getting annoyed at the crashing

Post by **Geesu** » Tue Aug 14, 2007 7:03 am

No one can choose a race? B/c those errors stop appearing after the map changes which then makes it seem like it is working?

What is your server IP - also post your war3ft.cfg

HaNz_BrIx · Post by **HaNz_BrIx** » Tue Aug 14, 2007 9:01 am

it was i that was having that problem and i fixed it by getting a new Steam ID and re buying counter-strike

Daver · Post by **Daver** » Tue Aug 14, 2007 9:42 pm

Hello Geesu,
Long time no talk to. I have done as you requested in the server crashing post. I will go back to that thread so i can upload the bin log file and the problem hopefully wil be takin care of soon. What I am going to do is delete all the server files and start fresh, there must be something there causing a problem. Can someone post how to setup the tables for mysql. I tried the tutorial but it confusing cuz it talks about slqlite then mysql and all I ned to know is how to setup the tables for war3 ft 3.0 rc 8 . Will the server setup the tables as long as the database is all setup already?

Sorri for the noobie questions but I had rc6 running on another server and it ran without all these problems, and now Im older and dumber...

Daver

Daver · Post by **Daver** » Sat Aug 18, 2007 5:31 pm

Ok, No help here but it seems to be fixed for this problem which seemed to be the database not being found by the server. I think but am not sure, its just a guess, that when I tried to reuse after wiping out the table from a previous war3 version (2.3.2 Maybe) that the database did nt work correctly, it was nt remaking the tables after I deleted them and so I made a brand new database and then the server would connect and make the tables fine. So this problem seems to be fixed but now the server crashes quite a bit only on map changes.... Anyone know of a problem where when you change the map the server will lock up and crash? Is it possible that i have something set in the war3.cfg, like saving at the end of round or something like that, making it hangup?

Thx,

Daver