You will need to use mysql query logging or the doctrine connection profiler to view the sql it executes.
- Jon On Mon, Sep 29, 2008 at 12:32 PM, Bertrand Zuchuat <[EMAIL PROTECTED]>wrote: > Hi Jon, > I don't show SQL because i have an error before. > > [Doctrine_Connection_Mysql_Exception]SQLSTATE[42S22]: Column not found: > 1054 Unknown column 'g4.gallery_id' in 'group statement' > > My schema: > --- > Gallery: > tableName: gallery > actAs: > Timestampable: ~ > I18n: > fields: [title, description] > className: %CLASS%_i18n > actAs: > Sluggable: > fields: [title] > length: 120 > columns: > id: > type: integer(3) > primary: true > autoincrement: true > created_at: > type: timestamp > updated_at: > type: timestamp > title: > type: string(120) > notnull: true > description: > type: string(4000) > picture: > type: string(40) > is_enabled: > type: boolean > default: 0 > > GalleryPicture: > tableName: gallery_picture > actAs: > Timestampable: ~ > I18n: > fields: [title, description] > className: %CLASS%_i18n > columns: > id: > type: integer(3) > primary: true > autoincrement: true > created_at: > type: timestamp > updated_at: > type: timestamp > gallery_id: > type: integer(3) > notnull: true > title: > type: string(120) > notnull: true > description: > type: string(4000) > picture: > type: string(40) > notnull: true > relations: > Pictures: > class: Gallery > onDelete: CASCADE > > If i execute the same code with Doctrine_Query, this is OK. > > Thanks > > Bertrand > > Le 29 sept. 08 à 18:34, Jonathan Wage a écrit : > > Does that column exist on the GalleryPicture model/table? > > Can you show the SQL it executes and your model/schema definitions? > > > > > > -- Jonathan H. Wage Open Source Software Developer & Evangelist http://www.jwage.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---