a runtime error for mysql

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

Moderator: Forum Moderator

Locked
olol
Peon
Posts: 5
Joined: Mon Aug 08, 2005 11:32 am

a runtime error for mysql

Post by olol » Sat Oct 08, 2005 1:37 am

version:2.2.6


L 10/08/2005 - 14:23:50: [warcraft3FT.amxx] [WAR3FT] DBI XP_Retreive 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 's')' at line 1 (-1)
L 10/08/2005 - 14:23:50: [MYSQL] Invalid result handle -1
L 10/08/2005 - 14:23:50: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 10/08/2005 - 14:23:50: [AMXX] Run time error 10: native error (native "dbi_free_result")
L 10/08/2005 - 14:23:50: [AMXX] [0] XP.inl::XP_Retreive (line 381)
L 10/08/2005 - 14:23:50: [AMXX] [1] war3ft.inl::WAR3_chooserace (line 206)
L 10/08/2005 - 14:23:50: [AMXX] [2] other.inl::getuserinput (line 151)
Last edited by olol on Sat Oct 08, 2005 11:05 am, edited 1 time in total.

User avatar
Lazarus Long
Lead PITA SOB
Posts: 618
Joined: Tue Jul 05, 2005 9:24 pm

Post by Lazarus Long » Sat Oct 08, 2005 2:41 am

olol:

We need the MySQL version to debug this.

Also did you recompile/change anything?

Regards,
Lazarus

olol
Peon
Posts: 5
Joined: Mon Aug 08, 2005 11:32 am

Post by olol » Sat Oct 08, 2005 3:28 am

no,i did not change anything

mysql version is 4.1.14

i use player's name to save xp

when player's name is "codename 'eon' pentagram",the bug happened

can you fix it?


now,you can see this:


L 10/08/2005 - 17:29:26: [warcraft3FT.amxx] [WAR3FT] DBI XP_Retreive error: You
have an error in your SQL syntax; check the manual that corresponds to your MySQ
L server version for the right syntax to use near 'eon' pentagram')' at line 1 (
-1)
L 10/08/2005 - 17:29:26: [MYSQL] Invalid result handle -1
L 10/08/2005 - 17:29:26: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx
")
L 10/08/2005 - 17:29:26: [AMXX] Run time error 10: native error (native "dbi_fre
e_result")
L 10/08/2005 - 17:29:26: [AMXX] [0] XP.inl::XP_Retreive (line 381)
L 10/08/2005 - 17:29:26: [AMXX] [1] war3ft.inl::WAR3_chooserace (line 206)
L 10/08/2005 - 17:29:26: [AMXX] [2] other.inl::getuserinput (line 151)

User avatar
Lazarus Long
Lead PITA SOB
Posts: 618
Joined: Tue Jul 05, 2005 9:24 pm

Post by Lazarus Long » Sat Oct 08, 2005 4:12 am

Are the " literal, as part of the actual name? It most probable need to be added by hand if so due to the double pairs od " and '.

I'll test some combinations out to see what might be the problem.

I'll come back on this one in a day or two.
Lazarus

olol
Peon
Posts: 5
Joined: Mon Aug 08, 2005 11:32 am

Post by olol » Sat Oct 08, 2005 5:50 am

thanks very much

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

Post by Geesu » Sat Oct 08, 2005 8:39 am

Also nexxt time, make a descriptive title, no "plz read"
No Support via PM

Locked