Database Problem

[TAUMP 1177]

Hi, i need help

I tried to replace the table but without effect. May be a bug in the core(db)? Thanks.

SYSERR: Jun 19 19:04:12 :: 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 '"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 96' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 960311, 269437, 5, 'GM_LOGIN', '', '217.170.103.253') errno: 1064)
SYSERR: Jun 19 19:04:12 :: 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 '"" WHERE account_id = 1' at line 1 (query: SELECT size FROM safebox"" WHERE account_id = 1 errno: 1064)
SYSERR: Jun 19 19:04:12 :: 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 '"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 96' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 960311, 269437, 0, 'LOGIN', '217.170.103.253 0 1 41 25', '217.170.103.253') errno: 1064)
SYSERR: Jun 19 19:04:12 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000004, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:04:12 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 0, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:04:36 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2992, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:04:40 :: 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 '"" WHERE account='Therias'' at line 1 (query: SELECT account, companion FROM messenger_list"" WHERE account='Therias' errno: 1064)
SYSERR: Jun 19 19:04:43 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2987, 0, 10000004, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:04:50 :: 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 '"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.' at line 1 (query: INSERT DELAYED INTO command_log"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.103.253', 1, 'Therias', 'x 2', NOW())  errno: 1064)
SYSERR: Jun 19 19:04:53 :: 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 '"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.' at line 1 (query: INSERT DELAYED INTO command_log"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.103.253', 1, 'Therias', 'x 1', NOW())  errno: 1064)
SYSERR: Jun 19 19:05:02 :: 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 '"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.' at line 1 (query: INSERT DELAYED INTO command_log"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.103.253', 1, 'Therias', 'x 1', NOW())  errno: 1064)
SYSERR: Jun 19 19:05:05 :: 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 '"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.' at line 1 (query: INSERT DELAYED INTO command_log"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.103.253', 1, 'Therias', 'x 2', NOW())  errno: 1064)
SYSERR: Jun 19 19:05:36 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2991, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:05:43 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 2986, 0, 10000004, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:05:56 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1, 0, 10000037, 'SET_SOCKET', '', '', 19) errno: 1064)
SYSERR: Jun 19 19:05:56 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 9' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 957723, 268147, 10000037, 'GM', 'Meč+9', '217.170.103.253', 19) errno: 1064)
SYSERR: Jun 19 19:05:56 :: 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 '"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.' at line 1 (query: INSERT DELAYED INTO command_log"" (userid, server, ip, port, username, command, date ) VALUES(1, 999, '217.170.103.253', 1, 'Therias', 'i 19', NOW())  errno: 1064)
SYSERR: Jun 19 19:06:31 :: 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 '"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 95' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 1, 957679, 268064, 0, 'LOGOUT', '217.170.103.253 0 1 41 25', '217.170.103.253') errno: 1064)
SYSERR: Jun 19 19:06:31 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 1' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 12, 0, 10000004, 'SET_SOCKET', '', '', 72702) errno: 1064)
SYSERR: Jun 19 19:06:31 :: 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 '"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 5' at line 1 (query: INSERT DELAYED INTO log"" (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 1, 5, 0, 10000028, 'SET_SOCKET', '', '', 72702) errno: 1064)

 

[Cataclismo 88]

It's not a database problem. Your syntax is wrong. Post here that syntax (exactly how it is on the source) and we may fix it for you.

[TAUMP 1177]

I do not know what exactly you want from me :(: D

[pbuzz 31]

those queries are from log file. post "log.cpp" file from server

[TAUMP 1177]

Solved i edit conf.txt TABLE_POSTFIX = ""