DBI XP_Save error

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

DBI XP_Save error

Post by Shinzon » Sun Nov 06, 2005 6:49 pm

Hi,

sorry, yet another problem:

L 11/06/2005 - 17:07:50: [warcraft3ft.amxx] [WAR3] Connection to MySQL Database successful (2)
L 11/06/2005 - 17:10:26: [admin_sql_4.2.amxx] Login: "-=[MxT]=- Ulzi<4934><STEAM_0:1:2374796><>" became an admin (account "-=[MxT]=- Ulzi") (access "bcdefgjnu") (address "84.185.159.55")
L 11/06/2005 - 17:10:26: [adminreservation.amxx] [AdminReservation] [-KS-]*-*ACKA*-* was kicked to free a slot for -=[MxT]=- Ulzi!
L 11/06/2005 - 17:11:38: [warcraft3ft.amxx] [WAR3] DBI XP_Save error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'r', 5085, 4, 3, 0, 2, 1)' at line 1 (1)
L 11/06/2005 - 17:11:38: [MYSQL] Invalid result handle -1
L 11/06/2005 - 17:11:38: [AMXX] Run time error 10 (plugin "warcraft3ft.amxx") - debug not enabled!

running FT (2.2.7 plugin, 2.2.5 module) with Amxx 1.60, MetaMod v1.18p26.

Any hints?

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Sun Nov 06, 2005 9:46 pm

Enable debugging please
No Support via PM

Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

Post by Shinzon » Tue Nov 08, 2005 12:59 am

L 11/08/2005 - 00:16:05: [AMXX] Displaying debug trace (plugin "warcraft3ft.amxx")
L 11/08/2005 - 00:16:05: [AMXX] Run time error 4: index out of bounds (array "p_data[33][32]") (indexed "[13][10]")
L 11/08/2005 - 00:16:05: [AMXX] [0] motd.inl::MOTD_Playerskills (line 165)
L 11/08/2005 - 00:16:05: [AMXX] [1] clientCommands.inl::cmd_Say (line 82)

L 11/08/2005 - 01:18:45: [warcraft3ft.amxx] [WAR3] DBI XP_Save error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''\'y0g!'', 0, 10, 0, 0, 0, 0)' at line 1 (1)
L 11/08/2005 - 01:18:45: [MYSQL] Invalid result handle -1
L 11/08/2005 - 01:18:45: [AMXX] Displaying debug trace (plugin "warcraft3ft.amxx")
L 11/08/2005 - 01:18:45: [AMXX] Run time error 10: native error (native "dbi_free_result")
L 11/08/2005 - 01:18:45: [AMXX] [0] XP.inl::XP_Save (line 291)
L 11/08/2005 - 01:18:45: [AMXX] [1] XP.inl::XP_Save_All (line 534)
L 11/08/2005 - 01:18:45: [AMXX] [2] cstrike.inl::on_EndRound (line 87)

L 11/08/2005 - 02:43:15: [AMXX] Displaying debug trace (plugin "warcraft3ft.amxx")
L 11/08/2005 - 02:43:15: [AMXX] Run time error 4: index out of bounds (array "WC3NAME[25]") (indexed "[9]")
L 11/08/2005 - 02:43:15: [AMXX] [0] XP.inl::XP_Retreive (line 385)
L 11/08/2005 - 02:43:15: [AMXX] [1] war3ft.inl::WAR3_chooserace (line 206)
L 11/08/2005 - 02:43:15: [AMXX] [2] clientCommands.inl::change_race (line 18)
L 11/08/2005 - 02:43:15: [AMXX] [3] clientCommands.inl::cmd_Say (line 78)


And, btw, what about this error?
L 11/08/2005 - 01:18:03: [warcraft3ft.amxx] [WAR3] ERROR, Race: 10, skill: 1 not found in raceskill function

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Nov 08, 2005 7:41 am

LOL ok thats just funny, I'm going to link this to bail, perhaps I'm missing something....

But I don't see how [13][10] is out of bounds

