SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Help Archive

 
 
Thread Tools Display Modes
Old 08/03/2009, 09:31 AM   #1
MX_Master
Huge Clucker
 
Join Date: Jul 2007
Posts: 395
Reputation: 0
Default SQLite DB problems

I uploaded some sqlite DBs (*.db files) through FTP into my online server's `filterscripts` folder (Windows sa-mp server, on my local computer Windows too). Game mode added some data into DBs with db_query( db_link, "INSERT INTO ..." );. So i downloaded these DB files back on my computer and can't open/edit any of them.

SQLite Administrator shows message box "qAdmin: Cannot perform this operation on a closed dataset." SQLite Maestro shows message box "SQL Error: library routine called out of sequence"

If data was added to DBs by my local windows server, DB files still can be edited properly.

Any ideas?
MX_Master is offline  
Old 08/03/2009, 11:00 AM   #2
Y_Less
Beta Tester
 
Y_Less's Avatar
 
Join Date: Jun 2008
Location: 629 - git.io/Y
Posts: 18,316
Reputation: 2579
Default Re: SQLite DB problems

They may be locked, make sure you closed them remotely properly.
Y_Less is offline  
Old 08/03/2009, 12:51 PM   #3
MX_Master
Huge Clucker
 
Join Date: Jul 2007
Posts: 395
Reputation: 0
Default Re: SQLite DB problems

You mean properly usage of db_close ? I checked 3 GMs. First open DB into OnGameModeInit and db_close it into OnGameModeExit. Second opens and closes DB after each query. Third opens DB file into main() and has no db_close. Still one result - can't open DB file after downloading it back to my computer.
MX_Master is offline  
Old 08/03/2009, 02:04 PM   #4
Y_Less
Beta Tester
 
Y_Less's Avatar
 
Join Date: Jun 2008
Location: 629 - git.io/Y
Posts: 18,316
Reputation: 2579
Default Re: SQLite DB problems

The third one would be a problem then.
Y_Less is offline  
Old 08/03/2009, 03:14 PM   #5
MX_Master
Huge Clucker
 
Join Date: Jul 2007
Posts: 395
Reputation: 0
Default Re: SQLite DB problems

yea, but "open problem" i saw in any of these cases
MX_Master is offline  
Old 08/03/2009, 03:20 PM   #6
Y_Less
Beta Tester
 
Y_Less's Avatar
 
Join Date: Jun 2008
Location: 629 - git.io/Y
Posts: 18,316
Reputation: 2579
Default Re: SQLite DB problems

What?
Y_Less is offline  
Old 08/03/2009, 05:28 PM   #7
MX_Master
Huge Clucker
 
Join Date: Jul 2007
Posts: 395
Reputation: 0
Default Re: SQLite DB problems

In any way even if i closes DB files remotely properly, this problem is still here.
MX_Master is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLite Problems Anwix Help Archive 0 14/02/2010 10:25 PM
SQLite Tutorials? typedef Help Archive 1 30/01/2010 08:36 PM
SQLite question. Outbreak Help Archive 5 26/11/2009 07:22 PM
SQLite Sergei Help Archive 1 10/10/2009 09:43 PM
SQLite MarcoNecroX Server Support 6 20/04/2009 07:15 PM


All times are GMT. The time now is 12:40 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.