Mysql Version

04/11/2013 20:03 RedKing2#1
Hallo epvp, ich hδtte da eine Frage, welche Version von Mysql wδre die richtige fόr Mt2? Ich erhalte alle 60.Sekunden (genau 60sec) ein Error (Erno 1062) das eine Query Syntax fail ist, weil ich nicht '' sondern "" benutze fόr Querys. Mittlerweile ist mir aufgefallen das es der Server an sich ist, der "" in seinen Querys einsetzt um was in die DB einzutragen, nicht nur meine Quests, zudem funktionieren viele Quest-Befehle nicht mit ' ' sondern mit " " , aber auch die kommen dann mit "Syntax Error", der Server ansich arbeitet normal, aber es stφrt mich tierisch.

Ich brδuchte jemand von den Schlauen der mir hier ne Antwort geben kann.

Bsp:

DB-Core Sysser bei Aktionen:
HTML Code:
SYSERR: Apr 11 19:51:38 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query 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 Pferd')' at line 1
query: REPLACE INTO horse_name VALUES(50006, 'ImbaJugga's Pferd')
Game-Sysser (interval alle 60sec)

HTML Code:
SYSERR: Apr 11 19:57:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
SYSERR: Apr 11 19:58:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
SYSERR: Apr 11 19:59:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
SYSERR: Apr 11 20:00:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
SYSERR: Apr 11 20:01:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
SYSERR: Apr 11 20:02:00 :: ChildLoop: AsyncSQL: query failed: 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 '' at line 1 (query:  errno: 1064)
mfg
11/07/2013 22:06 [SA]ProtoTyp#2
Ich auch
11/07/2013 22:12 ihrnervt#3
Was der Fehler ist steht doch da und ist auch ganz logisch:

Code:
'ImbaJugga's Pferd'
Die ' werden als Einleitung und Ende eines Datensatzes gebraucht. Das heiίt, es darf nur eins am Anfang und eins am Ende vorkommen.
Nimm das ' vor dem s raus und dann sollte alles gehen.
11/07/2013 22:18 .Shōgun#4
What is in your my.cnf?

Actually you don't need to remove it - just escape it with a backslash:

\'
11/08/2013 15:55 [SA]ProtoTyp#5
Ich meine denn fehler darunter