Question

ECshop系统后台销售提成出现下面错误提示是怎么回事？

MySQL server error report:Array
(
[0] => Array
(
[message] => MySQL Query Error
)

[1] => Array
(
[sql] => SELECT o.order_id, o.order_sn, o.add_time,
o.order_status, o.shipping_status, o.order_amount,
o.money_paid,o.pay_status, o.consignee, o.address, o.email, o.tel,
o.extension_code, o.extension_id, ( o.goods_amount + o.tax +
o.shipping_fee + o.insure_fee + o.pay_fee + o.pack_fee + o.card_fee ) AS
total_fee, IFNULL(u.user_name, '匿名用户') AS buyer FROM
`songbaoj_shop`.`ecs_order_info` AS o LEFT JOIN
`songbaoj_shop`.`ecs_users` AS u ON u.user_id=o.user_id WHERE 1 and
o.pay_status=2 and u.user_rank= ORDER BY add_time DESC LIMIT 0,15
)

[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 'ORDER BY add_time DESC LIMIT 0,15' at line 1
)

[3] => Array
(
[errno] => 1064
)

)

Answer 1

WHERE 1 and
o.pay_status=2 and u.user_rank=这里有问题 ORDER BY add_time DESC LIMIT 0,15
)

应该是用户等级之类的为空，查看下这个订单用户等级 级别 用户组之类的设置一下就可以了