What version of amxx are you running?

Paste the following commands:
amxx list
amxx modules
meta list

Also, the race 10 error, should NEVER occur, I'm not sure how you're getting it to pop up.... But, it could be that you have FT_races as 10 ?
No Support via PM

Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

Post by Shinzon » Tue Nov 08, 2005 12:11 pm

Ok, here it is:


19:04:18 Currently loaded plugins:
name version author file status
[ 1] Admin Base (AmxBa 1.60 AMXX Dev Team admin_sql_4.2.a running
[ 2] AMXBans 4.2 YoMama amxbans_4.2.amx running
[ 3] Admin Commands 1.60 AMXX Dev Team admincmd.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] RuneMod Base 2.1.2 EKS runemod_base.am paused
[ 7] Menus Front-End 1.60 AMXX Dev Team menufront.amxx running
[ 8] Commands Menu 1.60 AMXX Dev Team cmdmenu.amxx running
[ 9] Players Menu 1.60 AMXX Dev Team plmenu.amxx running
[ 10] Maps Menu 1.60 AMXX Dev Team mapsmenu.amxx running
[ 11] Anti STEAM_ID_PEN 1.0.0 EKS anti_steamidpen running
[ 12] Admin Chat 1.60 AMXX Dev Team adminchat.amxx running
[ 13] Anti Flood 1.60 AMXX Dev Team antiflood.amxx running
[ 14] Scrolling Message 1.60 AMXX Dev Team scrollmsg.amxx running
[ 15] Info. Messages 1.60 AMXX Dev Team imessage.amxx running
[ 16] Admin Votes 1.60 AMXX Dev Team adminvote.amxx running
[ 17] NextMap 1.60 AMXX Dev Team nextmap.amxx 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] AMX Admin Model 1.1.2 Shinzon amx_adminmodel. running
[ 25] AMX Admin Model 1.1.3 Shinzon amx_adminmodel_ running
[ 26] AMX Admin Model 1.1.2 Shinzon amx_adminmodel_ running
[ 27] AMX Admin Model G 1.1.3 Shinzon amx_adminmodel_ running
[ 28] ATAC 2.5.4.1 T(+)rget/f117bom amx_atac.amxx running
[ 29] ATAC Config 1.1.06 f117bomb & T(+)r amx_atac_cfg.am running
[ 30] AdminListen 2.3x /dev/ urandom adminlisten.amx running
[ 31] AdminReservation 1.0 [RST] FireStorm adminreservatio running
[ 32] Team Balancer 1.7b8 Ptahhotep team_balancer.a running
[ 33] Drop Awp 0.1 SuicideDog drop_awp.amxx running
[ 34] Drop g3sg1 0.1 Shinzon drop_g3sg1.amxx running
[ 35] Drop sg550 0.1 Shinzon drop_sg550.amxx running
[ 36] Ghost Mode 1.4 Kiosk3 amx_ghost.amxx running
[ 37] Admin Disarm 1.1 mike_cao amx_disarm.amxx running
[ 38] High Ping Kicker 1.2.0 DynAstY hpk.amxx running
[ 39] Clan Tag Protecti 0.8.5 default clan_tag_protec running
[ 40] Shinzon_Special 1.0 Shinzon amx_sprache.amx running
[ 41] Shinzon_Special2 1.0 Shinzon amx_sprache2.am running
[ 42] Exec 1.0 ToXiC amx_execclient. running
[ 43] Change Score 2.0.5 Freecode changescore.amx running
[ 44] Bazooka 0.9 More bazooka.amxx running
[ 45] Buyzone S 1.1 Shinzon buyzone_shinzon running
[ 46] Drop Pistols 1.0 Shinzon drop_pistols.am running
[ 47] Weapon Multiplier 0.50 BlueRaja damagemult.amxx running
[ 48] CovertOps 1.0F Xmdxtremekiller covertops.amxx running
[ 49] Remove weapons 0.2 JGHG removeweapons.a running
[ 50] unknown unknown unknown zoomgun.amxx running
[ 51] Tracer 0.1 DahVid cs_tracer.amxx running
[ 52] Strip weapons 0.1 DahVid noweapon.amxx running
[ 53] Runemod Ninja 1.0.0 Cheesy Peteza & runemod_ninja.a paused
[ 54] RuneMod Dismay 1.0.0 EKS runemod_dismay. paused
[ 55] RuneMod Fear 1.0.2 EKS runemod_fear.am paused
[ 56] RuneMod Frenzy 1.0.0 EKS runemod_frenzy. paused
[ 57] RuneMod Protectio 1.0.0 EKS runemod_protect paused
[ 58] RuneMod Hunter 1.0.1 EKS runemod_hunter. paused
[ 59] RuneMod Invisibil 1.1.0 EKS runemod_invisib paused
[ 60] RuneMod Phantom 1.0.1 EKS runemod_phantom paused
[ 61] RuneMod Pistoleer 1.0.1 EKS runemod_pistole paused
[ 62] RuneMod Regenerat 1.0.0 EKS runemod_regener paused
[ 63] RuneMod Resistanc 1.0.0 EKS runemod_resista paused
[ 64] RuneMod Seer 1.1.0 kaddar runemod_seer.am paused
[ 65] RuneMod Frenzy 1.0.0 EKS runemod_soul.am paused
[ 66] RuneMod Speed 1.0.0 EKS runemod_speed.a paused
[ 67] RuneMod Strength 1.0.0 EKS runemod_strengt paused
[ 68] RuneMod Unlimited 1.0.0 EKS runemod_unlimit paused
[ 69] RuneMod Vampirism 1.0.0 EKS runemod_vampiri paused
[ 70] RuneMod Kinetics 1.0.0 EKS runemod_kinetic paused
[ 71] RuneMod Feather 1.0.0 EKS runemod_feather paused
[ 72] RuneMod Teleport 1.0.0 EKS runemod_telepor paused
[ 73] RuneMod Kamikaze 1.0.0 EKS runemod_kamikaz paused
[ 74] Shinzon_Mad1 1.0 Shinzon amx_madagascar1 running
[ 75] Shinzon_Mad2 1.0 Shinzon amx_madagascar2 running
[ 76] Shinzon_Mad3 1.0 Shinzon amx_madagascar3 running
[ 77] Tornado_fmj1 1.0 Tornado amx_fmj1.amxx running
[ 78] Tornado_fmj2 1.0 Tornado amx_fmj2.amxx running
[ 79] Tornado_fmj3 1.0 Tornado amx_fmj3.amxx running
[ 80] Tornado_fmj4 1.0 Tornado amx_fmj4.amxx running
[ 81] Bad Camper 1.0 Brad Jones bad_camper.amxx running
[ 82] Play or Be Kicked 1.1 Brad Jones pbk.amxx running
[ 83] Warcraft 3 Frozen 2.2.7 Geesu (Pimp Dadd warcraft3ft.amx debug


19:06:10 Currently loaded modules:
name version author status
[ 1] Fun 1.60 AMX Mod X Dev Team running
[ 2] Engine 1.60 AMX Mod X Dev Team running
[ 3] FakeMeta 1.60 AMX Mod X Dev Team running
[ 4] MySQL 1.60 AMX Mod X Dev Team running
[ 5] GeoIP 1.60 AMX Mod X Dev Team running
[ 6] nVault 1.60 AMX Mod X Dev Team running
[ 7] CStrike 1.60 AMX Mod X Dev Team running
[ 8] CSX 1.60 AMX Mod X Dev Team running
[ 9] War3ft 2.2.5 Geesu (Pimp Daddy) running
9 modules, 9 correct

19:06:41 Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] HLGuard RUN - hlguard_mm_optim v1.8 ini Chlvl Chlvl
[ 2] AMX Mod X RUN - amxmodx_mm_i386. v1.60 ini ANY ANY
[ 3] phpua_mm RUN - phpua_mm_i386.so v1.1.1b ini Start Pause
[ 4] Fun RUN - fun_amxx_i386.so v1.60 pl2 ANY ANY
[ 5] Engine RUN - engine_amxx_i386 v1.60 pl2 ANY ANY
[ 6] FakeMeta RUN - fakemeta_amxx_i3 v1.60 pl2 ANY ANY
[ 7] MySQL RUN - mysql_amxx_i386. v1.60 pl2 ANY ANY
[ 8] GeoIP RUN - geoip_amxx_i386. v1.60 pl2 ANY ANY
[ 9] nVault RUN - nvault_amxx_i386 v1.60 pl2 ANY ANY
[10] CStrike RUN - cstrike_amxx_i38 v1.60 pl2 ANY ANY
[11] CSX RUN - csx_amxx_i386.so v1.60 pl2 ANY ANY
[12] War3ft RUN - war3ft_amxx_i386 v2.2.5 pl2 ANY ANY
12 plugins, 12 running



