PreciousStones

PreciousStones

269k Downloads

Upgrade from 5.5.5 -> was: Long Shot Question...

cubesteak opened this issue ยท 1 comments

commented

Hello!

I received your reply at the following issue:

#242

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

commented

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.