Question

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 `ecshop1`.`ecs_ad` AS a LEFT JOIN `ecshop1`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND start_time <= '1477780641' AND end_time >= '1477780641' AND a.position_id = '$this->_var['ads_id']' ORDER BY rnd LIMIT $this->_var['ads_num'] ) [2] => Array ( [error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ads_id']' ORDER BY rnd LIMIT $this->_var['ads_num']' at line 1 ) [3] => Array ( [errno] => 1064 ) )

Answer 1

检查一下data/config.php文件内容，然后配置一下。

Answer 2

注意单双引号的使用，错误很明显啊

Answer 3

a.position_id = '$this->_var['ads_id']' ORDER BY rnd

里的这一段
'$this->_var['ads_id']'
的单双引号使用的有问题