|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #30351 PHP crashes on the REAL data type in a MSSQL query
Submitted: 2004-10-07 11:01 UTC Modified: 2005-11-18 20:04 UTC
Avg. Score:4.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: davidifre at yahoo dot com Assigned: fmk (profile)
Status: Closed Package: MSSQL related
PHP Version: 4.3.9 OS: solaris 5.8
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
45 - 31 = ?
Subscribe to this entry?

 [2004-10-07 11:01 UTC] davidifre at yahoo dot com
I use freetds 0.62.4.

I have a table with rows of different data type (binary, datetime, int, bit, smallint, tinyint, varbinary, varchar and real). A query with a request on the real data row (name is "value") will crash php whereas other requests are ok: here is what i have in my apache logs

[Thu Oct  7 09:11:16 2004] [notice] child pid 3045 exit signal Bus Error (10)

It is not browser dependent but with Netscape7 I have a message "this document contains no data".

any idea?

compiled (I removed every path):
--with-apache --with-ldap --with-mysql --with-pgsql --with-sybase --with-oracle --with-oci8 --with-mssql --with-gd --with-zlib-dir --with-zip --with-jpeg-dir --with-png-dir --with-tiff-dir --with-pdflib --with-imap --with-snmp --with-mcrypt --with-sablot --with-expat-dir --with-gettext --enable-sysvsem --enable-sysvshm --enable-yp --enable-ftp --enable-calendar --enable-mbstring=all --without-pear --disable-cli

Reproduce code:
$req_SQL="SELECT value from table_name";
$id_con=mssql_connect("host:port","username","pwd") or die ("Could not connect to database: ".mssql_get_last_message());


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-10-19 14:34 UTC] davidifre at yahoo dot com
do you know if this is a bug? Am I alone to experience this problem?

 [2005-05-30 10:34 UTC] freddyz77 at tin dot it
What operation system are you using?
Have you tried to update FreeTDS version?

(FreeTDS developer)
 [2005-08-09 09:05 UTC] freddyz77 at tin dot it
Well, which processor are you using? Try with FLOAT type instead of REAL.

 [2005-11-18 20:04 UTC]
There is no longer a problem with the latest version of FreeTDS
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Feb 29 03:01:27 2024 UTC