SQL Error

[Grafhugo]

Servus!

Ich habe gestern von game auf Linux rootserver gewechselt. Alle datein runtergeladen und dann auf den Root wieder hochgeladen. Nun kriegen wir diese Errormeldung. Kann mir vielleicht jemand helfen?

[11:15:12] [Thread-36/WARN]: org.sqlite.SQLiteException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.DB.newSQLException(DB.java:941)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.DB.newSQLException(DB.java:953)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.DB.throwex(DB.java:918)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.DB.prepare(DB.java:257)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
[11:15:12] [Thread-36/WARN]:     at net.coreprotect.database.Database.prepareStatement(Database.java:593)
[11:15:12] [Thread-36/WARN]:     at net.coreprotect.database.Database.prepareStatement(Database.java:549)
[11:15:12] [Thread-36/WARN]:     at net.coreprotect.consumer.Process.processConsumer(Process.java:106)
[11:15:12] [Thread-36/WARN]:     at net.coreprotect.consumer.Consumer.run(Consumer.java:123)
[11:15:12] [Thread-36/WARN]:     at java.lang.Thread.run(Thread.java:748)
[11:15:12] [Thread-36/WARN]: org.sqlite.SQLiteException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)
[11:15:12] [Thread-36/WARN]:     at org.sqlite.core.DB.newSQLException(DB.java:941)

 

[Grafhugo]

Hey Lapis! Danke für die möglichkeit! Ich werde die option 3 bei einigen plugins in betracht ziehen die "nicht systemrelevant" sind. Aktuell ist aber auch das problem für die Inventare, somit wenn spieler nun rejoinen nachdem ich es umgestellt habe denk der server es seien komplett neue spieler.

Ich probiere grade mit Navicat die .db datein umzuschreiben und auf mysql hochzuladen da kommen aber immer wieder errors:

[DTF] Data Transfer started
[DTF] 0> Getting tables
[DTF] 1> shopchest_economy_logs: Getting table structure
[DTF] 2> shopchest_fields: Getting table structure
[DTF] 3> shopchest_player_logouts: Getting table structure
[DTF] 4> shopchest_shops: Getting table structure
[DTF] 2> shopchest_fields: Drop table
[DTF] 2> shopchest_fields: Fetching records
[DTF] 3> shopchest_player_logouts: Drop table
[DTF] 3> shopchest_player_logouts: Fetching records
[DTF] 4> shopchest_shops: Drop table
[DTF] 4> shopchest_shops: Fetching records
[DTF] 1> shopchest_economy_logs: Fetching records
[DTF] 1> shopchest_economy_logs: Drop table
[DTF] 2> shopchest_fields: Create table
[DTF] 3> shopchest_player_logouts: Create table
[DTF] 1> shopchest_economy_logs: Create table
[DTF] 4> shopchest_shops: Create table
[ERR] 2> CREATE TABLE `shopchest_fields`  (
  `field` longtext NOT NULL,
  `value` int NOT NULL,
  PRIMARY KEY (`field`)
)
[ERR] 2> 1170 - BLOB/TEXT column 'field' used in key specification without a key length
[DTF] 5> sqlite_sequence: Getting table structure
[ERR] 3> CREATE TABLE `shopchest_player_logouts`  (
  `player` longtext NOT NULL,
  `time` longtext NOT NULL,
  PRIMARY KEY (`player`)
)
[ERR] 3> 1170 - BLOB/TEXT column 'player' used in key specification without a key length
[ERR] 1> CREATE TABLE `shopchest_economy_logs`  (
  `id` int NULL AUTO_INCREMENT,
  `shop_id` int NOT NULL,
  `timestamp` longtext NOT NULL,
  `time` longtext NOT NULL,
  `player_name` longtext NOT NULL,
  `player_uuid` longtext NOT NULL,
  `product_name` longtext NOT NULL,
  `product` longtext NOT NULL,
  `amount` int NOT NULL,
  `vendor_name` longtext NOT NULL,
  `vendor_uuid` longtext NOT NULL,
  `admin` longtext NOT NULL,
  `world` longtext NOT NULL,
  `x` int NOT NULL,
  `y` int NOT NULL,
  `z` int NOT NULL,
  `price` double NOT NULL,
  `type` longtext NOT NULL,
  PRIMARY KEY (`id`)
)
[ERR] 1> 1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
[ERR] 4> CREATE TABLE `shopchest_shops`  (
  `id` int NULL AUTO_INCREMENT,
  `vendor` longtext NOT NULL,
  `product` longtext NOT NULL,
  `amount` int NOT NULL,
  `world` longtext NOT NULL,
  `x` int NOT NULL,
  `y` int NOT NULL,
  `z` int NOT NULL,
  `buyprice` double NOT NULL,
  `sellprice` double NOT NULL,
  `shoptype` longtext NOT NULL,
  PRIMARY KEY (`id`)
)
[ERR] 4> 1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
[DTF] Process terminated