Help Clan Privs bug l2jacis

[TreVor]

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)

 

[Devlin]

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`=?";

[Zake]

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

[Rootware]

Which the aCis revision you uses?

[Zake]

2 hours ago, Rootware said:

Which the aCis revision you uses?

Most likely 382 with latest mariadb

[Nightw0lf]

just rename rank in code query and database column

[TreVor]

thanks for all fixed // solved

[Vision]

1 hour ago, TreVor said:

thanks for all fixed // solved

ok locked.