|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #23936 fail to "select and fetch"
Submitted: 2003-06-01 09:26 UTC Modified: 2003-08-12 20:30 UTC
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: sarusij at yahoo dot com Assigned: abies (profile)
Status: Closed Package: InterBase related
PHP Version: 4.3.2 OS: redhat 7.3
Private report: No CVE-ID: None
 [2003-06-01 09:26 UTC] sarusij at yahoo dot com
I was using RedHat 7.3 with Interbase 6.0.1 every thing worked fine (Apache 1.3.x php 4.1.x).
In order to get better performance updated to redhat 8 (apache 2.0.40 php 4.2.2) and interbase 7 (trial)
generated using ./compile --with-interbase=shared,/opt/interbase
all in place, restart httpd, when accesing page with a database select it returns:-
Warning: InterBase: Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure in /home/web-site/htdocs/ on line 31

line 31 =  $arr=ibase_fetch_row($sth);

By mistake I have, in one of the time forgot to change to that was compiled with interbase 7 and left related to interbase 6, the warning above did not appear and seemed like everything operates ok.

Using the tests within ext/interbase I found that test 5 (transactions) failed, it alsio failed when I have interbase 6.0.1. It did not fail using the original installation (RH7.3, IB6.0.1, php4.1.x apache 1.3.x)

I have been doing it all also with php 4.3.1 with same results.

What should I do in order to get the basic RH8 (apache 2.0.40 and php 4.2.2) instalation to operate correctly with interbase 7 (module
Thanks for help


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-06-12 10:10 UTC] sarusij at yahoo dot com
Ok, I have reinstalled RH73 Interbase 6.0.1 changed php to 4.3.2 worked ok.
removed Interbase 6, installed interbase 7 using (generated with the previous interbase 6.0.1) seem worked ok (didn't full test my application).

now generated with interbase 7 (./compile --with-interbase=shared,/opt/interbase > make) put it in place, started httpd and interbase and wht we get ? the exact same error !Warning: InterBase: Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure in /home/web-site/htdocs/ on line 31

the question changed now, what shoud I do in order to get PHP and interbase 7 work together ? I asume the problem is in generating the
 [2003-07-09 22:03 UTC]
And you're sure 7.1 is backwards compatible with 6.0.1 ?
(ie. the databases created with 6.0.1 might not work with 7.x)
 [2003-07-10 11:28 UTC] sarusij at yahoo dot com
1. Using externals tools I manage to connect and update whatever I want in the database, this mean that the database is operational, the problem is with the generated while compiling php with interbase 7.
2. It failed also while testing using the tests in exp/interbase/tests
3. for the moment I am using php432 + interbase 7 using the generated for interbase 6. Since I don't know what might be the catches using it this way, I must get it working together the right way before going to production (soon).
4. I would be glad to know someone is using httpd 2.0.46 + php 4.3.2 + interbase 7
Thanks again
 [2003-08-12 08:16 UTC]
Please try using this CVS snapshot:
For Windows:

 [2003-08-12 20:30 UTC]
This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at
In case this was a documentation problem, the fix will show up soon at

In case this was a website problem, the change will show
up on the site and on the mirror sites in short time.
Thank you for the report, and for helping us make PHP better.

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue May 21 00:01:34 2024 UTC