BUG CONSOLE
srfabric opened this issue · 4 comments
I don´t know why this appears.
[14:11:29 WARN]: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (table marry_players has no column named {FShareBackpack})
[14:11:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1030)
[14:11:29 WARN]: at org.sqlite.core.DB.newSQLException(DB.java:1042)
[14:11:29 WARN]: at org.sqlite.core.DB.throwex(DB.java:1007)
[14:11:29 WARN]: at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
[14:11:29 WARN]: at org.sqlite.core.NativeDB.prepare(NativeDB.java:137)
[14:11:29 WARN]: at org.sqlite.core.DB.prepare(DB.java:257)
[14:11:29 WARN]: at org.sqlite.core.CorePreparedStatement.(CorePreparedStatement.java:45)
[14:11:29 WARN]: at org.sqlite.jdbc3.JDBC3PreparedStatement.(JDBC3PreparedStatement.java:30)
[14:11:29 WARN]: at org.sqlite.jdbc4.JDBC4PreparedStatement.(JDBC4PreparedStatement.java:25)
[14:11:29 WARN]: at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
[14:11:29 WARN]: at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
[14:11:29 WARN]: at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
[14:11:29 WARN]: at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
[14:11:29 WARN]: at MarriageMaster.jar//at.pcgamingfreaks.MarriageMasterStandalone.libs.com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:322)
[14:11:29 WARN]: at MarriageMaster.jar//at.pcgamingfreaks.MarriageMasterStandalone.libs.com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
[14:11:29 WARN]: at MarriageMaster.jar//at.pcgamingfreaks.MarriageMasterStandalone.Database.Backend.SQL.add(SQL.java:512)
[14:11:29 WARN]: at MarriageMaster.jar//at.pcgamingfreaks.MarriageMasterStandalone.Database.Backend.SQL.doLoad(SQL.java:496)
[14:11:29 WARN]: at MarriageMaster.jar//at.pcgamingfreaks.MarriageMasterStandalone.Database.Backend.SQL.lambda$load$3(SQL.java:487)
[14:11:29 WARN]: at org.bukkit.craftbukkit.v1_18_R1.scheduler.CraftTask.run(CraftTask.java:101)
[14:11:29 WARN]: at org.bukkit.craftbukkit.v1_18_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
[14:11:29 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[14:11:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
[14:11:29 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[14:11:29 WARN]: at java.base/java.lang.Thread.run(Thread.java:833)
i should eliminate the database to it generate again? and if yes, there are any way to don´t lose the data?
Please update to this build.
Not sure why the column is still missing. Have you created the database with the broken version?
You should be able to fix with sqlitebrowser.
- Open the
database.db
file with it. - Click on the
marry_players
row and thenModify Table
- There should be 4 rows in the Fields list (
player_id
,name
,uuid
,sharebackpack
). If there is any other row there, click it and then clickRemove
. - Now you can create the
sharebackpack
field. Click onAdd
, it will add an new row, set it to the following values: Name=sharebackpack
, Type=INTEGER
, NN=selected, Default=0
When you are done, it should look like this:
- Click on
OK
- Exit and reload MarriageMaster.
Your data should be able to load again.