Thanks Grant , never thought it would be that easy, yeah the table names are plural but that's also good to know and might help someone else =)
On Dec 19, 11:07 pm, Grant Cox <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
