Segfault with PHP 4.0.3pl1/FreeTDS 0.51(Sybase-ct) under Linux

If you received a copy of this it is because you have a similar problem posted on bugs.php.net and I am curious if you have resolved the issue. Whose issue it, whether it be PHP, Apache, or FreeTDS I don't know. The following query works properly using FreeTDS 0.51 and the one below it does not(it cause apache to segfault). BOTH queries however both work when using ODBC(--with-esoob). I have tried recompiling all three parties; FreeTDS, php4.0.3pl1, and apache 1.3.14-ssl. I have also tried switching between TDS versions 4.2, 5.0, and 7.0, which doesn't really seem to make any change. The server I am attempting to chat with is a MS SQL Server version 7.0. It does not have any service packs, I realize that this may be a problem or the problem itself, but I am curious as to why it would not cause a segfault with the other queries I am doing. I have also removed GD support, etc. select radiusdat.username,radiusdat.callstart,radiusdat.callend,radiusdat.sessid, radiusdat.radid,radiusdat.termid,radsvr.hostname,termserv.termname, datediff(ss,radiusdat.callstart,radiusdat.callend) as c from radiusdat,radsvr,termserv where radiusdat.username='cnewbill' and radsvr.id = radiusdat.radid and termserv.id = radiusdat.termid and radiusdat.callstart >= '2000-11-01' and radiusdat.callend <= '2000-12-01' ORDER BY radiusdat.callstart select iheader.invoice,iheader.customer,customer.guarantor,iheader.shipname, iheader.total,iheader.paid,iheader.date,customer.id,customer.name,customer.u sername, customer.email,customer.nextstmt,customer.laststmt from iheader,customer where iheader.customer = customer.id and customer.username = 'cnewbill' and customer.active = 'Y' order by iheader.date /* The usual info */ './configure' '--with-ftp' '--with-mysql=/usr/local/' '--with-sybase-ct=/usr/local/freetds/' '--with-gd' '--with-jpeg-dir' '--with-png-dir' '--with-esoob' '--with-apache=../apache_1.3.14' Linux support.onewest.net 2.2.16-21 #1 Wed Aug 9 11:45:35 EDT 2000 i686 unknown SYBASE=/usr/local/freetds LD_LIBRARY_PATH=...:/usr/local/freetds CODE SNIPPET to reproduce crash <? $conn = mssql_connect("XXXXXXXX" , "XXXXXXX" , "XXXXXXXX" ); print "ConnectID: $conn<br>\n"; $query = " select iheader.invoice,iheader.customer,customer.guarantor,iheader.shipname,"; $query .= "iheader.total,iheader.paid,iheader.date,customer.id,customer.name,customer. username,"; $query .= "customer.email,customer.nextstmt,customer.laststmt from iheader,customer "; $query .= "where iheader.customer = customer.id and customer.username = 'cnewbill' and "; $query .= "customer.active = 'Y' order by iheader.date"; // DOESNT WORK PERIOD $query = "select * from iheader where iheader.customer=25813"; // DOESNT WORK PERIOD $query = "select * from customer where id=25813"; // WORKS print "Query $query.<BR><BR>"; print "I...can...make..."; $res = mssql_query("$query",$conn); print "it! Yeah, I made it."; mssql_close($conn); ?> /* No more info */ Current PHP bugs that sound familiar to problem http://bugs.php.net/bugs.php?id=7084 Any pointers etc would be helpful. Chris Newbill Programmer/Analyst OneWest.net Inc., 406-449-8056