In your Event model, have var $primaryKey = 'event_id'; Now you weren't clear about the table name, is it singular or plural? If it is singular (e.g. not matching the convention), then also add var $useTable = 'event';
On Dec 20, 12:01 pm, Fabian <[EMAIL PROTECTED]> wrote: > Hi I'm trying to insert data to a table that doesn't exactly follows > cakes conventions. The table name is Events > and instead of having and id , it has the name event_id. Is there a > way to change this on cake so it looks for the singular table name and > then append id to it? > > The weird thing is that I get and error but at the end it inserts the > records correctly. > > This is the error: > > Query: SELECT COUNT(id) AS count FROM `events` WHERE `id` = > '2007-12-3' > Warning: SQL Error: 1054: Unknown column 'id' in 'field list' in C: > \Program Files\xampp\htdocs\hawk\cake\libs\model\datasources > \dbo_source.php on line 440 > > So i was wondering if I could change a variable or something so it > looks for a different id name. > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
