错误出现的位置:/www/wwwroot/v2.depin.wang/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 '-24 , 24' 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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1 and 1 ORDER BY a.id desc LIMIT -24 , 24array(8) {
[0]=>
array(6) {
["file"]=>
string(57) "/www/wwwroot/v2.depin.wang/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(60) "/www/wwwroot/v2.depin.wang/cmspro/models/template.system.php"
["line"]=>
int(1368)
["function"]=>
string(5) "query"
["class"]=>
string(5) "Mysql"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&string(1016) "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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1 and 1 ORDER BY a.id desc LIMIT -24 , 24"
}
}
[2]=>
array(6) {
["file"]=>
string(60) "/www/wwwroot/v2.depin.wang/cmspro/models/template.system.php"
["line"]=>
int(712)
["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) "24"
["query"]=>
string(975) "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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1"
["order"]=>
string(9) "a.id desc"
}
[1]=>
&string(6875) "{cmspro.list}
{action='item'}
{query='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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1'}
{rows='24'}
{order='a.id desc'}
{list}
{cmspro.list}
{action='item'}
{query='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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1'}
{rows='24'}
{order='a.id desc'}
{list}
{cmspro.list}
{action='item'}
{query='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.value1 LIKE '%10019%' or a.value1 LIKE '%10007%' ) and a.value3 LIKE '%10057%' and a.status=1'}
{rows='24'}
{order='a.id desc'}
{list}