Member Avatar for lewashby

I'm getting this

-> [Tue Sep 10 10:42:46 2013] [error] [client 127.0.0.1] PHP Warning: SQLite3::exec(): unable to open database file in /var/www/ET/insert.php on line 21, referer: http://localhost/ET/

I changed the owner of the DB file (et.sqlite3) to www-data and now this is what I'm getting. Before I changed the owner I was getting an "unable to write to DB" error. Code is below, any ideas? Thanks.

<?php

echo "<html>";
echo "<head>";
echo "</head>";
echo "<body>";

$db = new SQLite3('./et.sqlite3', SQLITE3_OPEN_READWRITE);

if(!$db)
{
    echo "Could not open/access DB";
}
else
{
    // get variable from html form
    $fName = $_POST['fname'];
    $lName = $_POST['lname'];
    $email = $_POST['email'];

    $db->exec("INSERT INTO customers VALUES('$fName', '$lName', '$email')");
}

echo "</body>";
echo "</html>";

?>
  • 3 Contributors
  • 6 Replies
  • 4K Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by lewashby

Recommended Answers

All 6 Replies

Member Avatar for cereal

Check if the file and also the directory containing the database, have read and write permissions.

Member Avatar for lewashby

This is the containing directory:
drwxr-xr-x 2 root root 4096 Sep 10 12:05 ET

Here is the file:
-rw-r--r-- 1 www-data root 2048 Aug 31 15:58 et.sqlite3
-rw-r--r-- 1 root root 410 Sep 10 10:35 insert.php

Member Avatar for mark5rockzz_1

try to...
change $db->exec("INSERT INTO customers VALUES('$fName', '$lName', '$email')");
to
$db->exec("INSERT INTO customers VALUES(" . $fName . "," . $lName . "," . $email . ")");
or
$db->exec("INSERT INTO customers VALUES(" . "'" . $fName . "'" . "," . "'" . $lName . "'" . "," . "'" . $email . "'" . ")");

Edited by mark5rockzz_1 because: add options
Member Avatar for cereal

Apache is running as root or as www-data user? It should be www-data, verify the output of:

ps -aux |grep apache

You should see the main process owned by root, the childs owned by www-data user. So, in order to work correctly, you have to change the ownership of the directory and of the files under the DocumentRoot of your website, try this:

sudo chown www-data:www-data -R /var/www/ET

With -R flag we recursively change the owners and the group of all the files inside ET directory. That should fix the problem.

Member Avatar for lewashby

Thanks guys, I'm a little closer but still not there yet. I chagned the insert line to this:

$db->exec("INSERT INTO customers VALUES(" .$fName . "," . $lName . "," . $email .")");

And now I'm getting this in the error log when I enter the name Bailey to be written into the fName field. The column name is

[Tue Sep 10 13:36:35 2013] [error] [client 127.0.0.1] PHP Warning: SQLite3::exec(): no such column: Bailey in /var/www/ET/insert.php on line 21, referer: http://localhost/ET/

Member Avatar for lewashby

Got it, thanks gusy.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.