Topic: SQLite Query Error: "unable to open database file".

[Dewd]

Hello,

I have a bit of a problem with a simple message board using a SQLite database.

When my script queries:

Code: [Select]

SELECT * FROM posts ORDER BY id ASC
It works absolutely fine.

When I try to:

Code: [Select]

sqlite_query($handle, "INSERT INTO posts (name, post, date) VALUES ('" . $message_name . "', '" . $message_msg . "', '" . $message_date . "')") or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
It gives me a error saying:

Code: [Select]

Warning: sqlite_query() [function.sqlite-query]: unable to open database file in *script location* on line 24
Error in query: unable to open database file.
The whole condition is:

if (isset($_POST['name']) && isset($_POST['msg'])) {

$message_name = $_POST['name'];

$message_msg = $_POST['msg'];

$message_date = date("d/m/y");

sqlite_query($handle, "INSERT INTO posts (name, post, date) VALUES ('" . $message_name . "', '" . $message_msg . "', '" . $message_date . "')") or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));

echo '<b>Your post was successful!</b><br/>' ;
}


Is there something wrong? Am I using the strings wrongly? Is there a error in the query?

Thanks for any help.

[PFMaBiSmAd]

Since the query is generating an error about opening the file, best guess is that there is no valid/error-free sqlite_open() statement prior to the query.

It would really take seeing all the relevant code for anyone one to be able to see what might be causing the problem or to be able to duplicate it on their own system.

[chefsalat]

Hello Dewd,

i Had the same problem on my linux-System. My databases are in the directory "sqlite". The databases had the "0777" permissions. But the directory "sqlite" himself had the "0755" permissions.

A "chmod 0777 sqlite" had solved the problem.
I hope, it solves your problem too.