L2JMobius

Age of Magic console error

GuruGel · 10 · 3747
Pages: 1

Online GuruGel

  • Knight
  • ***
    • Posts: 91
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

Offline shifu

  • Knight
  • ***
    • Posts: 81
  • Patria o Muerte
Reply #1 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.

Online GuruGel

  • Knight
  • ***
    • Posts: 91
Reply #2 on: October 01, 2024, 12:03:23 PM
what do you mean incompatible database? I use the database that comes with the server...

Offline shifu

  • Knight
  • ***
    • Posts: 81
  • Patria o Muerte
Reply #3 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?

Online GuruGel

  • Knight
  • ***
    • Posts: 91
Reply #4 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.

Offline shifu

  • Knight
  • ***
    • Posts: 81
  • Patria o Muerte
Reply #5 on: October 03, 2024, 11:42:54 AM
What actions cause errors?

Online GuruGel

  • Knight
  • ***
    • Posts: 91
Reply #6 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.

Offline shifu

  • Knight
  • ***
    • Posts: 81
  • Patria o Muerte
Reply #7 on: October 03, 2024, 02:53:47 PM
What Mysql server are you using?

Online GuruGel

  • Knight
  • ***
    • Posts: 91
Reply #8 on: October 03, 2024, 03:39:35 PM
phpMyAdmin Database Manager Version 4.9.0.1
MySQL Database Version 8.0.17

Offline shifu

  • Knight
  • ***
    • Posts: 81
  • Patria o Muerte
Reply #9 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

Pages: 1