Help Error while restoring clan aCis

[Williams]

This error occurs when restart server, is this error official from aCis?

 

[Nightw0lf]

you propably updated the pack and not the database but you can check on model.pledge.clan line 229 the syntax and then check your table to compare and fix

a more easy fix to reinstall table clan

[Tryskell]

Downgrade your mySQL, according to Reynaldo some version of mySQL introduced a keyword than it is currently used by this table (privs). With 5.7 (for example) that query is ok.

Edited August 31, 2019 by Tryskell

[Williams]

2 hours ago, Nightw0lf said:

você propàticamente atualizou o pacote e não o banco de dados, mas pode verificar a sintaxe model.pledge.clan linha 229 e, em seguida, verificar sua tabela para comparar e corrigir

uma correção mais fácil para reinstalar o clã da tabela

 

the mistake is acis itself, I tested it clean

[Williams]

17 minutes ago, Tryskell said:

Faça o downgrade do seu mySQL, de acordo com Reynaldo, alguma versão do mySQL introduziu uma palavra-chave do que é atualmente usada por esta tabela (privs). Com 5.7 (por exemplo), essa consulta está correta.

 

i use mysql 8.0.17 newer version

[Nightw0lf]

1 hour ago, Tryskell said:

Downgrade your mySQL, according to Reynaldo some version of mySQL introduced a keyword than it is currently used by this table (privs). With 5.7 (for example) that query is ok.

you can escape this keyword by using `keyword` or use another name ^^

 

if you want to fix it for now fast and easy just escape this keyword before "FROM" in query using `keyword` to solve your issue right now until tk fix it

 

more info:

know that java servers never used escapes in queries, many words from java servers exists as keywords in mysql (many times i've wondered how servers worked so far) nothing is escaped (since it will never be sql injected) just used other words than keywords and since a keyword found in newer mysql the best solution is to rename it and thats all.

Edited August 31, 2019 by Nightw0lf