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)
a runtime error for mysql
Moderator: Forum Moderator
a runtime error for mysql
Last edited by olol on Sat Oct 08, 2005 11:05 am, edited 1 time in total.
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
olol:
We need the MySQL version to debug this.
Also did you recompile/change anything?
Regards,
We need the MySQL version to debug this.
Also did you recompile/change anything?
Regards,
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
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)
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)
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
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.
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
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!