Warcraft 3 MODs

Home to war3, war3ft, war3x and uwc3
https://forums.wc3mods.net/

Multiple errors

https://forums.wc3mods.net/viewtopic.php?t=3148

Page 1 of 1

Multiple errors

Posted: Tue Feb 05, 2008 5:32 pm
by slmclarengt
Ok here are some errors I encountered in my AMXX logs.

War3ft Version: RC8
Amxmodx Version: 1.8
Metamod Version: 1.19
amxx list:

Code: Select all

15:32:54 Currently loaded plugins:
                name                    version     author            file             status   
          [  1] AMXBans                 5.0         YoMama/Lux & lan  amxbans.amxx     debug    
          [  2] AmxBans Admin Base      1.76        AMXX Dev Team     admin_amxbans.a  running  
          [  3] Admin Commands          1.8.0.3660  AMXX Dev Team     admincmd.amxx    running  
          [  4] Admin Help              1.8.0.3660  AMXX Dev Team     adminhelp.amxx   running  
          [  5] Multi-Lingual System    1.8.0.3660  AMXX Dev Team     multilingual.am  running  
          [  6] Menus Front-End         1.8.0.3660  AMXX Dev Team     menufront.amxx   running  
          [  7] Commands Menu           1.8.0.3660  AMXX Dev Team     cmdmenu.amxx     running  
          [  8] Players Menu            1.8.0.3660  AMXX Dev Team     plmenu.amxx      running  
          [  9] Teleport Menu           1.8.0.3660  AMXX Dev Team     telemenu.amxx    running  
          [ 10] Maps Menu               1.8.0.3660  AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Admin Chat              1.8.0.3660  AMXX Dev Team     adminchat.amxx   running  
          [ 12] Anti Flood              1.8.0.3660  AMXX Dev Team     antiflood.amxx   running  
          [ 13] Scrolling Message       1.8.0.3660  AMXX Dev Team     scrollmsg.amxx   running  
          [ 14] Info. Messages          1.8.0.3660  AMXX Dev Team     imessage.amxx    running  
15:32:54  [ 15] Admin Votes             1.8.0.3660  AMXX Dev Team     adminvote.amxx   running  
          [ 16] TimeLeft                1.8.0.3660  AMXX Dev Team     timeleft.amxx    running  
          [ 17] Pause Plugins           1.8.0.3660  AMXX Dev Team     pausecfg.amxx    running  
          [ 18] Stats Configuration     1.8.0.3660  AMXX Dev Team     statscfg.amxx    running  
          [ 19] Restrict Weapons        1.8.0.3660  AMXX Dev Team     restmenu.amxx    running  
          [ 20] StatsX                  1.8.0.3660  AMXX Dev Team     statsx.amxx      running  
          [ 21] CS Misc. Stats          1.8.0.3660  AMXX Dev Team     miscstats.amxx   running  
          [ 22] Warcraft 3 Frozen Thro  3.0 RC10 B  Geesu & Avanderi  war3ft.amxx      debug    
          [ 23] AMX Super               3.7         Bmann_420 & Bo0m  amx_super-speed  running  
          [ 24] Admin Spectator ESP     1.3         KoST              admin_spec_esp.  running  
          [ 25] AMX Toggle Immunity     3.12        slmclarengt       amx_toggleimmun  running  
          [ 26] DeagsMapManager         2.40        Deags/JTP10181    deagsmapmanager  running  
          [ 27] Advanced Roll The Dice  v2.5 RC 4   Striker           roll_the_dice.a  running  
          [ 28] Spawn Protection        7.0         Peli              spawnprotection  running  
          [ 29] FakeFull Original       1.7.6       JTP10181/Freecod  fakefull_origin  running  
15:32:54  [ 30] Map Spawns Editor       1.0.16      iG_os             Map_Spawns_Edit  running  
          [ 31] Clan Vs. All            1.0         GHW_Chronic       clanvsall.amxx   running  
         31 plugins, 31 running
amxx modules:

Code: Select all

15:33:09 Currently loaded modules:
               name                    version     author               status     
          [ 1] MySQL                   1.8.0.3660  AMX Mod X Dev Team   running    
          [ 2] Fun                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 3] Engine                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 4] FakeMeta                1.8.0.3660  AMX Mod X Dev Team   running    
          [ 5] CStrike                 1.8.0.3660  AMX Mod X Dev Team   running    
          [ 6] CSX                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 7] SQLite                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 8] Sockets                 1.8.0.3660  HLSW Dev Team        running    
         8 modules, 8 correct
meta list:

Code: Select all

15:33:45 Currently loaded plugins:
               description      stat pend  file              vers      src   load  unlod
          [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.8.0.3  ini   Start ANY  
          [ 2] SBSRV            RUN   -    sbsrv_mm.dll      v3.5.2    ini   Start Never
          [ 3] MySQL            RUN   -    mysql_amxx.dll    v1.8.0.3  pl1   ANY   ANY  
          [ 4] Fun              RUN   -    fun_amxx.dll      v1.8.0.3  pl1   ANY   ANY  
          [ 5] Engine           RUN   -    engine_amxx.dll   v1.8.0.3  pl1   ANY   ANY  
          [ 6] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.8.0.3  pl1   ANY   ANY  
          [ 7] CStrike          RUN   -    cstrike_amxx.dll  v1.8.0.3  pl1   ANY   ANY  
          [ 8] CSX              RUN   -    csx_amxx.dll      v1.8.0.3  pl1   ANY   ANY  
          [ 9] SQLite           RUN   -    sqlite_amxx.dll   v1.8.0.3  pl1   ANY   ANY  
         9 plugins, 9 running
Errors:

Code: Select all

L 02/04/2008 - 10:22:39: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/04/2008 - 10:22:39: [war3ft.amxx] [MYSQLX] Message: Can't connect to MySQL server on '74.50.8.250' (10060) (2003)
L 02/04/2008 - 10:22:39: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '19313', '4', '3219'); 
L 02/04/2008 - 10:22:39: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed

