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

go to bug id or search bugs for

Bug #30114 crash php-cli after "CREATE TABLE " and "DROP TABLE"
Submitted: 2004-09-16 14:45 UTC Modified: 2005-05-22 01:00 UTC
Votes:3
Avg. Score:1.3 ± 0.5
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:2 (200.0%)
From: max at webscript dot ru Assigned: abies (profile)
Status: No Feedback Package: InterBase related
PHP Version: 5CVS-2004-09-16 (dev) OS: Win XP Pro
Private report: No CVE-ID: None
View Developer Edit
 [2004-09-16 14:45 UTC] max at webscript dot ru 
Description:
------------
when i try to create table via ibase_query() and then drop table it crash php (cli and mod_php)
Table droped successfully but WinXP show window with error in php.exe (or apache.exe if i test it with mod_php)

Reproduce code:
---------------
$host = 'localhost:C:\BASE\MY.GDB';
$conn = ibase_connect($host, 'SYSDBA', 'masterkey');

$sql = "CREATE TABLE test_charset(ch varchar(200))";
ibase_query($conn, $sql) or die(ibase_errmsg());

$sql = "DROP TABLE test_charset";
ibase_query($conn, $sql) or die(ibase_errmsg());


Expected result:
----------------
it must create table and then drop it without any errors and warnings

Actual result:
--------------
i got window whihc inform me, that error happened in php.exe.
-------
AppName: php.exe  AppVer: 5.0.2.2   ModName: msvcrt.dll
ModVer: 7.0.2600.0   Offset: 0002f548
----

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-23 21:24 UTC] abies@php.net 
Please post the Interbase library versions returned by phpinfo()
 [2005-02-25 05:25 UTC] max at webscript dot ru 
I've seen interbase client version and it was Firebird 1.0/Interbase 6.
But I have FireBurd 1.5
Yes,  that was my fault.

I took fbclient.dll from my firebird,  renamed it to gds32.dll and put it to Windows/System32

Then i get such results :

php-code :
--------
$host = 'localhost:C:\BASE\MY.GDB';
$conn = ibase_connect($host, 'SYSDBA', 'masterkey');

$sql = "CREATE TABLE test_ch(ch varchar(200))";
ibase_query($conn, $sql) or die(ibase_errmsg());

$sql = "DROP TABLE test_ch";
ibase_query($conn, $sql) or die(ibase_errmsg());
-------

At first time i get such error :
-------
Warning: ibase_query(): Dynamic SQL Error SQL error code = -607 table/view TEST_CH does not exist  in C:\1\aa\abort.php on line 9
Dynamic SQL Error SQL error code = -607 table/view TEST_CH does not exist 
-------

If i'll try to exec this script second time i get error :
-------
Warning: ibase_query(): unsuccessful metadata update Table TEST_CH already exists  in C:\1\aa\abort.php on line 6
unsuccessful metadata update Table TEST_CH already exists 
-------

So table was not deleted.
 [2005-02-25 05:28 UTC] max at webscript dot ru 
Ooops, i forgot to tell you my firebird client's version.
phpinfo show's :
Run-time Client Library Version => WI-V6.3.1.4481 Firebird 1.5
 [2005-05-14 12:28 UTC] tony2001@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php5-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.0-win32-latest.zip
 [2005-05-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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Oct 31 09:00:01 2025 UTC