Mombu the Php Forum sponsored links

Go Back   Mombu the Php Forum > Php > #35023 : invalid insert query causes crash with user defined function
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 20th April 09:48
php-bugs
External User
 
Posts: 1
Default #35023 : invalid insert query causes crash with user defined function


From: mark-phpbugs at vectrex dot org dot uk
Operating system: Linux 2.6, Debian
PHP version: 5.0.5
PHP Bug Type: SQLite related
Bug description: invalid insert query causes crash with user defined function

Description:
------------
When using a user defined function, a badly formed insert
query crashes PHP. Normally this query would (correctly) generate a SQL
error.

Reproduce code:
---------------
http://www.gensortium.com/~mark/sqlitetest.php.txt

Expected result:
----------------
Should give a PHP warning, with an SQL error (invalid column or something)

Actual result:
--------------
PHP Apache process crashes

--
Edit bug report at http://bugs.php.net/?id=35023&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35023&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35023&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35023&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=35023&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=35023&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=35023&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=35023&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=35023&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=35023&r=support
Expected behavior: http://bugs.php.net/fix.php?id=35023&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=35023&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=35023&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=35023&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35023&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=35023&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=35023&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=35023&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=35023&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=35023&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=35023&r=mysqlcfg
  Reply With Quote


  sponsored links


2 20th April 09:48
External User
 
Posts: 1
Default #35023 : invalid insert query causes crash with user defined function


ID: 35023
Updated by: pookey@php.net
Reported By: mark-phpbugs at vectrex dot org dot uk
-Status: Open
+Status: Feedback
Bug Type: SQLite related
Operating System: Linux 2.6, Debian
PHP Version: 5.0.5
New Comment:

appears to result in
Warning: SQLiteDatabase::queryExec(): no such column:
admin in /home/pookey/test.php on line 39

on 5.1-RC4.

Mark - please retry with more recent version.


Previous Comments:
------------------------------------------------------------------------

[2005-10-30 13:17:38] mark-phpbugs at vectrex dot org dot uk

Description:
------------
When using a user defined function, a badly formed insert
query crashes PHP. Normally this query would (correctly) generate a SQL
error.

Reproduce code:
---------------
http://www.gensortium.com/~mark/sqlitetest.php.txt

Expected result:
----------------
Should give a PHP warning, with an SQL error (invalid column or
something)

Actual result:
--------------
PHP Apache process crashes


------------------------------------------------------------------------


--
Edit this bug report at http://bugs.php.net/?id=35023&edit=1
  Reply With Quote
3 20th April 09:48
php-bugs
External User
 
Posts: 1
Default #35023 : invalid insert query causes crash with user defined function


ID: 35023
User updated by: mark-phpbugs at vectrex dot org dot uk
Reported By: mark-phpbugs at vectrex dot org dot uk
-Status: Feedback
+Status: Closed
Bug Type: SQLite related
Operating System: Linux 2.6, Debian
PHP Version: 5.0.5
New Comment:

I've tested this in 5.1.0 RC4, appears to work fine in this version.

Closed

Mark


Previous Comments:
------------------------------------------------------------------------

[2005-10-30 14:39:43] pookey@php.net

appears to result in
Warning: SQLiteDatabase::queryExec(): no such column:
admin in /home/pookey/test.php on line 39

on 5.1-RC4.

Mark - please retry with more recent version.

------------------------------------------------------------------------

[2005-10-30 13:17:38] mark-phpbugs at vectrex dot org dot uk

Description:
------------
When using a user defined function, a badly formed insert
query crashes PHP. Normally this query would (correctly) generate a SQL
error.

Reproduce code:
---------------
http://www.gensortium.com/~mark/sqlitetest.php.txt

Expected result:
----------------
Should give a PHP warning, with an SQL error (invalid column or
something)

Actual result:
--------------
PHP Apache process crashes


------------------------------------------------------------------------


--
Edit this bug report at http://bugs.php.net/?id=35023&edit=1
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666