php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #29477 Apache & CGI crash on insert query
Submitted: 2004-08-01 02:59 UTC Modified: 2005-02-22 01:00 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: phprazor at dap dot ro Assigned:
Status: No Feedback Package: SQLite related
PHP Version: 5CVS-2004-08-01 (dev) OS: Windows XP
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2004-08-01 02:59 UTC] phprazor at dap dot ro
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.";
}
?>


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-22 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Fri Sep 17 13:03:37 2021 UTC