ID: 31954 Comment by: virtue at rocketmonkeys dot com Reported By: okke at formsma dot nl Status: No Feedback Bug Type: InterBase related Operating System: Windows XP SP1 PHP Version: 5.0.3 New Comment:
I'm experiencing this bug, and I think it might be the same issue. I make a page with just this: <? ibase_connect( "(database_filename)", "(username)", "(password)" ); ibase_query( "create table test ( id integer not null primary key, field1 boolean );" ); ibase_query( "select * from test" ); ?> The connect and "CREATE TABLE" run fine, but the "SELECT" statement crashes Apache. If I do the same thing without the boolean field, this doesn't happen. The same statements work fine in IBConsole, so it doesn't seem to be any problem with Interbase or the SQL code itself. I think this bug needs to be reopened, unless I missed something simple. php 5.2.5 apache 2.2.6 interbase 2007 on PC, version WI-V8.1.0.257 Previous Comments: ------------------------------------------------------------------------ [2005-03-20 18:09:20] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [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
