I am receiving the following error and am unsure how to proceed to fix this after upgrading from 2.8.1 to 2.9.2. My pages were blank when I clicked on them from the nav so I went to sync them from the template manager and when I refreshed one of the pages I got this error.
Error Number: 1054
Unknown column 'order' in 'order clause'
SELECT `route_parsed`, `template_name`, `group_name` FROM (`exp_templates`) JOIN `exp_template_routes` ON `exp_templates`.`template_id` = `exp_template_routes`.`template_id` JOIN `exp_template_groups` ON `exp_templates`.`group_id` = `exp_template_groups`.`group_id` WHERE `route_parsed` is not null AND `exp_templates`.`site_id` = '1' ORDER BY `order`, `group_name`, `template_name` ASC
Filename: libraries/Template_router.php
Line Number: 83