Mysql syserr

[yarka0000]

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.

[yarka0000]

#push

[Syuki]

Reinstall your Mysqlserver. Or repair your Tables.

[yarka0000]

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.

[Mashkin]

The performance_schema in fact is not a real database but a MySQL feature.
The MySQL manual says that:

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 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.

[yarka0000]

Originally Posted by Mashkin

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.

[yarka0000]

#push