#48505 [Opn->Csd]: PHP-Informix ifx_fetch_row, text data type crash solution
ID: 48505
Updated by: kalle@php.net
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
Thread (3 messages)