Upgrade from 5.5.5 -> was: Long Shot Question...
cubesteak opened this issue ยท 1 comments
Hello!
I received your reply at the following issue:
Thanks so much for getting back to me! If it isn't too much trouble, I would very much appreciate it if you were able to fix this!
I'm including issue itself again here for your convenience:
------->
My problem: Version 5.5.5 was my last PS version - any chance at all that the PreciousStones.db can be upgraded to the latest?
I'm getting the issue:
15:56:08 [INFO] [PreciousStones] SQLite Connection successful
15:56:08 [INFO] no such column: 'flags'
15:56:08 [INFO] no such column: 'flags'
15:56:08 [INFO] no such column: 'flags'
15:56:08 [SEVERE] Error at SQL Query: [SQLITE_ERROR] SQL error or missing database (no such column: flags)
15:56:08 [SEVERE] Query: SELECT pstone_fields.id as id, x, y, z, radius, height, type_id, velocity, world, owner, name, packed_allowed, last_used, flags FROM pstone_fields WHERE world = 'our_world';
followed by a bunch of other errors with the same basic issue: no such column flags:
<-----------
Thanks again for your help, it is greatly appreciated!
Kindest regards,
CS
How many fields are in the server? Possible to just save the locations using /ps locations for the players who them, than just start a new DB and tp to each spot break the stone and reasign it the player who owned it?
It is possible to get a text print out, if you copy the SQL data into excel in some fasion.