File is not a SQLite 3 Database

File is not a SQLite 3 Database - 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: File is not a SQLite 3 Database (/showthread.php?tid=476949)

File is not a SQLite 3 Database - Voxel - 21.11.2013

Hello guys,

I'm having a problem with my SQLite database.... all the sudden when i try to open it with my SQLite database browser i get this error "File is not a SQLite 3 Database". This just happened after i added factions and faction ranks to my database... i had a error aswell saying that this line was to long after a submission (the line from the database under OnPlayerDisconnect)

pawn Код:

//the format line was the error line
new Query[128];
format(Query, sizeof(Query), "UPDATE users SET admin = %d, vip = %d, faction = %d, faction rank = %d, money = %d, rank = %d, exp = %d, kills = %d, deaths = %d WHERE username = '%s'", User[playerid][USER_ADMIN], User[playerid][USER_VIP], User[playerid][USER_FACTION], User[playerid][USER_FACTIONRANK], GetPlayerMoney(playerid), GetPlayerScore(playerid), User[playerid][USER_EXP], User[playerid][USER_KILLS], User[playerid][USER_DEATHS], DB_Escape(User[playerid][USER_NAME]));
db_query(Database, Query);

Help please?

Re: File is not a SQLite 3 Database - Konstantinos - 21.11.2013

Is the size of the .db file 0?

I used to get that error when it created the .db file from the script and then tried to open it with a SQLite Browser before creating atleast a table (from the script).

EDIT: If the problem remains, then try to downgrade the version of the SQLite Browser.

Re: File is not a SQLite 3 Database - newbie scripter - 21.11.2013

Wrong Post. Edited

Re: File is not a SQLite 3 Database - Voxel - 21.11.2013

Quote:

Originally Posted by Konstantinos

Is the size of the .db file 0?

I used to get that error when it created the .db file from the script and then tried to open it with a SQLite Browser before creating atleast a table (from the script).

EDIT: If the problem remains, then try to downgrade the version of the SQLite Browser.

Yes the file size is 0, which SQLite browser do you use or suggest?

Re: File is not a SQLite 3 Database - Konstantinos - 21.11.2013

Quote:

Originally Posted by Voxel

Yes the file size is 0, which SQLite browser do you use or suggest?

I used SQLite Database Browser 2.0 b1 and I recommend you to use it as well.

You can get rid of it easily, I've got two solutions.

1st: After opening the database to the script, execute a query to create a table (through the script).

2nd: Creating a new database and a table through the SQLite Browser.

For both of them, you will be able to open the .db file later on.

Re: File is not a SQLite 3 Database - Voxel - 21.11.2013

Quote:

Originally Posted by Konstantinos

Yeah thats what i use aswell, how do i execute a query to create a table in the script?

Re: File is not a SQLite 3 Database - Konstantinos - 21.11.2013

Quote:

Originally Posted by Voxel

Yeah thats what i use aswell, how do i execute a query to create a table in the script?

An example:

pawn Код:

// In OnGameModeInit or OnFilterScriptInit:
Database = db_open( "server.db" );
db_query( Database, "CREATE TABLE IF NOT EXISTS users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(24) COLLATE NOCASE, password VARCHAR(129), admin INTEGER DEFAULT 0 NOT NULL)" );

Re: File is not a SQLite 3 Database - Voxel - 21.11.2013

I found the real problem though, i had:

pawn Код:

db_query(Database, "CREATE TABLE IF NOT EXISTS users (userid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(24) COLLATE NOCASE, password VARCHAR(129), admin INTEGER DEFAULT 0 NOT NULL, vip INTEGER DEFAULT 0 NOT NULL, faction VARCHAR(24) COLLATE NOCASE, factionrank INTEGER DEFAULT 0 NOT NULL, money INTEGER DEFAULT 0 NOT NULL, rank INTEGER DEFAULT 0 NOT NULL, exp INTEGER DEFAULT 0 NOT NULL, kills INTEGER DEFAULT 0 NOT NULL, deaths INTEGER DEFAULT 0 NOT NULL)");

factionrank was faction rank with a space in between, so i deleted the space and problem solved!

thanks again Konstantinos, dont know what i would have done without you

Re: File is not a SQLite 3 Database - Pottus - 21.11.2013

If your doing anything with SQLite make sure you use this include

https://sampforum.blast.hk/showthread.php?tid=303682

Add this to your gamemode

pawn Код:

#define DB_QUERY_ERRORS true
// automatically print errors (it's true by default)
#define DB_PRINT_ERRORS true
#include <sqlitei>

You will also need this

https://github.com/Zeex/amx_assembly

Now if there is any errors they will be printed out.

Re: File is not a SQLite 3 Database - Voxel - 21.11.2013

Quote:

Originally Posted by [uL]Pottus

If your doing anything with SQLite make sure you use this include

https://sampforum.blast.hk/showthread.php?tid=303682

Add this to your gamemode

pawn Код:

#define DB_QUERY_ERRORS true
// automatically print errors (it's true by default)
#define DB_PRINT_ERRORS true
#include <sqlitei>

You will also need this

https://github.com/Zeex/amx_assembly

Now if there is any errors they will be printed out.

Yes thank you.