[10501] PDOException in Connection.php line 385

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 '*.htm ) LIMIT 1' at line 1

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

  2.             // 调试结束

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

  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 (\Throwable $e) {

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

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

  14.             }

  15.             throw $e;

  16.         } catch (\Exception $e) {

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

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

  19.             }

Call Stack

  1. in Connection.php line 385
  2. at Connection->query('SELECT * FROM `z_dt`...', [], false, false) in Query.php line 255
  3. at Query->query('SELECT * FROM `z_dt`...', [], false, false) in Query.php line 2686
  4. at Query->find() in Acoustic.php line 33
  5. at Acoustic->getOneGoods() in Acoustic.php line 67
  6. at Acoustic->show()
  7. at ReflectionMethod->invokeArgs(object(Acoustic), []) in App.php line 343
  8. at App::invokeMethod([object(Acoustic), 'show'], []) in App.php line 611
  9. at App::module(['index', 'Acoustic', 'show'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 457
  10. at App::exec(['type' => 'module', 'module' => ['index', 'Acoustic', 'show'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  11. at App::run() in start.php line 19
  12. at require('/usr/home/qxu1194890...') in index.php line 51

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 '*.htm ) LIMIT 1' 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 '*.htm ) LIMIT 1' at line 1
Error SQL SELECT * FROM `z_dt` WHERE ( id=*.htm ) LIMIT 1
Database Config
type mysql
hostname qdm691805478.my3w.com
database qdm691805478_db
hostport 3306
dsn
params []
charset utf8
prefix z_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
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/qxu1194890095/htdocs
GATEWAY_INTERFACE
CGI/1.1
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
gzip, br, zstd, deflate
HTTP_CACHE_CONTROL
max-age=259200
HTTP_CONNECTION
close
HTTP_HOST
www.xmjiada.com
HTTP_REMOTE_HOST
216.73.216.228
HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_VIA
1.1 squid-proxy-5b5d847c96-z5725 (squid/6.10)
HTTP_X_FORWARDED_FOR
10.6.7.63, 216.73.216.228
HTTP_X_FORWARDED_PROTO
http
HTTP_X_REAL_IP
216.73.216.228
PATH
/bin
PHPRC
/var/www/php56/hichina_ini/qxu1194890095
QUERY_STRING
REDIRECT_DOCUMENT_ROOT
/usr/home/qxu1194890095/htdocs
REDIRECT_GATEWAY_INTERFACE
CGI/1.1
REDIRECT_HTTP_ACCEPT
*/*
REDIRECT_HTTP_ACCEPT_ENCODING
gzip, br, zstd, deflate
REDIRECT_HTTP_CACHE_CONTROL
max-age=259200
REDIRECT_HTTP_CONNECTION
close
REDIRECT_HTTP_HOST
www.xmjiada.com
REDIRECT_HTTP_REMOTE_HOST
216.73.216.228
REDIRECT_HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
REDIRECT_HTTP_VIA
1.1 squid-proxy-5b5d847c96-z5725 (squid/6.10)
REDIRECT_HTTP_X_FORWARDED_FOR
10.6.7.63, 216.73.216.228
REDIRECT_HTTP_X_FORWARDED_PROTO
http
REDIRECT_HTTP_X_REAL_IP
216.73.216.228
REDIRECT_PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO
/*.htm
REDIRECT_PATH_TRANSLATED
redirect:/index.php/*.htm
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR
10.0.21.153
REDIRECT_REMOTE_PORT
34724
REDIRECT_REQUEST_METHOD
GET
REDIRECT_REQUEST_URI
/Dynamics-show/*.htm
REDIRECT_SCRIPT_FILENAME
/usr/home/qxu1194890095/htdocs/Dynamics-show
REDIRECT_SCRIPT_NAME
/Dynamics-show
REDIRECT_SERVER_ADDR
10.0.41.210
REDIRECT_SERVER_ADMIN
webmaster@qxu1194890095.my3w.com
REDIRECT_SERVER_NAME
www.xmjiada.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
aFAqoQoAKdIANhtp2j4AAABX
REDIRECT_URL
/Dynamics-show/*.htm
REMOTE_ADDR
10.0.21.153
REMOTE_PORT
34724
REQUEST_METHOD
GET
REQUEST_URI
/Dynamics-show/*.htm
SCRIPT_FILENAME
/usr/home/qxu1194890095/htdocs/index.php
SCRIPT_NAME
/index.php
SERVER_ADDR
10.0.41.210
SERVER_ADMIN
webmaster@qxu1194890095.my3w.com
SERVER_NAME
www.xmjiada.com
SERVER_PORT
80
SERVER_PROTOCOL
HTTP/1.0
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache
TZ
Asia/Shanghai
UNIQUE_ID
aFAqoQoAKdIANhtp2j4AAABX
ORIG_PATH_INFO
/Dynamics-show/*.htm
ORIG_PATH_TRANSLATED
/usr/home/qxu1194890095/htdocs/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1750084257.7738
REQUEST_TIME
1750084257
PATH_INFO
/Dynamics-show/*.htm
Environment Variables
empty

ThinkPHP Constants

EXTEND_PATH
/usr/home/qxu1194890095/htdocs/extend/
PAdmin
/public/Admin
Pub
/public/
PAI
/public/Admin/images
PAL
/public/Admin/logo
PAC
/public/Admin/css
PAJ
/public/Admin/js
Pm
/public/modules
Pl
/public/layui
Pi
/public/images
URL
www.xmjiada.com
PHome
/public/home
PHF
/public/home/font
PHI
/public/home/img
PHC
/public/home/css
PHJ
/public/home/js
PHCE
/public/home/css-english
ROOT
APP_PATH
/usr/home/qxu1194890095/htdocs/application/
THINK_VERSION
5.0.24
THINK_START_TIME
1750084257.7746
THINK_START_MEM
227928
EXT
.php
DS
/
THINK_PATH
/usr/home/qxu1194890095/htdocs/thinkphp/
LIB_PATH
/usr/home/qxu1194890095/htdocs/thinkphp/library/
CORE_PATH
/usr/home/qxu1194890095/htdocs/thinkphp/library/think/
TRAIT_PATH
/usr/home/qxu1194890095/htdocs/thinkphp/library/traits/
ROOT_PATH
/usr/home/qxu1194890095/htdocs/
VENDOR_PATH
/usr/home/qxu1194890095/htdocs/vendor/
RUNTIME_PATH
/usr/home/qxu1194890095/htdocs/runtime/
LOG_PATH
/usr/home/qxu1194890095/htdocs/runtime/log/
CACHE_PATH
/usr/home/qxu1194890095/htdocs/runtime/cache/
TEMP_PATH
/usr/home/qxu1194890095/htdocs/runtime/temp/
CONF_PATH
/usr/home/qxu1194890095/htdocs/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
ThinkPHP V5.0.24 { 十年磨一剑-为API开发设计的高性能框架 }