Page 1 of 1

a runtime error for mysql

Posted: Sat Oct 08, 2005 1:37 am
by olol
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)

Posted: Sat Oct 08, 2005 2:41 am
by Lazarus Long
olol:

We need the MySQL version to debug this.

Also did you recompile/change anything?

Regards,

Posted: Sat Oct 08, 2005 3:28 am
by olol
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)

Posted: Sat Oct 08, 2005 4:12 am
by Lazarus Long
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.

Posted: Sat Oct 08, 2005 5:50 am
by olol
thanks very much

Posted: Sat Oct 08, 2005 8:39 am
by Geesu
Also nexxt time, make a descriptive title, no "plz read"