PHP 4.0 Bug #9917 Updated: left open Oracle cursors break mail() function

ID: 9917 User Update by: andrewmc@tomahawk.demon.co.uk Status: Open Bug Type: Oracle related Description: left open Oracle cursors break mail() function closing the cursors was a red herring, it worked for a bit then same problem occurred again. From having done some research and changing some scripts it seems that the problem starts after any PHP script which does putenv() has been run. Removing putenv() from all PHP scripts and setting up the environment in the Apache startup script instead seems to workaround the problem though is not ideal. Previous Comments: --------------------------------------------------------------------------- [2001-03-22 07:53:59] andrewmc@tomahawk.demon.co.uk PHP 4.0.4 staticly compiled into Apache 1.3.14 with Oracle 7.3.4 support - configure line as follows: ./configure --without-mysql --with-apache=/usr/local/apache_1.3.14 --with-ora cle=/devuat/oracle7.3.4 --enable-track-vars --enable-sigchild Apache started with PHPRC pointed to directory containing php.ini file with following line: sendmail_path = /usr/lib/sendmail -t -i Start Apache, run PHP script which uses mail() function...this works fine until a PHP script has been run which performs ora_* functions but does not close cursor resources. Subsequent mail() function calls result in no message and the following in the Apache error_log file: : is not an identifier This looks like stderr from /bin/sh (output below) $ strings /bin/sh|grep identif is not an identifier The following code before calls to mail() fixes the problem: for ($i=0; $i<10; $i++) ora_close ($i); Seems that unclosed cursors break mail() More info available if required. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=9917