#31990 [Bgs->Csd]: dblib.c:303: buffer_add_row: Assertion `row_size <= buf->element_size' failed

2005-04-18 Thread tim at datad dot com
 ID:   31990
 User updated by:  tim at datad dot com
 Reported By:  tim at datad dot com
-Status:   Bogus
+Status:   Closed
 Bug Type: Sybase (dblib) related
 Operating System: SuSE 9.2 Pro 2.6.8-24.11-default
 PHP Version:  4CVS, 5CVS (2005-02-16)
 New Comment:

Thanks dude.  I figured this out what TWO MONTHS AGO.

:-)

What I was trying to figure out is if I can live without FreeTDS and
simply use Sybases' connection library.  It's too confusing which or
what to use, so I went back to FreeTDS for what I **can** do, and wrote
a shell wrapper for stored procs that return more than one result
set--which is quite a few standard "supplied" stored procs that come
with Sybase, like sp_help, etc.


Thanks anyway!


Previous Comments:


[2005-04-18 15:17:05] [EMAIL PROTECTED]

Eh..how do you expect it to work if you uninstall it??
It's a freetds bug anyway -> bogus.


----

[2005-02-16 22:36:18] tim at datad dot com

I believe this is a FreeTDS problem. 

I uninstalled FreeTDS, but now I can no longer connect at all.

Instead I get:

