L2JMobius

High Five Problem in sql-need help.

maximov · 18 · 28450
Pages: 1 2

Offline maximov

  • Knight
  • ***
    • Posts: 66
on: July 31, 2019, 12:55:04 PM
Good day! After you create the clan starts rattling off error in the GS log.
Table clan_privs empty. How to fix?

org.l2jmobius.gameserver.model.clan.Clan restoreRankPrivs
SEVERE: Error restoring clan privs by rank: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
java.sql.SQLSyntaxErrorException: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
   at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
   at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   at org.l2jmobius.gameserver.model.clan.Clan.restoreRankPrivs(Clan.java:1981)
   at org.l2jmobius.gameserver.model.clan.Clan.restore(Clan.java:1127)
   at org.l2jmobius.gameserver.model.clan.Clan.<init>(Clan.java:172)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.<init>(ClanTable.java:100)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable$SingletonHolder.<clinit>(ClanTable.java:541)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.getInstance(ClanTable.java:536)
   at org.l2jmobius.gameserver.GameServer.<init>(GameServer.java:282)
   at org.l2jmobius.gameserver.GameServer.main(GameServer.java:488)
Caused by: java.sql.SQLException: 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
Query is: SELECT privs,rank,party FROM clan_privs WHERE clan_id=?, parameters [268495965]
java thread: main
   at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
   ... 12 more

Online Liamxroy

  • Grand Duke
  • *****
    • Posts: 760
    • Adenaplease!
Reply #1 on: July 31, 2019, 01:49:14 PM
Quote from: maximov on July 31, 2019, 12:55:04 PM
Good day! After you create the clan starts rattling off error in the GS log.
Table clan_privs empty. How to fix?

org.l2jmobius.gameserver.model.clan.Clan restoreRankPrivs
SEVERE: Error restoring clan privs by rank: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
java.sql.SQLSyntaxErrorException: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
   at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
   at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   at org.l2jmobius.gameserver.model.clan.Clan.restoreRankPrivs(Clan.java:1981)
   at org.l2jmobius.gameserver.model.clan.Clan.restore(Clan.java:1127)
   at org.l2jmobius.gameserver.model.clan.Clan.<init>(Clan.java:172)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.<init>(ClanTable.java:100)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable$SingletonHolder.<clinit>(ClanTable.java:541)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.getInstance(ClanTable.java:536)
   at org.l2jmobius.gameserver.GameServer.<init>(GameServer.java:282)
   at org.l2jmobius.gameserver.GameServer.main(GameServer.java:488)
Caused by: java.sql.SQLException: 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
Query is: SELECT privs,rank,party FROM clan_privs WHERE clan_id=?, parameters [268495965]
java thread: main
   at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
   ... 12 more

Did you change anything in clan table by hand ?

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #2 on: July 31, 2019, 02:17:27 PM
When did this happen?

Offline maximov

  • Knight
  • ***
    • Posts: 66
Reply #3 on: July 31, 2019, 06:30:32 PM
Through the admin panel I raised the level of the clan. I didn't change anything else.

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #4 on: July 31, 2019, 06:38:01 PM
What you expect to find there?

Offline maximov

  • Knight
  • ***
    • Posts: 66
Reply #5 on: July 31, 2019, 07:06:35 PM
The error points to this table. It's empty. I expect nothing. I just want to make it right.

Query is: SELECT privs,rank,party FROM clan_privs WHERE clan_id=?, parameters [268495965]

Selection from an empty table. If I understand correctly.


Offline maximov

  • Knight
  • ***
    • Posts: 66
Reply #6 on: July 31, 2019, 07:56:34 PM
The error is related to granting privileges. You give privileges. and they are not recorded in the database.

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #7 on: July 31, 2019, 08:03:33 PM

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #8 on: July 31, 2019, 08:06:33 PM
Patch updated.

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #9 on: July 31, 2019, 08:12:08 PM

Offline maximov

  • Knight
  • ***
    • Posts: 66
Reply #10 on: July 31, 2019, 08:17:41 PM
Could not store clan privs for rank: (conn=2486) Parameter at position 5 is not set
java.sql.SQLException: (conn=2486) Parameter at position 5 is not set

Online Mobius

  • Distinguished King
  • *****
    • Posts: 16059
Reply #11 on: July 31, 2019, 08:18:24 PM
Try the updated patch.
Or the latest.

Offline ReynalDev

  • Knight
  • ***
    • Posts: 92
  • https://reynaldev.pythonanywhere.com/
    • ReynalDev
Reply #12 on: July 31, 2019, 11:36:14 PM
If you using MariaDB, rank could be interpreted like keyword, but this happen since MariaDB 10.2.
https://mariadb.com/kb/en/library/rank/

Online GMavenging

  • Viscount
  • *****
    • Posts: 300
Reply #13 on: August 01, 2019, 12:48:39 AM
Quote from: Liamxroy on July 31, 2019, 01:49:14 PM
Quote from: maximov on July 31, 2019, 12:55:04 PM
Good day! After you create the clan starts rattling off error in the GS log.
Table clan_privs empty. How to fix?

org.l2jmobius.gameserver.model.clan.Clan restoreRankPrivs
SEVERE: Error restoring clan privs by rank: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
java.sql.SQLSyntaxErrorException: (conn=1365) 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
   at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:174)
   at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   at org.l2jmobius.gameserver.model.clan.Clan.restoreRankPrivs(Clan.java:1981)
   at org.l2jmobius.gameserver.model.clan.Clan.restore(Clan.java:1127)
   at org.l2jmobius.gameserver.model.clan.Clan.<init>(Clan.java:172)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.<init>(ClanTable.java:100)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable$SingletonHolder.<clinit>(ClanTable.java:541)
   at org.l2jmobius.gameserver.data.sql.impl.ClanTable.getInstance(ClanTable.java:536)
   at org.l2jmobius.gameserver.GameServer.<init>(GameServer.java:282)
   at org.l2jmobius.gameserver.GameServer.main(GameServer.java:488)
Caused by: java.sql.SQLException: 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 ',party FROM clan_privs WHERE clan_id=268495965' at line 1
Query is: SELECT privs,rank,party FROM clan_privs WHERE clan_id=?, parameters [268495965]
java thread: main
   at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
   at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
   ... 12 more

Did you change anything in clan table by hand ?

that only happens with mysql 8, tested in maria DB 10 and without errors

Online GMavenging

  • Viscount
  • *****
    • Posts: 300
Reply #14 on: August 01, 2019, 12:49:41 AM
also the query does not produce any error in game

Pages: 1 2