Interesting MYSQL Error Randomly Happening
Posted: Wed Apr 18, 2007 3:35 am
Allright so heres the problem. For some reason It will not Allow anyone to pick a race or anything it sais (something was wrong Selecting your information from the mysql server) or something like that.
Heres the error thats poping up in console.
I have went to phpmyadmin and I Created the db. I created the table needed etc.
The other wierd thing is after about 5 minutes it will let players actually pick a race but then its coming up with this error (when there xp auto saves)
Any help would be appresiated. P.S. The ADMIN list isnt loading either for amxmodx itself. so Im thinking its a problem with mysql
Ok Heres one more thing I have figured out for sure. IT IS Saving xp every NOW and then but other times its coming up with a error. Disconnected from the mysql very wierd.. Dont know why its doing this but it saves about 25% of the time.
amxx plugins
amxx modules
meta list
--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list:
Heres the error thats poping up in console.
Code: Select all
L 04/18/2007 - 09:02:38: [warcraft3FT.amxx] Connection to MySQL database successful
Stats disabled: Player Name
Total 1
L 04/18/2007 - 09:03:11: [warcraft3FT.amxx] Error in querying database, location: 0
L 04/18/2007 - 09:03:11: [warcraft3FT.amxx] Message: Lost connection to MySQL server during query (1)
L 04/18/2007 - 09:03:11: [warcraft3FT.amxx] Query statement: SELECT `xp`, `race` FROM `war3users` WHERE (`playerid` = 'BOT')
I have went to phpmyadmin and I Created the db. I created the table needed etc.
The other wierd thing is after about 5 minutes it will let players actually pick a race but then its coming up with this error (when there xp auto saves)
Code: Select all
L 04/18/2007 - 09:30:29: [warcraft3FT.amxx] Error in querying database, location: 3
L 04/18/2007 - 09:30:29: [warcraft3FT.amxx] Message: Lost connection to MySQL server during query (1)
L 04/18/2007 - 09:30:29: [warcraft3FT.amxx] Query statement: REPLACE INTO `hackshardwar3ft` (`playerid`, `playername`, `xp`, `race`, `skill1`, `skill2`, `skill3`, `skill4`) VALUES ('STEAM_0:1:3080450', '[TnG] TheGreatMp3', 57, 1, 0, 0, 0, 0)
Ok Heres one more thing I have figured out for sure. IT IS Saving xp every NOW and then but other times its coming up with a error. Disconnected from the mysql very wierd.. Dont know why its doing this but it saves about 25% of the time.
amxx plugins
Code: Select all
Currently loaded plugins:
name version author file status
[ 1] Admin Base 1.71 AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.71 AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.71 AMXX Dev Team adminhelp.amxx running
[ 4] Slots Reservation 1.71 AMXX Dev Team adminslots.amxx running
[ 5] Multi-Lingual Sys 1.71 AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.71 AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.71 AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.71 AMXX Dev Team plmenu.amxx running
[ 9] Teleport Menu 1.71 AMXX Dev Team telemenu.amxx running
[ 10] Maps Menu 1.71 AMXX Dev Team mapsmenu.amxx running
[ 11] Admin Chat 1.71 AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.71 AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.71 AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.71 AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.71 AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.71 AMXX Dev Team nextmap.amxx running
[ 17] Nextmap Chooser 1.71 AMXX Dev Team mapchooser.amxx running
[ 18] TimeLeft 1.71 AMXX Dev Team timeleft.amxx running
[ 19] Pause Plugins 1.71 AMXX Dev Team pausecfg.amxx running
[ 20] Stats Configurati 1.71 AMXX Dev Team statscfg.amxx running
[ 21] Restrict Weapons 1.71 AMXX Dev Team restmenu.amxx running
[ 22] StatsX 1.71 AMXX Dev Team statsx.amxx running
[ 23] CS Misc. Stats 1.71 AMXX Dev Team miscstats.amxx running
[ 24] CS Stats Logging 1.71 AMXX Dev Team stats_logging.a running
[ 25] Warcraft 3 Frozen 2.3.2 Geesu==(Pimp Dad warcraft3FT.amx debug
[ 26] AMX Bank 1.7 twistedeuphoria amx_bank.amxx running
[ 27] Amx Super 2.8 Bmann_420 amx_super.amxx running
[ 28] Join/Leave Messag 1.2 BigBaller join_leave.amxx running
[ 29] Bullet Whizz 1.4 Cheap_Suit Bullet_Whizz.am running
[ 30] Player Model 2.13b commonbullet playermodel.amx running
[ 31] CZ Bot control 1.3.4 EKS czbot_control.a running
31 plugins, 31 running
Code: Select all
Currently loaded modules:
name version author status
[ 1] Fun 1.71 AMX Mod X Dev Team running
[ 2] Engine 1.71 AMX Mod X Dev Team running
[ 3] FakeMeta 1.71 AMX Mod X Dev Team running
[ 4] MySQL 1.71 AMX Mod X Dev Team running
[ 5] CStrike 1.71 AMX Mod X Dev Team running
[ 6] CSX 1.71 AMX Mod X Dev Team running
Code: Select all
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.71 ini ANY ANY
[ 2] Fun RUN - fun_amxx_i386.so v1.71 pl1 ANY ANY
[ 3] Engine RUN - engine_amxx_i386 v1.71 pl1 ANY ANY
[ 4] FakeMeta RUN - fakemeta_amxx_i3 v1.71 pl1 ANY ANY
[ 5] MySQL RUN - mysql_amxx_i386. v1.71 pl1 ANY ANY
[ 6] CStrike RUN - cstrike_amxx_i38 v1.71 pl1 ANY ANY
[ 7] CSX RUN - csx_amxx_i386.so v1.71 pl1 ANY ANY
7 plugins, 7 running
--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list: