SQLite data leak - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite data leak (
/showthread.php?tid=664629)
SQLite data leak -
KaliDobrev - 05.03.2019
Hello, can someone tell me why my server with SQLite saved system sometimes loses user data when disconnecting or restarting the server?
How could I solve it? and what is causing it?
I stress: This never happened to me, I had the server online before and never lost any data, it may be the attacks I'm receiving? (The attacks are DDoS with botnet)
Re: SQLite data leak -
Pottus - 06.03.2019
Do you make queries to your db when a user disconnects?
Re: SQLite data leak -
KaliDobrev - 06.03.2019
Quote:
Originally Posted by Pottus
Do you make queries to your db when a user disconnects?
|
Yes.
Re: SQLite data leak -
Pottus - 06.03.2019
You just found your problem then. Saving anything other than immediately means running the risk of data loss.
Re: SQLite data leak -
KaliDobrev - 06.03.2019
Quote:
Originally Posted by Pottus
You just found your problem then. Saving anything other than immediately means running the risk of data loss.
|
So, I should not save the data when the user disconnects, if not in another way?
Re: SQLite data leak -
Banditul18 - 06.03.2019
Update data when changes. User recived/lost money? Let the database know about it
Re: SQLite data leak -
KaliDobrev - 06.03.2019
Thank you
+1