System Error

[10501] PDOException in Connection.php line 388

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 '-10,10' at line 1

  1.             $this->PDOStatement->execute();

  2.             // 调试结束

  3.             $this->debug(false);

  4.             // 返回结果集

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

  6.         } catch (\PDOException $e) {

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

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

  9.             }

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

  11.         } catch (\Exception $e) {

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

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

  14.             }

  15.             throw $e;

  16.         }

  17.     }

  18. 

  19.     /**

Call Stack

  1. in Connection.php line 388
  2. at Connection->query('SELECT * FROM `clt_n...', ['where_catid' => ['56', 1]], false, false) in Query.php line 241
  3. at Query->query('SELECT * FROM `clt_n...', ['where_catid' => ['56', 1]], false, false) in Query.php line 2334
  4. at Query->select() in News.php line 24
  5. at News->index()
  6. at ReflectionMethod->invokeArgs(object(News), []) in App.php line 197
  7. at App::invokeMethod([object(News), 'index'], []) in App.php line 414
  8. at App::module(['home', 'news', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 296
  9. at App::exec(['type' => 'module', 'module' => ['home', 'news', 'index']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 124
  10. at App::run() in start.php line 18
  11. at require('/usr/home/wh-abgtb74...') in index.php line 23

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 '-10,10' 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 '-10,10' at line 1
Error SQL SELECT * FROM `clt_news` WHERE `catid` = 56 AND ( status =1 or (status=0 and createtime < 1778379883 ) ) ORDER BY listorder desc,id desc LIMIT -10,10
Database Config
type mysql
hostname bdm791321425.my3w.com
database bdm791321425_db
hostport 3306
dsn
params []
charset utf8
prefix clt_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict false
result_type 2
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

Environment Variables

GET Data
empty
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

DOCUMENT_ROOT
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs
GATEWAY_INTERFACE
CGI/1.1
HTTPS
on
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
gzip, br, zstd, deflate
HTTP_CONNECTION
close
HTTP_HOST
hbxf.com
HTTP_REMOTE_HOST
216.73.216.138
HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR
216.73.216.138
HTTP_X_FORWARDED_PROTO
https
HTTP_X_REAL_IP
216.73.216.138
PATH
/bin
PHPRC
/var/www/php70/hichina_ini/wh-abgtb74n2lnn6pf0cbc
QUERY_STRING
s=home/news/index/id/56/page/product_diy.html
REDIRECT_DOCUMENT_ROOT
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs
REDIRECT_GATEWAY_INTERFACE
CGI/1.1
REDIRECT_HTTPS
on
REDIRECT_HTTP_ACCEPT
*/*
REDIRECT_HTTP_ACCEPT_ENCODING
gzip, br, zstd, deflate
REDIRECT_HTTP_CONNECTION
close
REDIRECT_HTTP_HOST
hbxf.com
REDIRECT_HTTP_REMOTE_HOST
216.73.216.138
REDIRECT_HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
REDIRECT_HTTP_X_FORWARDED_FOR
216.73.216.138
REDIRECT_HTTP_X_FORWARDED_PROTO
https
REDIRECT_HTTP_X_REAL_IP
216.73.216.138
REDIRECT_PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO
/news/index/id/56/page/product_diy.html
REDIRECT_PATH_TRANSLATED
redirect:/index.php/index/id/56/page/product_diy.html
REDIRECT_QUERY_STRING
s=home/news/index/id/56/page/product_diy.html
REDIRECT_REMOTE_ADDR
10.0.6.118
REDIRECT_REMOTE_PORT
34694
REDIRECT_REQUEST_METHOD
GET
REDIRECT_REQUEST_URI
/home/news/index/id/56/page/product_diy.html
REDIRECT_SCRIPT_FILENAME
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/home
REDIRECT_SCRIPT_NAME
/home
REDIRECT_SERVER_ADDR
10.0.68.8
REDIRECT_SERVER_ADMIN
webmaster@wh-abgtb74n2lnn6pf0cbc.my3w.com
REDIRECT_SERVER_NAME
hbxf.com
REDIRECT_SERVER_PORT
80
REDIRECT_SERVER_PROTOCOL
HTTP/1.0
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE
Apache
REDIRECT_STATUS
200
REDIRECT_TZ
Asia/Shanghai
REDIRECT_UNIQUE_ID
af-sawoARAgABAgbR5AAAAAA
REDIRECT_URL
/home/news/index/id/56/page/product_diy.html
REMOTE_ADDR
10.0.6.118
REMOTE_PORT
34694
REQUEST_METHOD
GET
REQUEST_URI
/home/news/index/id/56/page/product_diy.html
SCRIPT_FILENAME
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/index.php
SCRIPT_NAME
/index.php
SERVER_ADDR
10.0.68.8
SERVER_ADMIN
webmaster@wh-abgtb74n2lnn6pf0cbc.my3w.com
SERVER_NAME
hbxf.com
SERVER_PORT
80
SERVER_PROTOCOL
HTTP/1.0
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache
TZ
Asia/Shanghai
UNIQUE_ID
af-sawoARAgABAgbR5AAAAAA
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1778379883.0926
REQUEST_TIME
1778379883
PATH_INFO
home/news/index/id/56/page/product_diy.html
Environment Variables
empty

ThinkPHP Constants

__PUBLIC__
/public
APP_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/app/
DATA_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/runtime/Data/
PLUGIN_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/plugins/
THINK_VERSION
5.0.11
THINK_START_TIME
1778379883.0933
THINK_START_MEM
357728
EXT
.php
DS
/
THINK_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/think/
LIB_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/think/library/
CORE_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/think/library/think/
TRAIT_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/think/library/traits/
ROOT_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/
EXTEND_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/extend/
VENDOR_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/vendor/
RUNTIME_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/runtime/
LOG_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/runtime/log/
CACHE_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/runtime/cache/
TEMP_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/runtime/temp/
CONF_PATH
/usr/home/wh-abgtb74n2lnn6pf0cbc/htdocs/app/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
UPLOAD_PATH
./Uploads/
MAX_MENU_LENGTH
3
MAX_SUB_MENU_LENGTH
5
MODULE_NAME
news
ACTION_NAME
index
ThinkPHP V5.0.11 { 十年磨一剑-为API开发设计的高性能框架 }