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