From: davidifre at yahoo dot com
Operating system: solaris 5.8
PHP version: 4.3.9
PHP Bug Type: MSSQL related
Bug description: PHP crashes on the REAL data type in a MSSQL query
Description:
------------
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());
$msdb=mssql_select_db("base_name",$id_con);
$result=mssql_query($req_SQL,$id_con);
--
Edit bug report at http://bugs.php.net/?id=30351&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30351&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30351&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30351&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=30351&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=30351&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=30351&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=30351&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=30351&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=30351&r=support
Expected behavior: http://bugs.php.net/fix.php?id=30351&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=30351&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=30351&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=30351&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30351&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=30351&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=30351&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=30351&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=30351&r=float
MySQL Configuration Error: http://bugs.php.net/fix.php?id=30351&r=mysqlcfg