PHP Warning:  sybase_select_db(): Sybase:  A link to the server could
not be established in /srv/www/sybasedba/sybasedba.run_sp.php on line
17
PHP Warning:  sybase_query(): 0 is not a Sybase link index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 21
PHP Warning:  sybase_num_fields(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 23
PHP Warning:  sybase_num_rows(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 24
PHP Warning:  sybase_fetch_row(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 29
PHP Warning:  sybase_close(): 0 is not a Sybase link index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 62



What do I do to connect PHP to Sybase if I do not use FreeTDS?

----

[2005-02-16 05:16:00] tim at datad dot com

OK, so...

I downloaded and installed the latest PHP ( 4.3.11-dev ) and it still
exhibits the same behavior.

php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted


Incidentally, you cannot configure 
--with-sybase
--with-sybase-ct

it has to be one or the other.  When I configured --with-ct I got
segfaults, and nothing worked at all.  I could not connect or anything
with either through a browser or php-cli.

I used --with-sybase-ct=/opt/sybase/OCS-12_5


So I've configured for --with-sybase=/opt/sybase and now what worked
before is working and it is producing the same error as before when I
try to use a stored procedure.

My latest configure:

./configure \
--enable-shared \
--with-apache2=../httpd-2.0.53 \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase=/opt/sybase \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt



[2005-02-16 03:18:29] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

And why don't you use --with-sybase-ct ?? AFAIK, it's better supported
than the old sybase-db..


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

[2005-02-16 02:25:34] tim at datad dot com

Description:

I get the following error when I run any stored procedure.  The script
works fine if you use SQL statements, but sp's die.



php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted

My PHP Configuration:

./configure \
--with-apache2=../httpd-2.0.53 \
--enable-track-vars \
--enable-magic-quotes \
--enable-discard-path \
--enable-force-cgi-redirect \
--enable-shared \
--enable-sigchild \
--enable-sockets=shared \
--enable-mailparse \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase \
--with-tdsver=7.0 \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt


Reproduce code:
---
name]";
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
print "\n" ;
}

++$row_cnt ;
$field_cnt = 0 ;
while(list($k, $v) = each($row))
  

#31990 [NEW]: dblib.c:303: buffer_add_row: Assertion `row_size <= buf->element_size' failed

2005-02-15 Thread tim at datad dot com
From: tim at datad dot com
Operating system: SuSE 9.2 Pro 2.6.8-24.11-default
PHP version:  4.3.10
PHP Bug Type: Sybase (dblib) related
Bug description:  dblib.c:303: buffer_add_row: Assertion `row_size <= 
buf->element_size' failed

Description:

I get the following error when I run any stored procedure.  The script
works fine if you use SQL statements, but sp's die.



php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted

My PHP Configuration:

./configure \
--with-apache2=../httpd-2.0.53 \
--enable-track-vars \
--enable-magic-quotes \
--enable-discard-path \
--enable-force-cgi-redirect \
--enable-shared \
--enable-sigchild \
--enable-sockets=shared \
--enable-mailparse \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase \
--with-tdsver=7.0 \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt


Reproduce code:
---
name]";
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
print "\n" ;
}

++$row_cnt ;
$field_cnt = 0 ;
while(list($k, $v) = each($row))
{
++$field_cnt;
$datum = NULL ;
$datum = rtrim ( $v ) ;
print "[$datum]" ;
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
}
sybase_close ( $db ) ;

?>

Expected result:

I expect it to work!

I should see the output of the stored procedure or at least some kind of
explanation as to why it's failing.

Actual result:
--
the bug.

-- 
Edit bug report at http://bugs.php.net/?id=31990&edit=1
-- 
Try a CVS snapshot (php4):   http://bugs.php.net/fix.php?id=31990&r=trysnapshot4
Try a CVS snapshot (php5.0): 
http://bugs.php.net/fix.php?id=31990&r=trysnapshot50
Try a CVS snapshot (php5.1): 
http://bugs.php.net/fix.php?id=31990&r=trysnapshot51
Fixed in CVS:http://bugs.php.net/fix.php?id=31990&r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=31990&r=alreadyfixed
Need backtrace:  http://bugs.php.net/fix.php?id=31990&r=needtrace
Need Reproduce Script:   http://bugs.php.net/fix.php?id=31990&r=needscript
Try newer version:   http://bugs.php.net/fix.php?id=31990&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31990&r=support
Expected behavior:   http://bugs.php.net/fix.php?id=31990&r=notwrong
Not enough info: 
http://bugs.php.net/fix.php?id=31990&r=notenoughinfo
Submitted twice: 
http://bugs.php.net/fix.php?id=31990&r=submittedtwice
register_globals:http://bugs.php.net/fix.php?id=31990&r=globals
PHP 3 support discontinued:  http://bugs.php.net/fix.php?id=31990&r=php3
Daylight Savings:http://bugs.php.net/fix.php?id=31990&r=dst
IIS Stability:   http://bugs.php.net/fix.php?id=31990&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31990&r=gnused
Floating point limitations:  http://bugs.php.net/fix.php?id=31990&r=float
No Zend Extensions:  http://bugs.php.net/fix.php?id=31990&r=nozend
MySQL Configuration Error:   http://bugs.php.net/fix.php?id=31990&r=mysqlcfg


#31990 [Fbk->Opn]: dblib.c:303: buffer_add_row: Assertion `row_size <= buf->element_size' failed

2005-02-15 Thread tim at datad dot com
 ID:   31990
 User updated by:  tim at datad dot com
 Reported By:  tim at datad dot com
-Status:   Feedback
+Status:   Open
 Bug Type: Sybase (dblib) related
 Operating System: SuSE 9.2 Pro 2.6.8-24.11-default
 PHP Version:  4.3.10
 New Comment:

OK, so...

I downloaded and installed the latest PHP ( 4.3.11-dev ) and it still
exhibits the same behavior.

php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted


Incidentally, you cannot configure 
--with-sybase
--with-sybase-ct

it has to be one or the other.  When I configured --with-ct I got
segfaults, and nothing worked at all.  I could not connect or anything
with either through a browser or php-cli.

I used --with-sybase-ct=/opt/sybase/OCS-12_5


So I've configured for --with-sybase=/opt/sybase and now what worked
before is working and it is producing the same error as before when I
try to use a stored procedure.

My latest configure:

./configure \
--enable-shared \
--with-apache2=../httpd-2.0.53 \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase=/opt/sybase \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt


Previous Comments:


[2005-02-16 03:18:29] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

And why don't you use --with-sybase-ct ?? AFAIK, it's better supported
than the old sybase-db..


----

[2005-02-16 02:25:34] tim at datad dot com

Description:

I get the following error when I run any stored procedure.  The script
works fine if you use SQL statements, but sp's die.



php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted

My PHP Configuration:

./configure \
--with-apache2=../httpd-2.0.53 \
--enable-track-vars \
--enable-magic-quotes \
--enable-discard-path \
--enable-force-cgi-redirect \
--enable-shared \
--enable-sigchild \
--enable-sockets=shared \
--enable-mailparse \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase \
--with-tdsver=7.0 \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt


Reproduce code:
---
name]";
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
print "\n" ;
}

