Problem with Sqlite - 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: Problem with Sqlite (/showthread.php?tid=637969)
+- 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: Problem with Sqlite (/showthread.php?tid=637969)
Problem with Sqlite - adri[4]Life - 24.07.2017
Hello everyone, I'am using sqlite since a month in my server, we never faced a problem, But today after few hours of uploading latest update to the server (In latest update i didn't touch the db code), Everyone has lost stats while the .db file still exist in the folder, i thought the file is broken so i decided to upload a backup same, it's not working
so i tested the latest db in my lan it worked, I have no idea about the bug position or anything my Sqlite knowledge is
too basic, and the guy who worked with me before has left I Guess the bug isn't from the host cause sqlite isn't related to it as i said the .db file is working on my lan mode.
Thanks in advance !
Re: Problem with Sqlite - Xeon™ - 24.07.2017
Quote:
|
Originally Posted by adrianlouise
 Hello everyone, I'am using sqlite since a month in my server, we never faced a problem, But today after few hours of uploading latest update to the server (In latest update i didn't touch the db code), Everyone has lost stats while the .db file still exist in the folder, i thought the file is broken so i decided to upload a backup same, it's not working
so i tested the latest db in my lan it worked, I have no idea about the bug position or anything my Sqlite knowledge is too basic, and the guy who worked with me before has left I Guess the bug isn't from the host cause sqlite isn't related to it as i said the .db file is working on my lan mode. Thanks in advance ! |
Re: Problem with Sqlite - adri[4]Life - 24.07.2017
Quote:
|
Originally Posted by XeonMaster
Try to change the .db file permissions to 776 or so 777 and try again.
|
Re: Problem with Sqlite - Xeon™ - 24.07.2017
Open FileZilla
Go to your server directory
prees on right button in mouse
choose file permissions
and put 777 instand of xxx or something like that
Re: Problem with Sqlite - adri[4]Life - 24.07.2017
Quote:
|
Originally Posted by XeonMaster
Open FileZilla
Go to your server directory prees on right button in mouse choose file permissions and put 777 instand of xxx or something like that |
Re: Problem with Sqlite - Pottus - 25.07.2017
It's so easy to figure this out just follow the chain of events that happens.
The obvious first test is to determine if your database even loads! If it doesn't then you know the issue is probably not in the script. Now if it does load then you need to follow the chain of events forward. Start by checking the results of load/save queries.
Honestly these kind of problems are pretty trivial when it comes to running a server if you can't figure it out or don't know what to do then you are going to have problem after problem like this.