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
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: max at webscript dot ru
New email:
PHP Version: OS:

 

 [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-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 12:01:30 2024 UTC