I found an issue when deleting a database entry where my related model has conditions using the related model's name, and does not get aliased correctly when attempting to find and delete the children.
For example, blogs have many posts:
'post' => array(
'key_from' => 'id',
'key_to' => 'blog_id',
'conditions' => array(
'order_by' => array('post.display_order'),
)
),
I end up with an "unknown column" error, where the SQL does not replace the alias name in the condition part (order_by), so in the above example it would look like "unknown column 'post.display_order' in order clause".
Note: In my working version, 'post' has a different table name defined in the protected static $_table_name variable.
My models are very complex so I didn't want to put it all here, but if someone needs a better explanation to what I'm finding I can provide a full example.
Donate
