#29477 [NEW]: Apache & CGI crash on insert query

From: phprazor at dap dot ro Operating system: Windows XP PHP version: 5CVS-2004-08-01 (dev) PHP Bug Type: SQLite related Bug description: Apache & CGI crash on insert query Description: ------------ I used IIS 5.0 with the CGI version of php5 and I was getting a "CGI has encountered an error..." . I read about other bugs with SQLite and some users were suggesting the use of Apache. So i switched from the CGI version of php running with IIS to running it as a module with Apache 2.0. when i run the code, it tells gives me an "Apache has encountered an error..." dialog. I'm trying to create a script to process a registration form. It would take the data, an store it in an SQLite database. I tried commenting out the INSERT query and i get no error. It seems the INSERT Query is the problem. A SELECT query workd fine. Can someone help? Reproduce code: --------------- <?php if (isset($_POST["username"])) { $db = sqlite_open("db/db.chat"); sqlite_query("INSERT INTO users VALUES(NULL, ".$_POST['username'].", ".$_POST['password'].")",$db); echo "done."; } ?> -- Edit bug report at http://bugs.php.net/?id=29477&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29477&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29477&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29477&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29477&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29477&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29477&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29477&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29477&r=support Expected behavior: http://bugs.php.net/fix.php?id=29477&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29477&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29477&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29477&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29477&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29477&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29477&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29477&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29477&r=float