ID: 20294 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: DBM/DBA related Operating System: Solaris 2.5.1 PHP Version: 4.2.2 New Comment:
Silly me, fancy using an initial key of zero (0). This is indistinguishable from the FALSE value (a real TRAP for new players like me !!!). Changing the bounds of the variable "X" ensured that it read back the key / value pairs correctly. Bogus !!! Previous Comments: ------------------------------------------------------------------------ [2002-11-06 22:04:10] [EMAIL PROTECTED] Here is some sample source: <? // ** Write to database ** $dbh = dba_open("/tmp/test.db3","c","db3"); for($x=0;$x<500;$x++) { $key = strval($x); $value = "test" . $key; $res = dba_insert($key,$value,$dbh); // Debug if(!$res) echo "Failed to add rec $x<br>"; } dba_close($dbh); echo "Done adding<br>"; // ** Read back ** echo "Read back<br>"; $dbh = dba_open("/tmp/test.db3","r","db3"); if ($dbh == false) { echo "Database failed to open<BR>"; } $key = dba_firstkey($dbh); if ($key == false) { echo "Unable to use dba_firstkey to find initial key<BR>"; } echo "First key is $key<BR>"; $x=0; while($key != false) { $value = dba_fetch($key,$dbh); echo "$key,$value<br>"; $key = dba_nextkey($dbh); $x++; } dba_close($dbh); echo "Finished ! ($x records read back)<br>"; ?> Berkeley-DB is version 3.3.11 C Compiler is GNU C 2.95.3 Apache HTTPD is V2.0.40 PHP configured by './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-db3=/usr/local/BerkeleyDB.3.3' Basically, it's writing 500 records to the DB3 file (I can cat it and see the resultant output) and then trying to read them back. Not one record is read back because db_firstkey returns FALSE. Help appreciated Jason ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20294&edit=1