L2JMobius

Public Development => Bug Reports => Topic started by: GuruGel on September 29, 2024, 02:02:32 PM

Title: console error
Post by: GuruGel on September 29, 2024, 02:02:32 PM

Please tell me what the problem could be?
These errors keep appearing in the console.

Code: [Select]

[29/09 08:33:32] Could not store character shortcut: (conn=65218) Out of range value for column 'level' at row 1
java.sql.SQLSyntaxErrorException: (conn=65218) Out of range value for column 'level' at row 1
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
at org.l2jmobius.gameserver.model.ShortCuts.registerShortCutInDb(ShortCuts.java:99)
at org.l2jmobius.gameserver.model.ShortCuts.registerShortCut(ShortCuts.java:78)
at org.l2jmobius.gameserver.model.actor.Player.registerShortCut(Player.java:1733)
at org.l2jmobius.gameserver.network.clientpackets.RequestShortCutReg.runImpl(RequestShortCutReg.java:158)
at org.l2jmobius.gameserver.network.clientpackets.ClientPacket.run(ClientPacket.java:53)
at org.l2jmobius.commons.threads.RunnableWrapper.run(RunnableWrapper.java:35)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Out of range value for column 'level' at row 1
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
... 10 more
Caused by: java.sql.SQLException: Out of range value for column 'level' at row 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
... 11 more

and

Code: [Select]

Sep 15, 2024 6:44:01 AM org.l2jmobius.gameserver.model.actor.Player storeCharBase
WARNING: Could not store char base data: Player:TestServer[268521077] - (conn=115341) Out of range value for column 'fame' at row 1
java.sql.SQLSyntaxErrorException: (conn=115341) Out of range value for column 'fame' at row 1
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
at org.l2jmobius.gameserver.model.actor.Player.storeCharBase(Player.java:7617)
at org.l2jmobius.gameserver.model.actor.Player.store(Player.java:7496)
at org.l2jmobius.gameserver.model.actor.Player.storeMe(Player.java:7536)
at org.l2jmobius.gameserver.model.actor.Player.autoSave(Player.java:8628)
at org.l2jmobius.gameserver.taskmanager.PlayerAutoSaveTaskManager.run(PlayerAutoSaveTaskManager.java:68)
at org.l2jmobius.commons.threads.RunnableWrapper.run(RunnableWrapper.java:35)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:358)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Out of range value for column 'fame' at row 1
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
... 13 more
Caused by: java.sql.SQLException: Out of range value for column 'fame' at row 1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
... 14 more


Title: Re: console error
Post by: shifu on September 29, 2024, 06:27:17 PM

Check the database write permissions of the user that is using the server.

Quote

Out of range value for column 'fame'

You may be using a database that is not compatible with the server.

Title: Re: console error
Post by: GuruGel on October 01, 2024, 12:03:23 PM

what do you mean incompatible database? I use the database that comes with the server...

Title: Re: console error
Post by: shifu on October 01, 2024, 06:44:07 PM

Quote from: GuruGel on October 01, 2024, 12:03:23 PM

what do you mean incompatible database? I use the database that comes with the server...

This is an assumption when the server tries to write data out of range.. Have you checked the write permissions?

Title: Re: console error
Post by: GuruGel on October 03, 2024, 11:06:09 AM

permissions are all present, the only thing is that for personal reputation points I wrote a value higher than the default. But that's okay, I returned it to the previous value, it seems the error went away, but it's not clear with writing objects. Why does it complain about objects? Everything is standard there.

Title: Re: console error
Post by: shifu on October 03, 2024, 11:42:54 AM

What actions cause errors?

Title: Re: console error
Post by: GuruGel on October 03, 2024, 01:23:11 PM

I still don't understand what causes the error, but from my observations it appears when you add an item for auto use. This error does not appear all the time.

Title: Re: console error
Post by: shifu on October 03, 2024, 02:53:47 PM

What Mysql server are you using?

Title: Re: console error
Post by: GuruGel on October 03, 2024, 03:39:35 PM

phpMyAdmin Database Manager Version 4.9.0.1
MySQL Database Version 8.0.17

Title: Re: console error
Post by: shifu on October 04, 2024, 04:08:48 AM

Quote from: GuruGel on October 03, 2024, 03:39:35 PM

MySQL Database Version 8.0.17

Try MySQL 5.5 or 5.7