Code: Select all

L 02/04/2008 - 00:30:22: [war3ft.amxx] [ERROR] '[CSTRIKE] Invalid player 14' '10' '0' 'Run time error 10 (plugin "war3ft.amxx") (native "cs_get_user_nvg") - debug not enabled!'

Code: Select all

L 02/04/2008 - 11:21:22: [amxbans.amxx] [Amxbans] Connection failed!
L 02/04/2008 - 11:21:22: [amxbans.amxx] [Amxbans] Threaded query error, location: 17
L 02/04/2008 - 11:21:22: [amxbans.amxx] [Amxbans] Message: Can't connect to MySQL server on '<my site>.com' (10060) (2003)
L 02/04/2008 - 11:21:22: [amxbans.amxx] [Amxbans] Query statement:

Code: Select all

L 02/04/2008 - 18:42:07: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/04/2008 - 18:42:07: [war3ft.amxx] [MYSQLX] Message: Can't connect to MySQL server on '<my IP to my site>' (10060) (2003)
L 02/04/2008 - 18:42:07: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '18922', '4', '6755'); 
L 02/04/2008 - 18:42:07: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed
I do have more of the same errors but no point to post the same exact ones.

I am tempted to say my SQL host is a bit at fault as sometimes it resolves the DNS or the problem may be in the SQL module/WC3.

Slmclarengt

Posted: Wed Feb 06, 2008 9:23 am
by Geesu
You need to have debug enabled in order for me to fix run time errors - otherwise I don't know where the error is (also that error above doesn't matter... generally the invalid players are just warnings)

Message me on GTalk/AIM

Posted: Wed Feb 06, 2008 2:46 pm
by slmclarengt
Debugged:

Code: Select all

L 02/06/2008 - 00:13:11: [war3ft.amxx] [MYSQLX] Threaded query error, location: 4
L 02/06/2008 - 00:13:11: [war3ft.amxx] [MYSQLX] Message: Lost connection to MySQL server during query (2013)
L 02/06/2008 - 00:13:11: [war3ft.amxx] [MYSQLX] Query statement: UPDATE `wc3_player` SET time = NOW() WHERE ( `player_id` = '19685' ); 
L 02/06/2008 - 00:13:11: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed

Code: Select all

L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Error in querying database, location: 6
L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Message: Lost connection to MySQL server during query (2013)
L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Query statement: SELECT `skill_id`, `skill_level` FROM `wc3_player_skill` WHERE `player_id` = '10254';

Code: Select all

L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Message: Can't connect to MySQL server on 'mysql.nuclearfallout.net' (10060) (2003)
L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '22515', '1', '1866'); 
L 02/06/2008 - 00:11:31: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed

Code: Select all

L 02/06/2008 - 00:11:36: [war3ft.amxx] [MYSQLX] Error in querying database, location: 2
L 02/06/2008 - 00:11:36: [war3ft.amxx] [MYSQLX] Message: MySQL server has gone away (2006)
L 02/06/2008 - 00:11:36: [war3ft.amxx] [MYSQLX] Query statement: SELECT `player_id` FROM `wc3_player` WHERE `player_steamid` = 'STEAM_0:0:11082107'; 
L 02/06/2008 - 00:11:36: [war3ft.amxx] [MYSQLX] Attempting to re-establish connection to MySQL server

Code: Select all

L 02/06/2008 - 00:11:47: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/06/2008 - 00:11:47: [war3ft.amxx] [MYSQLX] Message: Can't connect to MySQL server on 'mysql.nuclearfallout.net' (10060) (2003)
L 02/06/2008 - 00:11:47: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '21622', '3', '2285'); 
L 02/06/2008 - 00:11:47: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed

Code: Select all

L 02/06/2008 - 00:14:54: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/06/2008 - 00:14:54: [war3ft.amxx] [MYSQLX] Message: Lost connection to MySQL server during query (2013)
L 02/06/2008 - 00:14:54: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '22607', '4', '28701'); 
L 02/06/2008 - 00:14:54: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed
L 02/06/2008 - 00:15:20: [admincmd.amxx] Cmd: "penislicker's 2 inch penis<345><STEAM_0:0:950611><>" ask for players list
L 02/06/2008 - 00:15:25: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 02/06/2008 - 00:15:25: [war3ft.amxx] [MYSQLX] Message: Lost connection to MySQL server during query (2013)
L 02/06/2008 - 00:15:25: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_player_race` ( `player_id` , `race_id` , `race_xp` ) VALUES ( '21599', '1', '19904'); 
L 02/06/2008 - 00:15:25: [war3ft.amxx] [MYSQLX] Fail state: Connection Failed
There are so many of these errors and I will just stop posting them because now they are all alike/same.

Slmclarengt

Posted: Thu Feb 07, 2008 8:46 pm
by kp_downarrow
these are just mysql erros, you lost the mysql database connection


still hatin nvault?

Posted: Wed Feb 13, 2008 11:33 am
by Geesu
Sorry man but I think the connect to your MySQL server sux... I haven't seen any reports yet of this message:

Lost connection to MySQL server during query
All times are UTC-06:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited