Megamenu broken after update

[bjarke]

After an update of magento to 1.9.2.3 we get the error below on the “Menu items Manager” admin page.

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘CONCAT( REPEAT( “— “, (COUNT(parent.depth) – 1) ) , main_table.title)’ in ‘field list’, query was: SELECT main_table.*, mgroup.title AS group_name, CONCAT( REPEAT( "--- ", (COUNT(parent.depth) - 1) ) , main_table.title) AS name FROM sns_menu_items AS main_table
INNER JOIN sns_menu_groups AS mgroup ON mgroup.id = main_table.group_id
CROSS JOIN sns_menu_items AS parent WHERE (main_table.lft BETWEEN parent.lft AND parent.rgt) AND (parent.group_id = main_table.group_id) GROUP BY main_table.id ORDER BY main_table.group_id ASC, main_table.lft ASC, id ASC LIMIT 20

[Author]

Posts