| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.11.2 |
| Bug #5931 | update fails when having multible column primary key | ||
|---|---|---|---|
| Submitted: | 2005-11-10 15:47 UTC | Modified: | 2006-12-03 06:32 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) | ||
[2005-11-10 15: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 00: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.