And FT_races are only 4.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Nov 08, 2005 3:36 pm

all i have to say is...

HOLY FUCKING SHIT!

Running enough plugins? LOL, try disabling everything but war3ft and tell me if you have the same problem. Also upgrade to at least war3ft 2.2.6 (2.2.7 is the latest)
No Support via PM

Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

Post by Shinzon » Tue Nov 08, 2005 6:52 pm

Geesu wrote:Running enough plugins?
No, not really... :wink:
Geesu wrote:Also upgrade to at least war3ft 2.2.6 (2.2.7 is the latest)
The sma is 2.2.7, linux .so is from your archive and this is 2.2.5

And don't care about the other plugins, most of them are disabled per cvar
and they not really can cause any errors cause of simple code (for playin sounds, drop players weapons etc.)

Only thing which deals with sql is amxbans.

Maybe it's ATAC, this is a bit misfunctional since FT installed (sometimes u can't punish team attackers)

Just looked at the logfile, since i have FT_races 8, all errors gone.
FT_races 4 does the errors i think.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Nov 08, 2005 9:01 pm

Interesting..... also, it doesn't matter if the sma is 2.2.7, the plugin that is running (.amxx) is 2.2.5 :P
No Support via PM

Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

Post by Shinzon » Wed Nov 09, 2005 8:57 am

