Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5

Bug #5931 update fails when having multible column primary key
Submitted: 2005-11-10 20:47 UTC
From: nikolas dot hagelstein at googlemail dot com Assigned:
Status: No Feedback Package: DB_DataObject
PHP Version: 4.4.1 OS: Linux
Roadmaps: (Not assigned)    
Subscription  


 [2005-11-10 20:47 UTC] nikolas dot hagelstein at googlemail dot com
Description: ------------ Having a multible column primary key results in an update where clause like "where id1='xyz'" where it should be "where id1='xyz' and id2='abc'"

Comments

 [2005-11-16 05:26 UTC] alan_k
running the test applicaton (test 91) from http://cvs.php.net/co.php/pear/DB_DataObject/tests/simple.phpt It successfully generated these two queries. INSERT INTO page_module (page_id , module_id , position ) VALUES ( 1 , 1 , 'top' ) UPDATE page_module SET place = 0 , title = '' , position = 'bottom' WHERE page_module.page_id = 1 AND page_module.module_id = 1 stored db structure looks like this. [1] => Array ( [table] => Array ( [page_id] => 129 [module_id] => 129 [place] => 129 [title] => 130 [position] => 130 ) [keys] => Array ( [page_id] => K [module_id] => K ) can you try CVS, and regenerate your ini file.