Looks like Cricket knows what the deal is. I suggested the custom join because I messed one up once and it ended up looking for a column named 'right'. 8-)
On Mon, Jun 7, 2010 at 3:30 PM, cricket <[email protected]> wrote: > On Jun 7, 3:20 pm, Ed Propsner <[email protected]> wrote: > > Are you using a custom Join statement in your query, particularly a RIGHT > > JOIN? > > > > On Mon, Jun 7, 2010 at 2:34 PM, Roland Pish <[email protected]> > wrote: > > > Hello. > > > I was creating an "add" form for a model called Practitioner. > > > Everything seems to work fine, after submitting the form changes are > > > saved successfully in Practitioner table and in every table related to > > > Practitioner model, but a weird error is showing up that's claiming > > > for a "rght" field in my Practitioner model, and I don't know what > > > this "rght" field stands for and it isn't in any of my tables. > > > Any suggestions are greatly appreciated. > > > > > This is the error I get: > > > > > Warning (512): SQL Error: 1054: Unknown column 'Practitioner.rght' in > > > 'field list' [CORE/cake/libs/model/datasources/dbo_source.php, line > > > 666] > > It looks to me like you have $actsAs = array('Tree') in your model. > The "rght" and "lft" column names are used for the right & left fields > when using MPTT ordering. I imagine that TreeBehavior is attempting to > order your records but the table doesn't have those columns. > > http://www.ad7six.com/entries/view/56/Working-with-Tree-data-%28MPTT%29 > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > 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]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
