|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #28112 sqlite_query() crashing apache on malformed query
Submitted: 2004-04-23 00:10 UTC Modified: 2004-04-23 01:02 UTC
From: csaba at alum dot mit dot edu Assigned:
Status: Closed Package: SQLite related
PHP Version: 5.0.0RC2RC1, 4.3.7dev OS: *
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: csaba at alum dot mit dot edu
New email:
PHP Version: OS:


 [2004-04-23 00:10 UTC] csaba at alum dot mit dot edu
apache dies on an empty query (Apache.exe has generated errors and will be closed by Windows ...).

Note that it does not die if the second line in the code below is missing [sqlite_query ($db, "create table frob ..." ].  Also, sqlite_query did OK.

Csaba Gabor

PS.  Note that this appears similar to bug 25502 at

Reproduce code:
if (!($db = sqlite_open(":memory:", 666, $error))) die ("Couldn't open the database");
sqlite_query($db, "create table frob (foo INTEGER PRIMARY KEY, bar text);");
$res = sqlite_array_query($db, "");
print "passed";

Expected result:
I wouldn't expect more than a warning.  Taking the entire server down seems extreme.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-23 00:12 UTC] csaba at alum dot mit dot edu
Doggone it.  The title was supposed to be sqlite_array_query() crashing apache on malformed query.
 [2004-04-23 01:01 UTC]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc.

If possible, make the script source available online and provide
an URL to it here. Try avoid embedding huge scripts into the report.
 [2004-04-23 01:02 UTC]
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
Thank you for the report, and for helping us make PHP better.

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Jun 17 08:01:32 2024 UTC