Hello,

I ran a server with PS for some time and often as servers do, it stagnated for a while. I've been working on upgrading everything and PS is an absolute in my mind.

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

Is there any help for the laggard? :^)

Thanks for even just reading this. Great plugin!

Cheers,
CS

Thank you kindly, sir!

Did you get this working? Sorry for the late reply. Open up another ticket if you still want to fix this.

Same story.

I am resurrecting an old server I used to run and have updated Precious Stones to encounter the same errors. Is there a query I can run to fix the structure of the database? I assume it's just the 'flags' column that needs adding?

Cheers,
Jargon

ALTER TABLE pstone_fields ADD flags text;
ALTER TABLE pstone_cuboids ADD flags text;

ALTER TABLE pstone_fields ADD flags text;
ALTER TABLE pstone_cuboids ADD flags text;

ALTER TABLE pstone_fields ADD flags text;
ALTER TABLE pstone_cuboids ADD flags text;

ALTER TABLE pstone_fields ADD flags text;
ALTER TABLE pstone_cuboids ADD flags text;

Thanks for the fast reply!

I've run the queries against the PreciousStones.db and I'm no longer getting the [SEVERE] error, but I'm still getting an [INFO] no such column: 'flags', which is peculiar. Although, it does now appear to be working ingame...

also add it to the pstone_players table