#39134 [Com]: PHP + FreeTDS 0.64 crashes when TEXT field with empty string encountered

From: Date: Thu, 20 Nov 2008 14:20:45 +0000
Subject: #39134 [Com]: PHP + FreeTDS 0.64 crashes when TEXT field with empty string encountered
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-131140@lists.php.net to get a copy of this message 
 ID:               39134
 Comment by:       afriabdul_md at yahoo dot co dot in
 Reported By:      jr-phpbugs at cedric dot unob dot cz
 Status:           No Feedback
 Bug Type:         MSSQL related
 Operating System: linux (irrelevant)
 PHP Version:      4.4.4
 New Comment:

request


Previous Comments:
------------------------------------------------------------------------

[2007-07-19 01:00:01] php-bugs at lists dot php dot net

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

------------------------------------------------------------------------

[2007-07-11 13:01:38] jani@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows (zip):
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

For Windows (installer):

  http://snaps.php.net/win32/php5.2-win32-installer-latest.msi



------------------------------------------------------------------------

[2007-06-07 17:01:28] tsidelinger at columbuslibrary dot org

We are experiencing a similar issue.  Our php scripts will segment
fault when a NULL record is encountered.

PHP version: php4-4.3.4-43.77
OS: SLES9 x86_64
FreeTDS Version: 0.64
ODBC Version: unixODBC-2.2.12-13

Our development server is 32 bits, but otherwise identical.  Everything
works great in development.

We have tried the same sql queries via isql and the work just fine. 
Thus, this seems like a PHP issue.

Here is a sample PHP script below.

<html>
<body>
<table>

<?php
# connect to the Database
$connect = odbc_connect("volunteens-devl", "xxxxxxx", "xxxxxxxx");

# query the users table for all fields
$query = "select top 20 registration_date from REGISTRATIONS";

# perform the query
$result = odbc_exec($connect, $query);

# fetch the data from the database
while(odbc_fetch_row($result))
{
    $field1 = odbc_result($result, 1);
    print("<tr><td>$field1</td></tr>");
    }

# close the connection
odbc_close($connect);

?>

</table>
</body>
</html>

------------------------------------------------------------------------

[2006-11-01 09:49:47] jr-phpbugs at cedric dot unob dot cz

Tested & confirmed: php_mssql extension does not have the problem
described. It is a php_sybase_ct extension bug in connection with
FreeTDS 0.64.

------------------------------------------------------------------------

[2006-10-31 15:41:33] fmk@php.net

try using --with-mssql instead of --with-sybase-ct. When you are
compiling with the sybase option you are not using the MSSQL extension
but the sybase extension that happens to have aliasses so you can use
mssql_* when you call the functions.

- Frank

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/39134

-- 
Edit this bug report at http://bugs.php.net/?id=39134&edit=1

Thread (10 messages)

« previous php.bugs (#131140) next »