#26389 [Opn->Fbk]: Use an sqlite db...
ID: 26389
Updated by: iliaa@php.net
Reported By: php at plouk dot net
-Status: Open
+Status: Feedback
Bug Type: SQLite related
Operating System: Linux debian
PHP Version: 5.0.0b2 (beta2)
New Comment:
Works just fine, try changing your query line to:
$res = sqlite_query($db,$req) or
die(sqlite_error_string(sqlite_last_error($db)));
and see what error (if any) do you get.
Previous Comments:
------------------------------------------------------------------------
[2003-11-25 12:44:49] php at plouk dot net
The script run via a webserver...
------------------------------------------------------------------------
[2003-11-24 20:03:02] iliaa@php.net
If you are running it not via a webserver (user != nobody) chmod the
file 666. Otherwise re-open the bug.
------------------------------------------------------------------------
[2003-11-24 16:48:15] php at plouk dot net
The script result :
------------------
resource(2) of type (sqlite database)
NULL
bool(false)
------------------------------------------------------------------------
[2003-11-24 16:46:50] php at plouk dot net
Description:
------------
This script isn't able to create a table in an existing database. Why?
(No error are detected and permissions on the database file seem all
right)
#ls -l
-rw-rw-r-- 1 nobody nogroup 263 Nov 24 23:42 sqlite.php
-rw-rw-rw- 1 nobody nogroup 0 Nov 24 22:45 test.db
Reproduce code:
---------------
<?php
//sqlite.php
$db=sqlite_open('test.db', 0666, $sqlite_err);
echo var_dump($db).'<BR />';
echo var_dump($sqlite_err).'<BR />';
$req="CREATE TABLE my_table (value INTEGER PRIMARY KEY)";
$res=sqlite_query($db,$req);
echo var_dump($res).'<BR />';
sqlite_close($db);
?>
Expected result:
----------------
A table
Actual result:
--------------
Nothing, the db file is always a 0 byte's file...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26389&edit=1
Thread (6 messages)