ID: 45357
Comment by: radha_krishna_komal at yahoo dot com
Reported By: temmel at jcvi dot org
Status: Assigned
Bug Type: Sybase-ct (ctlib) related
Operating System: Centos 5 x86_64
PHP Version: 5.2.6
Assigned To: thekid
New Comment:
I have Some Store Procedure And If We Do not Open That Store
Procedure up to few time than it gives Wrong Result.And When We Open
That Store Procedure And Close Than it Gives me Right Result.
I want to tell You that I require the Recompile The Store Procedure
Automatically After few Days Without Open That because I have Somuch
Store Procedure That Take Much Time
Previous Comments:
------------------------------------------------------------------------
[2008-07-02 10:44:06] [EMAIL PROTECTED]
Assigned to maintainer.
------------------------------------------------------------------------
[2008-07-02 10:16:40] mul at rentapacs dot de
Had the same problem on SLES10 SP1 x86_64 running ASE Express Edition
15.0.2. The patch to ext/sybase_ct/config.m4 from Bug #35945 worked for
me except that library names needed an additional 'syb' prefix:
e.g. -lct -> -lsybct64
HTH ... Michael
------------------------------------------------------------------------
[2008-06-25 19:48:06] temmel at jcvi dot org
Description:
------------
I'm running into problems with php + sybase_ct under 64-bit Centos. I
get a sybase_select_db failure after successfully performing a
sybase_connect.
CentOS release 5 (Final)
Linux speedy 2.6.18-53.1.4.el5 #1 SMP Wed Nov 14 10:37:27 EST 2007
x86_64 x86_64 x86_64 GNU/Linux
SYBASE=/usr/local/packages/sybase
SYBASE_OCS=OCS-15_0
Using php-5.2-dev snap (php5.2-200806251230)...
Modified configure to use 64-bit libs:
LIBS="-lintl64 $LIBS"
SYBASE_CT_SHARED_LIBADD="-lct64 $SYBASE_CT_SHARED_LIBADD"
SYBASE_CT_LIBS="-L$SYBASE_CT_LIBDIR -lct64"
SYBASE_CT_SHARED_LIBADD="-lcs64 $SYBASE_CT_SHARED_LIBADD"
LIBS="-lcs64 $LIBS"
SYBASE_CT_SHARED_LIBADD="-lct64 $SYBASE_CT_SHARED_LIBADD"
LIBS="-lct64 $LIBS"
SYBASE_CT_SHARED_LIBADD="-lcomn64 $SYBASE_CT_SHARED_LIBADD"
LIBS="-lcomn64 $LIBS"
SYBASE_CT_SHARED_LIBADD="-lintl64 $SYBASE_CT_SHARED_LIBADD"
LIBS="-lintl64 $LIBS"
SYBASE_CT_LIBS="-L$SYBASE_CT_LIBDIR -lcs64 -lct64 -lcomn64
-lintl64"
SYBASE_CT_SHARED_LIBADD="-ltcl64 $SYBASE_CT_SHARED_LIBADD"
SYBASE_CT_SHARED_LIBADD="-lsybtcl64 $SYBASE_CT_SHARED_LIBADD"
LIBS="-lsybtcl64 $LIBS"
SYBASE_CT_SHARED_LIBADD="-linsck64 $SYBASE_CT_SHARED_LIBADD"
SYBASE_CT_SHARED_LIBADD="-linsck64 $SYBASE_CT_SHARED_LIBADD"
./configure --prefix=/opt/software/php-dev
--with-sybase-ct=/usr/local/packages/sybase
FAILED TEST SUMMARY
---------------------------------------------------------------------
Bug #16069 (ICONV transliteration failure)
[ext/iconv/tests/bug16069.phpt]
iconv stream filter [ext/iconv/tests/iconv_stream_filter.phpt]
Test array_slice() function : usage variations - Pass different data
types as $offset arg
[ext/standard/tests/array/array_slice_variation2.phpt]
Test array_slice() function : usage variations - Pass different data
types as $length arg
[ext/standard/tests/array/array_slice_variation3.phpt]
Test lstat() and stat() functions: usage variations - effects of
touch() on link [ext/standard/tests/file/lstat_stat_variation6.phpt]
Test lstat() and stat() functions: usage variations - writing data into
file [ext/standard/tests/file/lstat_stat_variation7.phpt]
Test setlocale() function : usage variations - setting system locale as
null [ext/standard/tests/strings/setlocale_variation4.phpt]
Test setlocale() function : usage variations - Setting system locale as
empty string [ext/standard/tests/strings/setlocale_variation5.phpt]
Sybase-CT bug #22403 (crash when executing a stored procedure without
parameters) [ext/sybase_ct/tests/bug22403.phpt]
Sybase-CT bug #26407 (Result set fetching broken around transactions)
[ext/sybase_ct/tests/bug26407.phpt]
Sybase-CT bug #27843 (notices when query is a stored procedure)
[ext/sybase_ct/tests/bug27843.phpt]
Sybase-CT bug #28354 (sybase_free_result crash)
[ext/sybase_ct/tests/bug28354.phpt]
Sybase-CT bug #29064 (Exact numeric/decimal/money datatypes lose
precision) [ext/sybase_ct/tests/bug29064.phpt]
Sybase-CT bug #30312 (sybase_unbuffered_query calls)
[ext/sybase_ct/tests/bug30312.phpt]
Sybase-CT bug #6339 (invalid Sybase-link resource)
[ext/sybase_ct/tests/bug6339.phpt]
Sybase-CT application name [ext/sybase_ct/tests/test_appname.phpt]
Sybase-CT connectivity [ext/sybase_ct/tests/test_connect.phpt]
Sybase-CT connection-based server message handler
[ext/sybase_ct/tests/test_connectionbased_msghandler.phpt]
Sybase-CT sybase_fetch_object
[ext/sybase_ct/tests/test_fetch_object.phpt]
Sybase-CT sybase_field_* functions
[ext/sybase_ct/tests/test_fields.phpt]
Sybase-CT select LONG_MAX / LONG_MIN
[ext/sybase_ct/tests/test_long.phpt]
Sybase-CT server message handler
[ext/sybase_ct/tests/test_msghandler.phpt]
Sybase-CT server message handler
[ext/sybase_ct/tests/test_msghandler_handled.phpt]
Sybase-CT query without storing
[ext/sybase_ct/tests/test_query_nostore.phpt]
Sybase-CT select and types [ext/sybase_ct/tests/test_types.phpt]
Sybase-CT unbuffered query
[ext/sybase_ct/tests/test_unbuffered_query.phpt]
Test script:
<?php
$con = sybase_connect("SYBIL", "access", "access") or die
("sybase_connect failure\n");
sybase_select_db("pfgrc_dev4") or die ("sybase_select_db failure\n");
$qry = sybase_query("select * from z_logins", $con);
echo sybase_result($qry, 1, 1);
sybase_close($con);
?>
Script results:
% /opt/software/php-dev/bin/php test.php
sybase_select_db failure
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=45357&edit=1
