I'm having a really _weird_ problem with PHP 4.2.x and Oracle 8i (8.1.6). I recently decided it was time to update php on our development server, in preparation of updating the production server. Currently, they are both running 4.0.3pl1.
I downloaded, compiled and installed 4.2.2 on the dev server, as a static module. (for some reason, i've never been able to get php to compile as a DSO with oracle support...) The install seemed to go ok, everything seemed to be working. phpinfo() works, reports all kinds of nifty information about the system. However, in the course of testing, I noticed that some of our web pages were returning incomplete data sets, or no data at all. For example, I have one page that displays all the work requests for the logged in user, and it suddenly wasn't displaying anything at all. I modified the page to print out the exact sql code it was going to use to retrieve the data, and then ran that sql on the server myself (thru sqlplus). It worked fine, and returned the correct data. The php page, however, returns nothing.... On another page that we use to administer users to the system, it is supposed to retrieve all the user names from a table and display them in a select box. With 4.03pl1, it works properly, and displays all the user names. With 4.2.2 (or 4.2.1..), the list of users is incomplete. And it's not just missing some off the end either, there are just some of the users "missing" from the list at various points... Again, I took the exact sql from the page, tried it out in sqlplus, and the correct data was returned. This just seems extremely strange to me... Has anybody else had a similar problem with oracle 8i and the newer versions of php? Here's some info about the dev system: PIII-600 RedHat 6.1 (kernel 2.4.17) Apache 1.3.26 PHP 4.2.2 (currently php 4.03pl1 though.. :) Oracle 8i (8.1.6) The configure command I'm using for php is: ./configure --with-apache=../../apache_1.3.26 --enable-ftp --with-oracle=/u01/app/oracle/product/8.1.6 --with-oci8=/u01/app/oracle/product/8.1.6 the configure command for apache is: ./configure --prefix=/usr/local/apache --activate-module=src/modules/php4/libphp4.a --enable-shared=max --enable-module=all Does php make a log when you run a make? Maybe there's something that's not quite compiling properly or something.... If anyone needs additional information, just let me know and I'll be happy to provide it. I'd really like to be able to get our servers up to a newer version of PHP. Thanx! Kevin Hanser System Administrator Merchant Internet Group, Inc. ShopsForMe.com [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
