PHP :: Bug #30114 :: crash php-cli after "CREATE TABLE " and "DROP TABLE"

[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
----

[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".

Patches

Pull Requests

History

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2024 The PHP Group All rights reserved.	Last updated: Fri Apr 19 16:01:27 2024 UTC