++$row_cnt ;
$field_cnt = 0 ;
while(list($k, $v) = each($row))
{
++$field_cnt;
$datum = NULL ;
$datum = rtrim ( $v ) ;
print "[$datum]" ;
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
}
sybase_close ( $db ) ;

?>

Expected result:

I expect it to work!

I should see the output of the stored procedure or at least some kind
of explanation as to why it's failing.

Actual result:
--
the bug.





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


#31990 [Opn]: dblib.c:303: buffer_add_row: Assertion `row_size <= buf->element_size' failed

2005-02-16 Thread tim at datad dot com
 ID:   31990
 User updated by:  tim at datad dot com
 Reported By:  tim at datad dot com
 Status:   Open
 Bug Type: Sybase (dblib) related
 Operating System: SuSE 9.2 Pro 2.6.8-24.11-default
 PHP Version:  4CVS, 5CVS (2005-02-16)
 New Comment:

I believe this is a FreeTDS problem. 

I uninstalled FreeTDS, but now I can no longer connect at all.

Instead I get:

PHP Warning:  sybase_select_db(): Sybase:  A link to the server could
not be established in /srv/www/sybasedba/sybasedba.run_sp.php on line
17
PHP Warning:  sybase_query(): 0 is not a Sybase link index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 21
PHP Warning:  sybase_num_fields(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 23
PHP Warning:  sybase_num_rows(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 24
PHP Warning:  sybase_fetch_row(): 0 is not a Sybase result index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 29
PHP Warning:  sybase_close(): 0 is not a Sybase link index in
/srv/www/sybasedba/sybasedba.run_sp.php on line 62



What do I do to connect PHP to Sybase if I do not use FreeTDS?


Previous Comments:


[2005-02-16 05:16:00] tim at datad dot com

OK, so...

I downloaded and installed the latest PHP ( 4.3.11-dev ) and it still
exhibits the same behavior.

php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted


Incidentally, you cannot configure 
--with-sybase
--with-sybase-ct

it has to be one or the other.  When I configured --with-ct I got
segfaults, and nothing worked at all.  I could not connect or anything
with either through a browser or php-cli.

I used --with-sybase-ct=/opt/sybase/OCS-12_5


So I've configured for --with-sybase=/opt/sybase and now what worked
before is working and it is producing the same error as before when I
try to use a stored procedure.

My latest configure:

./configure \
--enable-shared \
--with-apache2=../httpd-2.0.53 \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase=/opt/sybase \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt



[2005-02-16 03:18:29] [EMAIL PROTECTED]

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

And why don't you use --with-sybase-ct ?? AFAIK, it's better supported
than the old sybase-db..


----

[2005-02-16 02:25:34] tim at datad dot com

Description:

I get the following error when I run any stored procedure.  The script
works fine if you use SQL statements, but sp's die.



php: dblib.c:303: buffer_add_row: Assertion `row_size <=
buf->element_size' failed.
Aborted

My PHP Configuration:

./configure \
--with-apache2=../httpd-2.0.53 \
--enable-track-vars \
--enable-magic-quotes \
--enable-discard-path \
--enable-force-cgi-redirect \
--enable-shared \
--enable-sigchild \
--enable-sockets=shared \
--enable-mailparse \
--with-module=so \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-mysql \
--with-gnu-ld \
--with-zlib \
--with-sybase \
--with-tdsver=7.0 \
--with-unixODBC \
--with-dbase \
--with-openssl \
--with-gd \
--with-ttf \
--with-curl \
--with-mcrypt


Reproduce code:
---
name]";
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
print "\n" ;
}

++$row_cnt ;
$field_cnt = 0 ;
while(list($k, $v) = each($row))
{
++$field_cnt;
$datum = NULL ;
$datum = rtrim ( $v ) ;
print "[$datum]" ;
if ( $field_cnt == $syb_num_fields )
{
print "\n" ;
$field_cnt = 0 ;
}
}
}
sybase_close ( $db ) ;

?>

Expected result:

I expect it to work!

I should see the output of the stored procedure or at least some kind
of explanation as to why it's failing.

Actual result:
--
the bug.





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