ecshop 出错了 求大侠们解决

2016-07-07 15:01 来源：www.chinab4c.com 作者：ecshop专家

我在模版里加入 从服务器下载下来的模版放到模版里刷新页面去前台看效果 出现MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `ecshop2`.`ecs_ad` AS a LEFT JOIN `ecshop2`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND start_time <= '1306743310' AND end_time >= '1306743310' AND a.position_id = '5' ORDER BY a.vieworder ASC LIMIT 3 ) [2] => Array ( [error] => Unknown column 'a.vieworder' in 'order clause' ) [3] => Array ( [errno] => 1054 ) ) 这个错误，这是什么错误，需要改哪，说具体点我刚接触二次开发

回答：
没有vieworder字段。数据库结构有问题

这个问题要怎么解决呀，说具体点好吗谢谢呀