MySQL help needed please
Posted: Wed Mar 01, 2006 10:00 pm
Hello All,
Could somebody help me with a MySQL problem,
I am running a windows server with AMXX (V1.60) , Metamod 1.8 & Warcraft3 mod v 2.6.3 here is my modules list;
And here is my plugins list:
has anyone got any ideas why this is happening? or can somebody help me please.
Could somebody help me with a MySQL problem,
I am running a windows server with AMXX (V1.60) , Metamod 1.8 & Warcraft3 mod v 2.6.3 here is my modules list;
03:51:19 Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.60 ini ANY ANY
[ 2] Fun RUN - fun_amxx.dll v1.60 pl1 ANY ANY
[ 3] Engine RUN - engine_amxx.dll v1.60 pl1 ANY ANY
[ 4] FakeMeta RUN - fakemeta_amxx.dl v1.60 pl1 ANY ANY
[ 5] MySQL RUN - mysql_amxx.dll v1.60 pl1 ANY ANY
[ 6] GeoIP RUN - geoip_amxx.dll v1.60 pl1 ANY ANY
[ 7] nVault RUN - nvault_amxx.dll v1.60 pl1 ANY ANY
[ 8] CStrike RUN - cstrike_amxx.dll v1.60 pl1 ANY ANY
[ 9] CSX RUN - csx_amxx.dll v1.60 pl1 ANY ANY
9 plugins, 9 running
And here is my plugins list:
When i try and start the server it creates a table in my db called "war3users" but whenever anyone goes onto the server it doesnt save ANY xp to the database, when restarting the server i get this message:03:55:14 Currently loaded plugins:
name version author file status
[ 1] Admin Base 1.60 AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.60 AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.60 AMXX Dev Team adminhelp.amxx running
[ 4] Slots Reservation 1.60 AMXX Dev Team adminslots.amxx running
[ 5] Multi-Lingual Sys 1.60 AMXX Dev Team multilingual.am running
[ 6] Menus Front-End 1.60 AMXX Dev Team menufront.amxx running
[ 7] Commands Menu 1.60 AMXX Dev Team cmdmenu.amxx running
[ 8] Players Menu 1.60 AMXX Dev Team plmenu.amxx running
[ 9] Teleport Menu 1.60 AMXX Dev Team telemenu.amxx running
[ 10] Maps Menu 1.60 AMXX Dev Team mapsmenu.amxx running
[ 11] Admin Chat 1.60 AMXX Dev Team adminchat.amxx running
[ 12] Anti Flood 1.60 AMXX Dev Team antiflood.amxx running
[ 13] Scrolling Message 1.60 AMXX Dev Team scrollmsg.amxx running
[ 14] Info. Messages 1.60 AMXX Dev Team imessage.amxx running
[ 15] Admin Votes 1.60 AMXX Dev Team adminvote.amxx running
[ 16] NextMap 1.60 AMXX Dev Team nextmap.amxx running
[ 17] DeagsMapManage 2.30b Deags deagsmapmanage2 running
[ 18] TimeLeft 1.60 AMXX Dev Team timeleft.amxx running
[ 19] Pause Plugins 1.60 AMXX Dev Team pausecfg.amxx running
[ 20] Stats Configurati 1.60 AMXX Dev Team statscfg.amxx running
[ 21] Restrict Weapons 1.60 AMXX Dev Team restmenu.amxx running
[ 22] StatsX 1.60 AMXX Dev Team statsx.amxx running
[ 23] CS Misc. Stats 1.60 AMXX Dev Team miscstats.amxx running
[ 24] CS Stats Logging 1.60 AMXX Dev Team stats_logging.a running
[ 25] Warcraft 3 XP 2.6.3 ferret (Dopefish warcraft3.amxx running
[ 26] ATAC 2.5.5.0 T(+)rget/f117bom amxx_atac[1].2. running
[ 27] ATAC Config 1.1.06 f117bomb & T(+)r amxx_atac_cfg.a running
[ 28] Ultimate Gore 1.3.4 JTP10181/mike_ca amx_gore_ultima running
[ 29] AMXX Piss 2.0 KRoTaL amxx_piss.amxx running
[ 30] AMX Slay Losers 1.0 [email protected] slaylosers.amxx running
[ 31] CamperFarts 1.0 BeetleFart gas.amxx running
[ 32] AMX Spank2 0.9.4 [email protected] amx_spank2.amxx running
[ 33] High Ping Kicker 1.2.0 DynAstY hpk.amxx running
33 plugins, 33 running
the version of mysql is (according to the admin panel)03:57:07 [WC3] MYSQL Error Query: You have an error in your SQL syntax near 'START TRANSACTION' at line 1
03:57:07 L 03/02/2006 - 03:57:02: [MYSQL] Invalid database handle 0
03:57:07 L 03/02/2006 - 03:57:02: [AMXX] Run time error 10 (plugin "warcraft3.amxx") - debug not enabled!
03:57:07 L 03/02/2006 - 03:57:02: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
03:57:07 L 03/02/2006 - 03:57:02: [META] ini: Begin re-reading plugins list: c:/hlserver5/cstrike/addons/metamod/plugins.ini
03:57:07 L 03/02/2006 - 03:57:02: [META] ini: Read plugin config for: AMX Mod X
03:57:07 L 03/02/2006 - 03:57:02: [META] ini: Finished reading plugins list: c:/hlserver5/cstrike/addons/metamod/plugins.ini; Found 1 plugins
03:57:07 L 03/02/2006 - 03:57:02: [META] dll: Updating plugins...
03:57:07 L 03/02/2006 - 03:57:02: [META] dll: Finished updating 9 plugins; kept 1, loaded 0, unloaded 0, reloaded 0, delayed 0
03:57:07 L 03/02/2006 - 03:57:02: Server shutdown
03:57:07 L 03/02/2006 - 03:57:02: Log file closed
MySQL 3.23.58
has anyone got any ideas why this is happening? or can somebody help me please.