I have a site that is multilingual, Chinese and English.
I installed Event Gallery and made a menu item to the event categories and placed it in my English Main Menu.
THis menu item works as expected, however when I create another Menu item and place it in the Main Chinese menu. I get the following page not found error.
I am not sure how to resolve this.
1054
Unknown column 'i.language' in 'on clause' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM an2kf_categories as c LEFT JOIN (SELECT cat.id as id FROM an2kf_categories AS cat JOIN an2kf_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_eventgallery' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `an2kf_eventgallery_folder` AS i ON i.`catid` = c.id AND i.published = 1 AND (i.language = '*' OR i.language = 'zh-CN') WHERE (c.extension='com_eventgallery' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
I installed Event Gallery and made a menu item to the event categories and placed it in my English Main Menu.
THis menu item works as expected, however when I create another Menu item and place it in the Main Chinese menu. I get the following page not found error.
I am not sure how to resolve this.
1054
Unknown column 'i.language' in 'on clause' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM an2kf_categories as c LEFT JOIN (SELECT cat.id as id FROM an2kf_categories AS cat JOIN an2kf_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_eventgallery' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `an2kf_eventgallery_folder` AS i ON i.`catid` = c.id AND i.published = 1 AND (i.language = '*' OR i.language = 'zh-CN') WHERE (c.extension='com_eventgallery' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
