php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: toni dot viemero at iki dot fi
New email:
PHP Version: OS:

 

 [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: Wed Jun 24 20:00:01 2026 UTC