php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #23622 sqlite_query() problem in include/manual-lookup.inc
Submitted: 2003-05-14 00:17 UTC Modified: 2003-05-15 05:02 UTC
From: toni dot viemero at iki dot fi Assigned:
Status: Closed Package: Website problem
PHP Version: 4.3.1 OS: Linux
Private report: No CVE-ID: None
 [2003-05-14 00:17 UTC] 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".

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-05-14 08:08 UTC] wez@php.net
Please try upgrading to the 0.9b release of sqlite and see if that cures the problem.
 [2003-05-14 10:37 UTC] 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 21:56 UTC] 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-15 03:19 UTC] toni dot viemero at iki dot fi
Moved fi.php.net to non-NFS mount and now SQLite is working as
expected.
 [2003-05-15 05:02 UTC] goba@php.net
So the bug should be closed...
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved.
Last updated: Mon Jun 15 16:00:01 2026 UTC