PHP 4.0 Bug #4927 Updated: Displaying a sybase table freezes the browser or displays only a part of table

ID: 4927 Updated by: sniper Reported By: marc_bigler@yahoo.com Status: Closed Bug Type: Sybase (dblib) related Assigned To: Comments: No feedback from user. Closed. --Jani Previous Comments: [2000-08-20 03:47:40] sniper@php.net Does this problem still persist with more recent version of php (from CVS or http://snaps.php.net) ?? --Jani --------------------------------------------------------------------------- [2000-06-09 13:25:47] marc_bigler@yahoo.com Here is the script: <?php /* Connect to the DB */ sybase_connect("winnie", "webuser", "apache"); /* Select a DB */ sybase_select_db("mportfolio"); /* Perform a SQL query to DB */ $result = sybase_query("SELECT * FROM currency"); /* Get the number of rows in result */ $nbRows = sybase_num_rows($result); print("Number of rows: $nbRows <BR>"); /* Get the number of fields in result */ $nbFields = sybase_num_fields($result); print("<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="600" BGCOLOR="#000000">n"); print("<TR VALIGN="bottom" bgcolor="#9999CC">"); print(" <TH>"); print("ID"); print(" </TH>"); print(" <TH>"); print("Code"); print(" </TH>"); print(" <TH>"); print("Country"); print(" </TH>"); print("</TR>"); while ($row = sybase_fetch_row($result)) { print("<TR VALIGN="baseline" BGCOLOR="#CCCCCC">n"); for ($index = 0; $index < $nbFields; $index++) { print("<TD>"); print($row[$index]); print("</TD>n"); } print("</TR>n"); } print("</TABLE>n"); /* Close the connection to the DB */ sybase_close(); ?> OS: RedHat Linux 6.2 PHP version: 4.0.0 (FINAL) for UNIX Apache version: 1.3.12 for UNIX Sybase version: 11.9.2 for Linux Here is the compile line of PHP (for modules): ./configure --with-apxs=/opt/apache/bin/apxs --with-config-file-path=/opt/apache --with-sybase=/opt/sybase-11.9.2 I tryed to compile the PHP4 module as a DSO and as a static module, the result is the same. My PHP.INI file is exactly the same as the php.ini-dist that is available with the PHP4.0.0 archive. I didn't modify it. When load the script that you can see up there it adds this to the error log file of Apache (error_log): sybase.c(898) : Freeing 0x0812EE44 (5 bytes), script=/opt/apache/htdocs/syb.php zend_variables.c(126) : Actual location (location was relayed) Last leak repeated 53 times In case you would need it here is my sybase table that i access in the script upper: /* ============================================================ */ /* Database name: mportfolio */ /* DBMS name: Sybase AS Enterprise 11.5-11.9 */ /* Created on: 09.06.2000 13:20 */ /* ============================================================ */ /* ============================================================ */ /* Table: currency */ /* ============================================================ */ create table currency ( currency_id numeric identity, currency_name char(3) not null, currency_country varchar(30) not null, constraint pk_currency primary key (currency_id) ) go If you need any more informations please feel free to ask me. I thank you in advance for your support & help. Regards Marc Bigler (marc_bigler@yahoo.com) --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=4927