Page 1 of 1

mySQL error message

Posted: Tue Jul 12, 2005 3:38 pm
by Striker
Hello,

I'm using this software (server):
-- phpMyAdmin SQL
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Server Version: 4.0.21
-- PHP-Version: 4.3.8
-- OS: Linux/SUSE Apache
here is the error message:

Code: Select all

L 07/12/2005 - 15:31:38: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 GALEN 'A'LG',xp='479',race='4',skill1='0',skill2='1', (1)
L 07/12/2005 - 15:35:56: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 GALEN 'A'LG',xp='508',race='4',skill1='0',skill2='1', (1)
L 07/12/2005 - 15:36:10: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 weem^',xp='317',race='4',skill1='1',skill2='0',skill3 (1)
L 07/12/2005 - 15:36:28: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 weem^',xp='354',race='4',skill1='1',skill2='0',skill3 (1)
L 07/12/2005 - 15:36:29: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 GALEN 'A'LG',xp='539',race='4',skill1='0',skill2='1', (1)
L 07/12/2005 - 15:36:29: [warcraft3FT.amxx] [WAR3FT] 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 'ncolin <3 weem^',xp='354',race='4',skill1='1',skill2='0',skill3 (1)
how can I fix this ?

Posted: Tue Jul 12, 2005 6:51 pm
by Geesu
You can't, the user needs to not have a ' in their name....

I need to fix my code :/