ID: 20935 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Feedback Bug Type: MSSQL related Operating System: RedHat Linux 7.2 / Apache 1.3.27 PHP Version: 4.3.0 New Comment:
It doesn't seemd to be a FreeTDS bug. I tested the tarball and CVS version of FreeTDS with sqsh (a command line client that use FreeTDS library, www.sqsh.org) and it worked fine. But, when I do a remote connect with PHP using the same FreeTDS library, it segfault when I do a simple: $res = mssql_query("select * from Test"); The connection and selection of the database works fine. That's all that I can say for now. Thanks for all. Ernesto Previous Comments: ------------------------------------------------------------------------ [2003-01-21 11:03:02] [EMAIL PROTECTED] Can you test the same code under Win32 ? This could be a bug in FreeTDS. To my knowledge the latest version of that is 0.60! - Frank ------------------------------------------------------------------------ [2003-01-21 07:56:03] [EMAIL PROTECTED] recompiled as cgi but still generates the same error. (gdb) bt #0 0x00000000 in ?? () #1 0x08094c14 in _mssql_fetch_batch (mssql_ptr=0x82658f4, result=0x82682d4, retvalue=-1) at /home/jonas/devel/php-4.3.0/ext/mssql/php_mssql.c:1020 #2 0x08095267 in zif_mssql_query (ht=2, return_value=0x827731c, this_ptr=0x0, return_value_used=1) at /home/jonas/devel/php-4.3.0/ext/mssql/php_mssql.c:1143 #3 0x08194083 in execute (op_array=0x8264864) at /home/jonas/devel/php-4.3.0/Zend/zend_execute.c:1596 #4 0x0818406a in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /home/jonas/devel/php-4.3.0/Zend/zend.c:864 #5 0x08153e05 in php_execute_script (primary_file=0xbfffe780) at /home/jonas/devel/php-4.3.0/main/main.c:1573 #6 0x0819a234 in main (argc=3, argv=0xbfffe834) at /home/jonas/devel/php-4.3.0/sapi/cgi/cgi_main.c:1424 #7 0x40238657 in __libc_start_main (main=0x8199878 <main>, argc=3, ubp_av=0xbfffe834, init=0x8067d2c <_init>, fini=0x819aa40 <_fini>, rtld_fini=0x4000dcd4 <_dl_fini>, stack_end=0xbfffe82c) at ../sysdeps/generic/libc-start.c:129 ------------------------------------------------------------------------ [2003-01-02 18:45:35] [EMAIL PROTECTED] No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2002-12-11 08:42:28] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. ------------------------------------------------------------------------ [2002-12-11 08:40:15] [EMAIL PROTECTED] (FreeTDS 1.5 2002/08/24, MSSQL 7 (remote)) mssql_query causes when using the following SQLSTATEMENT "SELECT a.*, b.* FROM dbo.psl AS b LEFT JOIN dbo.prc AS a ON (a.idPSL = b.idPSL) WHERE b.OrderNo LIKE '%123169%' AND a.idPSL > '0'" while simple queries like "SELECT * FROM dbo.psl" works just fine. The problem appears only if the query tries to return information. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20935&edit=1