Not sure, what you mean, but:

Code: Select all

5:11 War3ft 2.2.5 Aug  7 2005 Geesu (Pimp Daddy)
This is taken directly from the war3ft_amxx_i386.so located in
war3ft_v2.2.7.zip which is from your website.

The compiled .sma has 2.2.7

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Nov 09, 2005 1:33 pm

Ahhhh nvmd ignore me :P
No Support via PM

Shinzon
Peon
Posts: 28
Joined: Thu Nov 03, 2005 11:01 am

Post by Shinzon » Wed Nov 09, 2005 10:12 pm

Ok, you will be ignored....

:lol: :lol: :lol: :lol:

zetrix91
Peon
Posts: 3
Joined: Fri Nov 11, 2005 2:03 am

NEED HELP

Post by zetrix91 » Fri Nov 11, 2005 6:33 am

i have put in WC3 mod the right way.. but when we are playing 1 against 1 but when we plant bomb and stuff we dont get xp it says 0 XP! :? :(

zetrix91
Peon
Posts: 3
Joined: Fri Nov 11, 2005 2:03 am

Post by zetrix91 » Fri Nov 11, 2005 6:39 am

i have put in WC3 mod the right way.. but when we are playing 1 against 1 and planting the bomb we dont get Xp it says 0 XP.. maybe i have to activate something.. please help me soon!! having lan! soon !! NEED HELP!!!! :| :|

madooeiei
Peon
Posts: 1
Joined: Fri Oct 02, 2015 8:26 pm

Re: DBI XP_Save error

Post by madooeiei » Wed Dec 16, 2015 8:26 pm

Running enough plugins?

Post Reply