I'll make them both indexed and remove the unique index on both fields and experiment with that.
thanks On Jan 5, 5:32 pm, WebbedIT <[email protected]> wrote: > product_id cannot be the primary key alone whilst it has multiple keys > with the same value. Your primary key is more likely product_id AND > catalgoue_id [sic]. > > As a rule I add id fields to my join tables to be used as the primary > key, but I would imagine that in the absence of this cake should > update 'WHERE product_id = 123 AND catalgoue_id = 2' > > Is this not the case?´ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
