Welcome to MaxCheaters.com

Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads

  • 0

Help Clan Privs bug l2jacis


Go to solution Solved by Devlin,

Question

Hello, I have one problem using the files, does anyone know how to solve it?

Apr 21, 2021 10:22:58 PM net.sf.l2j.gameserver.model.pledge.Clan setPriviledgesForRank
SEVERE: Error while storing rank.
java.sql.SQLSyntaxErrorException: 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 'rank,privs) VALUES (268439441,6,8388606) ON DUPLICATE KEY UPDATE privs=VALUES(pr' at line 1
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1057)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1377)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1042)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1085)
    at net.sf.l2j.gameserver.model.pledge.Clan.setPriviledgesForRank(Clan.java:1386)
    at net.sf.l2j.gameserver.network.clientpackets.RequestPledgePower.runImpl(RequestPledgePower.java:43)
    at net.sf.l2j.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:52)
    at net.sf.l2j.gameserver.network.GameClient.run(GameClient.java:139)
    at net.sf.l2j.commons.concurrent.ThreadPool$TaskWrapper.run(ThreadPool.java:221)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)

 

Share this post


Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0
  • Solution

At Clan.java

 

find LOAD_PRIVILEDGES and update it with the following line ->

 

private static final String LOAD_PRIVILEDGES = "SELECT `privs`,`rank` FROM `clan_privs` WHERE `clan_id`=?";

Share this post


Link to post
Share on other sites
  • 0

In newer mysql versions 'rank' is meant to be a keyword, not sure about 'privs'. Although you should rename both of them, just in case

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.