[10501] PDOException in Connection.php line 362

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 field(id, 120872,315593,121524,121520,643837,732651,120855,643838,444' at line 1

  1. // 参数绑定
  2. $this->bindValue($bind);
  3. // 执行查询
  4. $result = $this->PDOStatement->execute();
  5. // 调试结束
  6. $this->debug(false);
  7. $procedure = in_array(strtolower(substr(trim($sql), 0, 4)), ['call', 'exec']);
  8. return $this->getResult($class, $procedure);
  9. } catch (\PDOException $e) {
  10. throw new PDOException($e, $this->config, $this->queryStr);
  11. }
  12. }
  13. /**
  14. * 执行语句
  15. * @access public
  16. * @param string $sql sql指令
  17. * @param array $bind 参数绑定
  18. * @return int

Call Stack

  1. in Connection.php line 362
  2. at Connection->query('select detail_name, ...')
  3. at call_user_func_array([object(Mysql), 'query'], ['select detail_name, ...']) in Db.php line 148
  4. at Db::__callStatic('query', ['select detail_name, ...']) in Product.php line 120
  5. at Db::query('select detail_name, ...') in Product.php line 120
  6. at Product->productBrands()
  7. at ReflectionMethod->invokeArgs(object(Product), []) in App.php line 229
  8. at App::invokeMethod([object(Product), 'productBrands']) in App.php line 386
  9. at App::module([null, 'Product', 'productBrands'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => true, ...], false) in App.php line 137
  10. at App::run() in start.php line 18
  11. at require('/home/manuala/public...') in index.php line 26

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 field(id, 120872,315593,121524,121520,643837,732651,120855,643838,444' 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 field(id, 120872,315593,121524,121520,643837,732651,120855,643838,444' at line 1
Error SQL select detail_name, current_url from mg_detail where id in(120872,315593,121524,121520,643837,732651,120855,643838,44429,121562,648611,60979,120888,643836,643834,120866,120867,204309,120380,120396,120873,299553,118827,44456,752237,120436,732666,134761,715972,120868,396500,119152,44421,643840,312417,119151,677219,) order by field(id, 120872,315593,121524,121520,643837,732651,120855,643838,44429,121562,648611,60979,120888,643836,643834,120866,120867,204309,120380,120396,120873,299553,118827,44456,752237,120436,732666,134761,715972,120868,396500,119152,44421,643840,312417,119151,677219,)
Database Config
type mysql
hostname localhost
database manuala_agent
username manuala_db
password DB31415926535
hostport 3306
dsn
params []
charset utf8
prefix mg_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
resultset_type array
auto_timestamp false
sql_explain false
builder
query \think\db\Query

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
TZ US/Pacific
REDIRECT_REDIRECT_UNIQUE_ID ZgXpDg5oLLmaF_163lUD8QAAAA0
REDIRECT_REDIRECT_SCRIPT_URL /product/kitchen-manuals/page-3
REDIRECT_REDIRECT_SCRIPT_URI http://www.manualagent.com/product/kitchen-manuals/page-3
REDIRECT_REDIRECT_STATUS 200
REDIRECT_UNIQUE_ID ZgXpDg5oLLmaF_163lUD8QAAAA0
REDIRECT_SCRIPT_URL /product/kitchen-manuals/page-3
REDIRECT_SCRIPT_URI http://www.manualagent.com/product/kitchen-manuals/page-3
REDIRECT_HANDLER application/x-httpd-ea-php56
REDIRECT_STATUS 200
UNIQUE_ID ZgXpDg5oLLmaF_163lUD8QAAAA0
SCRIPT_URL /product/kitchen-manuals/page-3
SCRIPT_URI http://www.manualagent.com/product/kitchen-manuals/page-3
HTTP_HOST www.manualagent.com
HTTP_CONNECTION Keep-Alive
HTTP_ACCEPT_ENCODING gzip, br
HTTP_X_FORWARDED_FOR 54.165.248.212
HTTP_CF_RAY 86bae83d9b8938aa-IAD
HTTP_X_FORWARDED_PROTO https
HTTP_CF_VISITOR {"scheme":"https"}
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_CF_CONNECTING_IP 54.165.248.212
HTTP_CDN_LOOP cloudflare
HTTP_CF_IPCOUNTRY US
PATH /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
SERVER_NAME www.manualagent.com
SERVER_ADDR 45.33.80.25
SERVER_PORT 80
REMOTE_ADDR 172.71.222.22
DOCUMENT_ROOT /home/manuala/public_html
REQUEST_SCHEME http
CONTEXT_PREFIX /cgi-sys
CONTEXT_DOCUMENT_ROOT /usr/local/cpanel/cgi-sys/
SERVER_ADMIN webmaster@manualagent.com
SCRIPT_FILENAME /home/manuala/public_html/index.php
REMOTE_PORT 10838
REDIRECT_URL /index.php/product/kitchen-manuals/page-3
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /product/kitchen-manuals/page-3
SCRIPT_NAME /index.php
PATH_INFO /product/kitchen-manuals/page-3
PATH_TRANSLATED /home/manuala/public_html/product/kitchen-manuals/page-3
ORIG_PATH_INFO /index.php/product/kitchen-manuals/page-3
ORIG_SCRIPT_NAME /cgi-sys/ea-php56
ORIG_SCRIPT_FILENAME /usr/local/cpanel/cgi-sys/ea-php56
ORIG_PATH_TRANSLATED /home/manuala/public_html/index.php/product/kitchen-manuals/page-3
PHP_SELF /index.php/product/kitchen-manuals/page-3
REQUEST_TIME_FLOAT 1711663374.1376
REQUEST_TIME 1711663374
argv []
argc 0
Environment Variablesempty
ThinkPHP Constants
APP_PATH /home/manuala/public_html/application/
WEB_URL
THINK_VERSION 5.0.2dev
THINK_START_TIME 1711663374.1382
THINK_START_MEM 248056
EXT .php
DS /
THINK_PATH /home/manuala/public_html/thinkphp/
LIB_PATH /home/manuala/public_html/thinkphp/library/
CORE_PATH /home/manuala/public_html/thinkphp/library/think/
TRAIT_PATH /home/manuala/public_html/thinkphp/library/traits/
ROOT_PATH /home/manuala/public_html/
EXTEND_PATH /home/manuala/public_html/extend/
VENDOR_PATH /home/manuala/public_html/vendor/
RUNTIME_PATH /home/manuala/public_html/runtime/
LOG_PATH /home/manuala/public_html/runtime/log/
CACHE_PATH /home/manuala/public_html/runtime/cache/
TEMP_PATH /home/manuala/public_html/runtime/temp/
CONF_PATH /home/manuala/public_html/application/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN false
0.125302s