DBMS issues with persistence. You have the wrong DBMS


#1

Game mode: Official release, leased server, MP (and various other modes).

By incorporating SQLite into your game DBMS, you’ve given birth to a subversive issue plaguing this game both on servers and clients.
SQLite was touted to be able to handle Terabytes of date storage and manipulation.
But what they didn’t tell you then when you decided to use this DBMS is that SQLite is plagued with persistence issues.

You don’t have to take my word for it.
Look at the forum complaints of items turning out missing or disappearing items dating back for months long before release through the present Official Release.
Everything from NPC spawns, Workstations, Structures, icons and the list goes on.

Folks, you have your hands full and your work cut out for you to straighten this debauchery out.
I wish you programmers luck in getting this one sorted out, because if you don’t it’s going to cost you more in the long run in having a professional firm do it for you.


#2