#28112 [Opn->Fbk]: sqlite_query() crashing apache on malformed query

ID: 28112 Updated by: helly@php.net Reported By: csaba at alum dot mit dot edu -Status: Open +Status: Feedback Bug Type: SQLite related Operating System: Win 2K Pro PHP Version: 5CVS-2004-04-22 (dev) New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2004-04-23 00:12:00] 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 00:10:10] csaba at alum dot mit dot edu Description: ------------ 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 http://bugs.php.net/bug.php?id=25502 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28112&edit=1