ID: 47223 Updated by: fel...@php.net Reported By: Nicolas dot breuer at belcenter dot be -Status: Open +Status: Feedback Bug Type: dBase related Operating System: Linux PHP Version: 5.2.8 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ Previous Comments: ------------------------------------------------------------------------ [2009-01-27 10:32:57] Nicolas dot breuer at belcenter dot be Description: ------------ Hello, This bug is present in the PHP source code since the release of PHP 5.2.4. We worked with 5.2.3 because we can put a newer release in prod. Today i tried to install the 5.2.8 and same problem so i publish now a bug report. ----- I add one or more record to a DBase file. The header was already on the server Problem is when i opened the file, the columns were truncated. Header of dbf file (empty of course) Array ( [0] => Array ( [name] => NUM [type] => number [length] => 8 [precision] => 0 [format] => %8s [offset] => 1 ) [1] => Array ( [name] => JNL [type] => character [length] => 10 [precision] => 0 [format] => %-10s [offset] => 9 ) [2] => Array ( [name] => NUMBER [type] => number [length] => 10 [precision] => 0 [format] => %10s [offset] => 19 ) [3] => Array ( [name] => DATE [type] => date [length] => 8 [precision] => 0 [format] => %8s [offset] => 29 ) [4] => Array ( [name] => THIRDGROUP [type] => character [length] => 10 [precision] => 0 [format] => %-10s [offset] => 37 ) [5] => Array ( [name] => ARTID [type] => character [length] => 20 [precision] => 0 [format] => %-20s [offset] => 47 ) [6] => Array ( [name] => QTY [type] => number [length] => 10 [precision] => 0 [format] => %10s [offset] => 67 ) [7] => Array ( [name] => UNITPRICE [type] => number [length] => 12 [precision] => 2 [format] => %12s [offset] => 77 ) [8] => Array ( [name] => VATID [type] => character [length] => 10 [precision] => 0 [format] => %-10s [offset] => 89 ) [9] => Array ( [name] => VATPC [type] => character [length] => 10 [precision] => 0 [format] => %-10s [offset] => 99 ) [10] => Array ( [name] => DISCOUNT [type] => character [length] => 5 [precision] => 0 [format] => %-5s [offset] => 109 ) [11] => Array ( [name] => ARTNAME [type] => character [length] => 60 [precision] => 0 [format] => %-60s [offset] => 114 ) [12] => Array ( [name] => D_PMTAUTO [type] => character [length] => 1 [precision] => 0 [format] => %-1s [offset] => 174 ) [13] => Array ( [name] => DATEPAY [type] => date [length] => 8 [precision] => 0 [format] => %8s [offset] => 175 ) [14] => Array ( [name] => YOURREF [type] => character [length] => 10 [precision] => 0 [format] => %-10s [offset] => 183 ) Reproduce code: --------------- $dbname = "temp/test.dbf"; $dbh = dbase_open($dbname, 2) or die("Error! Could not open dbase database file '$dbname'."); $reg=array("1","FAC","20090150","01/01/2009","TEST INPUT","TEST ARTI ID","1","50","0","0","0","Test input char","","-","-"); dbase_add_record($dbh,$reg); $reg=array("1","FAC","20090150","01/01/2009","TEST INPUT","TEST ARTI ID","1","50","0","0","0","Test input char","","-","-"); dbase_add_record($dbh,$reg); Expected result: ---------------- Each value correctly in each column. Actual result: -------------- NUM JNL NUMBER DATE THIRDGROUP ARTID QTY UNITPRICE VATID VATPC DISCOUNT ARTNAME D_PMTAUTO DATEPAY YOURREF 1 FAC 20090150 01/01/20TE ST INPUTTEST ARTI ID 1 500 0 0 Test input char 1 FAC 20090150 01/01/20TE ST INPUTTEST ARTI ID 1 500 0 0 Test input char Date column was empty and the real date (truncated) was put on THIRDGROUP column. Thirdgroup value was put on ArtID column, etc. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47223&edit=1
