search

GeorgH93 / MarriageMaster

Marriage Plugin for Bukkit/Spigot
https://www.spigotmc.org/resources/marriage-master.19273/
GNU General Public License v3.0
113 stars 90 forks source link

BUG CONSOLE #242

Closed srfabric closed 2 years ago

srfabric commented 2 years ago

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)

GeorgH93 commented 2 years ago

Please update to this build.

srfabric commented 2 years ago

image

srfabric commented 2 years ago

i should eliminate the database to it generate again? and if yes, there are any way to don´t lose the data?

GeorgH93 commented 2 years ago

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.

  1. Open the database.db file with it.
  2. Click on the marry_players row and then Modify Table
  3. 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 click Remove.
  4. Now you can create the sharebackpack field. Click on Add, 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: image
  5. Click on OK
  6. Exit and reload MarriageMaster.

Your data should be able to load again.