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 back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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: Mon Jun 15 17:00:02 2026 UTC