#23622 [Opn->Csd]: sqlite_query() problem in include/manual-lookup.inc

ID: 23622 Updated by: goba@php.net Reported By: toni dot viemero at iki dot fi -Status: Open +Status: Closed Bug Type: Website problem Operating System: Linux PHP Version: 4.3.1 New Comment: So the bug should be closed... Previous Comments: ------------------------------------------------------------------------ [2003-05-15 03:19:06] toni dot viemero at iki dot fi Moved fi.php.net to non-NFS mount and now SQLite is working as expected. ------------------------------------------------------------------------ [2003-05-14 21:56:40] wez@php.net sqlite uses fcntl() to manage locking. You'll probably have a better experience if you move the mirror to a partition that is not NFS mounted. ------------------------------------------------------------------------ [2003-05-14 10:37:48] toni dot viemero at iki dot fi I compiled and tested with SQLite 0.9b. http://fi.php.net/echo results in: Warning: sqlite_query() [function.sqlite-query]: database is locked in /home/toni/fi.php.net/include/manual-lookup.inc on line 109 http://fi.php.net/manual/en/function.echo.php worked ok /home is NFS mounted, does it affect database locking? ------------------------------------------------------------------------ [2003-05-14 08:08:48] wez@php.net Please try upgrading to the 0.9b release of sqlite and see if that cures the problem. ------------------------------------------------------------------------ [2003-05-14 00:17:57] toni dot viemero at iki dot fi I modified fi.php.net to have SQLite extension in PHP and this is what I get: Warning: sqlite_query() expects parameter 1 to be string, resource given in /home/toni/fi.php.net/include/manual-lookup.inc on line 109 Switching the "SELECT" query and $s around in line 109 got error "database is locked". ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23622&edit=1