> (a) If I go to /users/add, I get the following SQL error: 1064: You > have an error in your SQL syntax; ... near 'bid_session_registrations` > AS `BidSessionRegistration` WHERE 1 = 1' at line 1 [CORE\cake\libs > \model\datasources\dbo_source.php, line 512]. Query: SELECT > `BidSessionRegistration`.`user_id`, BidSessionRegistration`. FROM > `bid_session_registrations` AS `BidSessionRegistration` WHERE 1 = 1. > Note the missing field name before 'FROM'. This table has PK > (bid_session_id, user_id). If I remove that and add an id field as PK, > things start working. However, since I am not interested in using this > join model directly, I shouldn't have to do this ... as far as I > understand from the manual and other cake blogs/tutorials.
What you're doing in general sounds right to me. If that's a straight copy-and-paste, note that you're also missing a backtick just before the table name that has a missing column. It sounds like CakePHP's getting somewhat confused about the table structure. Check for any typos or anything slightly askew in the models. Whenever I've had similar errors myself, it's usually something subtle but not particularly complex. If that doesn't help, maybe pasting the models' classes here might shed some light on the problem. Hope that helps, Zoe. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
