ID: 48505 Updated by: [email protected] Reported By: amitshahc at hotmail dot com -Status: Open +Status: Closed Bug Type: Informix related Operating System: RHEL5, any linux PHP Version: 5.2.9 New Comment:
The informix database driver is not bundled with PHP, plus it doesn't seems to be maintained anymore: http://pecl.php.net/package/informix Try re-report the bug there, even though I wouldn't expect a response, sorry Previous Comments: ------------------------------------------------------------------------ [2009-06-09 13:51:07] amitshahc at hotmail dot com sorry, this bug means not solutions but let us consider it as a trick or tip or the way to overcome the bug. Thanks ------------------------------------------------------------------------ [2009-06-09 13:47:51] amitshahc at hotmail dot com Description: ------------ Solution: related to PHP Bugs: #32954 & #8715. I think it's memory issue with apache handling the informix result id. with text datatype. i don't know exactly as i am not ESQL/C developer. but i used a combination of settings before executing the select query which have the text field in the result. Set ifx_blobinfile_mode(1); ifx_textasvarchar(0); will return the blob id, in text field value instead of the giving text contect directly into that field. then do ifx_get_blob($row['text_field_name']). will return the file name. and then read that file content, store it in the variable. and delete the file. doing ifx_free_blob($row['text_field_name']); again crashes the php script sometimes. so don't do it. but you can do ifx_free_result($resultId); at the end of the script. All The Best... Amit Shah ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48505&edit=1
