im getting CDbException with the following message:
[sql]CDbCommand nie zdołał wykonać polecenia SQL: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group.id AS t1_c0, group.name AS t1_c1 FROM shop_products LEFT OUTER ’ at line 1[/sql]
What am i doing wrong here? Because in other controllers with different models i also used this kind of relations with success
Did you try the same SQL statement in phpmyadmin? I think group is a reserved word in MySQL and must be written as group. So this might be a little bug: table aliases should be surrounded by backticks.