I had the same problem, and after hours of searching, I've come across some luck. Here is what I did to get it to work:
I don't quiet understand why, but this seems to fix the issue with 1.2.1.8004. I just hope there aren't any side-effects. I made $reset (second parameter for bindModel) to false, and it worked. Instead of <code>$this->Book->bindModel(array('hasOne' => array ('BooksCategory')));</code> I used <code>$this->Book->bindModel(array('hasOne' => array ('BooksCategory')),false);</code> The API says 'If $reset is false, association will not be reset to the originals defined in the model' and I don't quiet understand the repercussions of that. If I shouldn't be doing this, please do let me know. :-) Hope that helps, Palaniappan. On Jan 29, 5:31 am, aron <acaldw...@gmail.com> wrote: > Following this tutorial > > http://cakebaker.42dh.com/2007/10/17/pagination-of-data-from-a-habtm-... > > we had this working great in rc4 but when we upgraded the final > release cake seems to ignore the relationships and throws the > following error: > > Unknown column ‘Listing.city_id’ in ‘where clause’ > > the sql statement no longer does a join, when we replace the cake > folder with the rc4 cake folder it works fine again. Any insight from > any cake gurus? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---