Question

ecshop 订单信息 打印快递单出错,如何解决

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT region_id, region_name FROM `shop2`.`ecs_region` WHERE region_id IN () ) [2] => Array ( [error] => 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 ')' at line 1 ) [3] => Array ( [errno] => 1064 ) )

Answer 1

mysql出错了，建议重新安装ecshop或者恢复mysql数据试试看，也可以让空间商看看是不是空间出问题了。ecs_region应该是这个表有问题，建议看看。

Answer 2

SELECT region_id, region_name FROM `shop2`.`ecs_region` WHERE region_id IN ( 这个sql有问题，你输出看看啊。