ID:               30114
 User updated by:  max at webscript dot ru
 Reported By:      max at webscript dot ru
-Status:           Feedback
+Status:           Open
 Bug Type:         InterBase related
 Operating System: Win XP Pro
 PHP Version:      5CVS-2004-09-16 (dev)
 New Comment:

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.


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

[2005-02-23 21:24:19] [EMAIL PROTECTED]

Please post the Interbase library versions returned by phpinfo()

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

[2004-09-16 14:45:00] 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
----


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


-- 
Edit this bug report at http://bugs.php.net/?id=30114&edit=1

Reply via email to