PHP :: Bug #23622 :: sqlite_query() problem in include/manual-lookup.inc

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

View Developer Edit

[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.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2026 The PHP Group All rights reserved.	Last updated: Mon Jun 15 16:00:01 2026 UTC