Mysql syserr

09/25/2012 11:56 yarka0000#1
SYSERR: Sep 25 11:27: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 ' ' at line 1 (query: errno: 1064)

hello epvpers,

i have this problem in syserr. since this problem started, some players' whose have already finished collect quests, collect quests restarted. how can i fix it? it is realy important for me.
10/14/2012 17:02 yarka0000#2
#push
10/14/2012 17:06 Syuki#3
Reinstall your Mysqlserver. Or repair your Tables.
01/04/2013 19:59 yarka0000#4
all tables are ok but not performance_schema. Do you know how to fix it? It doesn't work to fix this tables because some files are absent.
01/04/2013 20:24 Mashkin#5
The performance_schema in fact is not a real database but a MySQL feature.
The MySQL manual says that:
Quote:
Originally Posted by MySQL manual
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema is available as of MySQL 5.5.3 and has these characteristics:
  • The Performance Schema provides a way to inspect internal execution of the server at runtime. It is implemented using the [Only registered and activated users can see links. Click Here To Register...] storage engine and the performance_schema database. The Performance Schema focuses primarily on performance data. This differs from INFORMATION_SCHEMA, which serves for inspection of metadata.
  • ...
Because of that, its tables can not be handled (i.e. repaired) like normal tables. Just don't mind them, they are not broken.


Your error seams to be rather an issue of the game server. Since the error message doesn't give any clues about the syntax error in the query, it seams like something tried to submit an empty query.


You should probably inspect your quest files for any corrupt function calls and check the quotes (' and ") in the strings.
01/04/2013 22:39 yarka0000#6
Quote:
Originally Posted by Mashkin View Post
The performance_schema in fact is not a real database but a MySQL feature.
The MySQL manual says that:
[/LIST]Because of that, its tables can not be handled (i.e. repaired) like normal tables. Just don't mind them, they are not broken.


Your error seams to be rather an issue of the game server. Since the error message doesn't give any clues about the syntax error in the query, it seams like something tried to submit an empty query.


You should probably inspect your quest files for any corrupt function calls and check the quotes (' and ") in the strings.
i realized that it is related with alessa's core. when i change game core and auth core, this error disappears. If i use alessa's cores, there is mysql error. But stil i dont know how to fix it.
01/07/2013 22:20 yarka0000#7
#push