Jump to content
  • 0

Error while restoring clan aCis


Williams

Question

5 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

  • 0

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 by Tryskell
Link to comment
Share on other sites

  • 0
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

Link to comment
Share on other sites

  • 0
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

Link to comment
Share on other sites

  • 0
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 by Nightw0lf
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now


×
×
  • Create New...