登录即表示您同意并遵守 用户协议
错误出现的位置:/www/wwwroot/yidajian.net/cmspro/models/mysql.system.php559
错误原因:SQLSTATE[42000]: Syntax error or access violation: 1064 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 '-16 , 16' at line 1出现异常:
SELECT a.*,
cs.name as csname, /**类型名称**/
mt.sign, /**货币符号**/
it.name as iname, /**积分名称**/
it.ico as iico, /**积分图标**/
s.name as sname, /**店铺名称**/
ws.count as wscount, /**收藏量**/
(SELECT COUNT(1) FROM cp_shop_cart ct WHERE ct.sid=a.id) as ctcount, /**全站购物车量**/
(SELECT COUNT(1) FROM cp_shop_order od WHERE od.pid=a.id) as odcount /**商品订单数量**/
FROM cp_shop_content AS a
LEFT JOIN cp_money_type AS mt ON a.money=mt.alias /**资金类型**/
LEFT JOIN cp_integral_type AS it ON a.integral=it.id /**积分类型**/
LEFT JOIN cp_sys_wishlist AS ws ON a.id=ws.sid and ws.type='item' /**商品收藏**/
LEFT JOIN cp_shop_class AS cs ON a.cid_s=cs.id /**商品类型**/
LEFT JOIN cp_shop_store AS s ON a.sid=s.id /**店铺信息**/
WHERE a.cid_t=4 and a.value3 LIKE '%10063%' and a.status=1 and 1 ORDER BY id desc LIMIT -16 , 16array(8) {
[0]=>
array(6) {
["file"]=>
string(56) "/www/wwwroot/yidajian.net/cmspro/models/mysql.system.php"
["line"]=>
int(559)
["function"]=>
string(7) "execute"
["class"]=>
string(12) "PDOStatement"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[1]=>
array(6) {
["file"]=>
string(59) "/www/wwwroot/yidajian.net/cmspro/models/template.system.php"
["line"]=>
int(1454)
["function"]=>
string(5) "query"
["class"]=>
string(5) "Mysql"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(955) "SELECT a.*,
cs.name as csname, /**类型名称**/
mt.sign, /**货币符号**/
it.name as iname, /**积分名称**/
it.ico as iico, /**积分图标**/
s.name as sname, /**店铺名称**/
ws.count as wscount, /**收藏量**/
(SELECT COUNT(1) FROM cp_shop_cart ct WHERE ct.sid=a.id) as ctcount, /**全站购物车量**/
(SELECT COUNT(1) FROM cp_shop_order od WHERE od.pid=a.id) as odcount /**商品订单数量**/
FROM cp_shop_content AS a
LEFT JOIN cp_money_type AS mt ON a.money=mt.alias /**资金类型**/
LEFT JOIN cp_integral_type AS it ON a.integral=it.id /**积分类型**/
LEFT JOIN cp_sys_wishlist AS ws ON a.id=ws.sid and ws.type='item' /**商品收藏**/
LEFT JOIN cp_shop_class AS cs ON a.cid_s=cs.id /**商品类型**/
LEFT JOIN cp_shop_store AS s ON a.sid=s.id /**店铺信息**/
WHERE a.cid_t=4 and a.value3 LIKE '%10063%' and a.status=1 and 1 ORDER BY id desc LIMIT -16 , 16"
}
}
[2]=>
array(6) {
["file"]=>
string(59) "/www/wwwroot/yidajian.net/cmspro/models/template.system.php"
["line"]=>
int(748)
["function"]=>
string(7) "data_db"
["class"]=>
string(1) "T"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
array(12) {
["action"]=>
string(4) "item"
["panel"]=>
NULL
["class"]=>
NULL
["get"]=>
NULL
["post"]=>
NULL
["url"]=>
NULL
["from"]=>
NULL
["where"]=>
NULL
["field"]=>
NULL
["rows"]=>
string(2) "16"
["query"]=>
string(916) "SELECT a.*,
cs.name as csname, /**类型名称**/
mt.sign, /**货币符号**/
it.name as iname, /**积分名称**/
it.ico as iico, /**积分图标**/
s.name as sname, /**店铺名称**/
ws.count as wscount, /**收藏量**/
(SELECT COUNT(1) FROM cp_shop_cart ct WHERE ct.sid=a.id) as ctcount, /**全站购物车量**/
(SELECT COUNT(1) FROM cp_shop_order od WHERE od.pid=a.id) as odcount /**商品订单数量**/
FROM cp_shop_content AS a
LEFT JOIN cp_money_type AS mt ON a.money=mt.alias /**资金类型**/
LEFT JOIN cp_integral_type AS it ON a.integral=it.id /**积分类型**/
LEFT JOIN cp_sys_wishlist AS ws ON a.id=ws.sid and ws.type='item' /**商品收藏**/
LEFT JOIN cp_shop_class AS cs ON a.cid_s=cs.id /**商品类型**/
LEFT JOIN cp_shop_store AS s ON a.sid=s.id /**店铺信息**/
WHERE a.cid_t=4 and a.value3 LIKE '%10063%' and a.status=1"
["order"]=>
NULL
}
[1]=>
string(6018) "{cmspro.list}
登录即表示您同意并遵守 用户协议
登录即表示您同意并遵守 用户协议