php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #30907 ibase_query() crashes when inserting a -1 into a Interbase TIMESTAMP field
Submitted: 2004-11-26 14:24 UTC Modified: 2007-11-08 19:48 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: sandell at winwap dot com Assigned: abies (profile)
Status: Closed Package: InterBase related
PHP Version: 5CVS-2005-03-01 OS: WinXP Pro (SP2)
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sandell at winwap dot com
New email:
PHP Version: OS:

 

 [2004-11-26 14:24 UTC] sandell at winwap dot com 
Description:
------------
When inserting a -1 into a TIMESTAMP field in an interbase 7 database Apache crashes. When looking at the "More info" in the WinXP crash dialog it shows that it was mod "php_interbase.dll" that caused the crash.

System setup:
 Windows XP Pro, SP2
 Apache/2.0.50 (Win32) (Win32 bin files downloaded)
 PHP/5.0.2, extension INTERBASE used in php.ini
 Interbase 7 (WI-V7.1.0.131), TCP/IP connection (Localhost)
 No Zend optimizer

Note:
 If a value of 0 (zero) is given in the statement, then all works as expected.

Reproduce code:
---------------
1) Create the table "testtable" in a database with one field named "DTField" of type TIMESTAMP.

2) Execute the following code:
   // Crash Code
   $db = ibase_connect('','','','None',0,3);
   $sql = "INSERT INTO TestTable (DTField) VALUES (?)";
   $sth = ibase_query($db_intra, $sql, -1);
   ibase_commit($db);


Expected result:
----------------
The table should have a new entry

Actual result:
--------------
Apache crashes (php_interbase.dll)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-23 21:28 UTC] abies@php.net 
Did you build php_interbase.dll from source, or did you use the pre-built one from php.net?
 [2005-02-24 09:10 UTC] sandell at slobtrot dot com 
The PHP installation was not altered. It's the original PHP 5.0.2 installation (binary only).
 [2005-02-24 10:12 UTC] abies@php.net 
Please try if the error can be reproduced with a php_interbase.dll built from source using the ibase.h header file that comes with Interbase 7.1
 [2005-02-24 10:20 UTC] sandell at winwap dot com 
Compiling stuff is out of scope for me, sorry. The compiling must be done by someone else who knows how to do it.
 [2005-02-28 21:22 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip
 [2005-03-01 09:01 UTC] sandell at winwap dot com 
The new Snapshot (downloaded 1.3.2005) still causes Apache to crash.

Tested with:
- Interbase Server v7.1 (WI-V7.1.0.192).
- Apache 2.0.50
- PHP 5.1.0-DEV
 [2007-10-23 17:21 UTC] Lars dot Westermann at privat dot dk 
This bug is in fact the same as #32143

Look at the first param to ibase_query(). This is *not* the resource returned from ibase_connect().

The empty parameter is then passed as an empty querystring (as it is not a resource, it is treated as a (query)string). This empty querystring crashes IBserver 7 (but not Firebird 2).

A possible bugfix is suggested, and hopefully a bugfix is on it's way (in PHP 5.3).
 [2007-11-08 19:48 UTC] lwe@php.net 
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
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.

Fixed in HEAD and PHP_5_3
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 18:01:29 2024 UTC