ID: 32110 Updated by: [EMAIL PROTECTED] Reported By: marcos at ivirtua dot com dot br -Status: Open +Status: Bogus Bug Type: Reproducible crash Operating System: Linux PHP Version: 4.3.10 New Comment:
The MSSQL library used for this extension is not thread safe, and mght cause problems under any threaded web server. DBTEXTLIMIT is not supported by FreeTDS. I'll commit a patch for this. Previous Comments: ------------------------------------------------------------------------ [2005-02-25 15:24:32] marcos at ivirtua dot com dot br Sorry, the echo line must be: echo($row[0]); All the rest keep the same. ------------------------------------------------------------------------ [2005-02-25 15:21:07] marcos at ivirtua dot com dot br Description: ------------ I need to retrive more than 4k from a blob field (rtf text). I've set these values in my php.ini: mssql.textlimit = 2147483647; mssql.textsize = 2147483647; Everything works fine using CGI, but when using SAPI (dll) after some operations I can't connect to database anymore. A server restart is needed, and everything works fine again for some time, and crash again. I'm using Apache/1.3.33 (Win32) PHP/4.3.9, but it still happens in Apache 2.0 (Linux) PHP/4.3.10 Reproduce code: --------------- Use PHP ISAPI. <? ini_set("mssql.textlimit", "2147483647"); ini_set("mssql.textsize", "2147483647"); mssql_connect('db_host', 'db_user', 'db_pass'); mssql_select_db('db_name'); $qry= mssql_query('select myblobfield from table'); $row=mssql_fetch_row($qry); echo($row_aux[0]); ?> Repeat for some times (10, 20, 30 times, etc). Expected result: ---------------- The full content of blob field, wich has more then 100KB, every time I run the code. Actual result: -------------- The full content of blob field for just some times. After a period, the server must be restarted because I can't connect with: mssql_connect('db_host', 'db_user', 'db_pass'); mssql_select_db('db_name'); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32110&edit=1