ID: 31954 Updated by: [EMAIL PROTECTED] Reported By: okke at formsma dot nl -Status: Feedback +Status: No Feedback Bug Type: InterBase related Operating System: Windows XP SP1 PHP Version: 5.0.3 New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2005-02-24 07:32:42] [EMAIL PROTECTED] Please try if the error can be reproduced with a php_interbase.dll built from source using the ibase.h header file that comes with Interbase 7.1 ------------------------------------------------------------------------ [2005-02-23 22:44:05] okke at formsma dot nl I used the pre-built one from PHP.net ------------------------------------------------------------------------ [2005-02-23 20:51:04] [EMAIL PROTECTED] Did you build php_interbase.dll from source, or did you use the pre-built one from php.net? ------------------------------------------------------------------------ [2005-02-13 12:23:16] okke at formsma dot nl Description: ------------ I'm using interbase 7. I made a table using a BOOLEAN field. Everything worked fine, until I tried to extract data from the table. Then I found out that the BOOLEAN field was crashing PHP (and, in succession, apache). The error I got with PHP was (command line client): "Warning: ibase_fetch_assoc(): Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure in [...]" (for search-sake: the Apache error was "Parent: child process exited with status 3221225477 -- Restarting.") The problem is not a database failure; IBconsole and Database Workbench both handle the test-SQL perfectly. Reproduce code: --------------- I left the PHP code out, for readability. I'm using ibase_connect(), ibase_query() and ibase_fetch_assoc(). Run the following SQL first: CREATE TABLE TEST ( ID INTEGER NOT NULL, PUBLISHED BOOLEAN DEFAULT 0, CONSTRAINT PK_CMS PRIMARY KEY (ID) ) ; Fill the database with some lines, it doesn't matter what exactly: INSERT INTO TEST(ID, PUBLISHED) VALUES(1,false); INSERT INTO TEST(ID, PUBLISHED) VALUES(2,true); INSERT INTO TEST(ID, PUBLISHED) VALUES(3,false); INSERT INTO TEST(ID, PUBLISHED) VALUES(4,true); Then try to extract data from the database: SELECT * FROM TEST; Expected result: ---------------- (after ibase_query()): an array with the values from the database. Actual result: -------------- A big fat error, where after PHP and Apache will crash. The problem occurs on the line with ibase_query(). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31954&edit=1
