| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #1495 | getAll() causes segmentation fault with sybase connection | ||
|---|---|---|---|
| Submitted: | 2004-05-25 16:52 UTC | ||
| From: | randys at barnes-homes dot com | Assigned: | danielc |
| Status: | Bogus | Package: | DB |
| PHP Version: | 4.3.6 | OS: | Linux |
| Roadmaps: | (Not assigned) | ||
[2004-05-25 16:52 UTC] randys at barnes-homes dot com
Description:
------------
Hi,
I am running Slackware 9.1, Apache/1.3.28, PHP 4.3.6 configured with:
'./configure' '--with-apxs=/usr/sbin/apxs' '--enable-force-cgi-redirect' '--enable-fastcgi' '--with-ncurses' '--prefix=/usr' '--enable-discard-path' '--with-config-file-path=/etc/apache' '--enable-safe-mode' '--with-openssl' '--with-zlib=/usr' '--enable-bcmath' '--with-bz2' '--with-pic' '--enable-calendar' '--enable-ctype' '--with-curl=shared' '--enable-dba=shared' '--with-gdbm' '--with-db3' '--with-inifile' '--with-flatfile' '--enable-dio' '--enable-ftp' '--with-gd' '--enable-gd-native-ttf' '--with-jpeg-dir=/usr' '--with-png' '--with-gettext=shared,/usr' '--with-gmp=shared' '--with-mbstring' '--with-mime-magic' '--with-mysql=shared,/usr' '--without-mysqli' '--with-pspell=shared,/usr' '--enable-shmop' '--enable-soap' '--enable-sockets' '--with-regex=php' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-wddx' '--enable-xml' '--with-xml=shared,/usr' '--with-xsl=/usr' '--enable-yp' '--with-pear' '--enable-inline-optimization' '--enable-memory-limit' '--enable-zend-multibyte' '--with-tsrm-pthreads' '--enable-shared' '--disable-static' '--disable-debug' '--with-sybase-ct=/usr/local/freetds'
Notice that I am using the FreeTDS package to interface with my sybase server. I can connect with the standard php syntax but I get errors sometimes when using the PEAR::DB package. The following scripts are simple test scripts to demonstrate my problem
Native PHP functions (works fine):
<?php
$dbh = sybase_connect( 'htfr', 'dbo', '********' );
$sql = "SELECT user_id ";
$sql .= "FROM dbo.pc_user_def ";
$q = sybase_query($sql);
var_dump(sybase_fetch_array($q));
sybase_close($dbh);
?>
PEAR::DB connection and query (also works fine):
<?php
require_once( 'DB.php');
$dbhl = DB::connect('sybase://dbo:********@htfr/htfr' );
$sql = "SELECT user_id ";
$sql .= "FROM dbo.pc_user_def ";
$q = $dbhl->query($sql);
print_r( $q->fetchrow() );
$dbhl->disconnect();
?>
Sorry I can't give you a gdb backtrace, but the segmentation fault doesn't happen from the command line. If I am missing something, I will be more than happy to give you more information.
Reproduce code:
---------------
<?php
require_once( 'DB.php');
$dbhl = DB::connect('sybase://dbo:************@htfr/htfr' );
$sql = "SELECT user_id ";
$sql .= "FROM dbo.pc_user_def ";
$q = $dbhl->getAll($sql);
print_r( $q );
$dbhl->disconnect();
?>
Expected result:
----------------
Array
(
[0] => Array
(
[0] => Lyndsey
)
[1] => Array
(
[0] => Jennifer
)
[2] => Array
(
[0] => pcadmin
)
[3] => Array
(
[0] => Cindy
)
)
Actual result:
--------------
It depends on how I call the script. If I call it from the command line, I get this:
rsyring@gateway:~/public_html$ php -c /etc/apache/php.ini test.php
sybase_connect, htfr, dbo, sql<br />
Notice: Undefined property: num_rows in /usr/lib/php/DB/sybase.php on line 378
Array
(
[0] => Array
(
[0] => Lyndsey
)
[1] => Array
(
[0] => Jennifer
)
[2] => Array
(
[0] => pcadmin
)
[3] => Array
(
[0] => Cindy
)
)
If I call it from a browser I get nothing because it is causing a segmentation fault (as shown in /var/log/apache/error_log):
[Mon May 24 15:51:10 2004] [notice] child pid 9275 exit signal Segmentation fault (11)
Comments
[2004-05-25 16:55 UTC] randys at barnes-homes dot com
Sorry, forgot pear versions:
root@gateway:/usr/libexec# pear list
Installed packages:
===================
Package Version State
DB 1.6.2 stable
PEAR 1.3.1 stable
[2004-05-25 17:09 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!