[10501] PDOException in Connection.php line 687

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'index.php' in 'where clause'

  1. $this->debug(false, '', $master);
  2. // 返回结果集
  3. return $this->getResult($pdo, $procedure);
  4. } catch (\PDOException $e) {
  5. if ($this->isBreak($e)) {
  6. return $this->close()->query($sql, $bind, $master, $pdo);
  7. }
  8. throw new PDOException($e, $this->config, $this->getLastsql());
  9. } catch (\Throwable $e) {
  10. if ($this->isBreak($e)) {
  11. return $this->close()->query($sql, $bind, $master, $pdo);
  12. }
  13. throw $e;
  14. } catch (\Exception $e) {
  15. if ($this->isBreak($e)) {
  16. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 687
  2. at Connection->query('SELECT COUNT(*) AS t...', [], false, true) in Connection.php line 1299
  3. at Connection->value(object(Query), 'COUNT(*) AS tp_count', 0, false) in Connection.php line 1327
  4. at Connection->aggregate(object(Query), 'COUNT', '*') in Query.php line 623
  5. at Query->aggregate('COUNT', '*', true) in Query.php line 658
  6. at Query->count() in Query.php line 1784
  7. at Query->paginate(10, false, ['query' => ['cid' => 'index.php']]) in Infolist.php line 57
  8. at Infolist::getList(['classid' => 'index.php']) in 3e5a2b15a8a73827c5d76a85529b5a1f.php line 82
  9. at include('/www/wwwroot/www.san...') in File.php line 59
  10. at File->read('/www/wwwroot/www.san...', ['sys' => ['cfg_webname' => '...', 'cfg_webname_en_US' => 'En', 'cfg_weburl' => '', ...], 'myconfig' => ['pricebetween' => ['0-5000', '5000-10000', '10000-20000', ...], 'productservice' => ['吊带', '物流运输', '安装调试', ...]], 'Cartnum' => 0]) in Template.php line 226
  11. at Template->fetch('/www/wwwroot/www.san...', ['sys' => ['cfg_webname' => '...', 'cfg_webname_en_US' => 'En', 'cfg_weburl' => '', ...], 'myconfig' => ['pricebetween' => ['0-5000', '5000-10000', '10000-20000', ...], 'productservice' => ['吊带', '物流运输', '安装调试', ...]], 'Cartnum' => 0], []) in Think.php line 93
  12. at Think->fetch('', ['sys' => ['cfg_webname' => '...', 'cfg_webname_en_US' => 'En', 'cfg_weburl' => '', ...], 'myconfig' => ['pricebetween' => ['0-5000', '5000-10000', '10000-20000', ...], 'productservice' => ['吊带', '物流运输', '安装调试', ...]], 'Cartnum' => 0], []) in View.php line 192
  13. at View->fetch('', [], [], false) in View.php line 42
  14. at View->output('') in Response.php line 396
  15. at Response->getContent() in Response.php line 128
  16. at Response->send() in index.php line 22

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'index.php' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'index.php' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `hzjx_infolist` WHERE ( checkinfo='true' and delstate!='true' ) AND ( 1=1 and (classid=index.php OR parentstr Like '%,index.php,%') )
Database Config
type mysql
hostname 127.0.0.1
database www_sanyou_hz_co
hostport
dsn
params []
charset utf8
prefix hzjx_
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
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
FCGI_ROLE RESPONDER
SCRIPT_FILENAME /www/wwwroot/www.sanyou-hz.com/index.php
QUERY_STRING
REQUEST_METHOD GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME /index.php
REQUEST_URI /news/cid/index.php
DOCUMENT_URI /index.php/news/cid/index.php
DOCUMENT_ROOT /www/wwwroot/www.sanyou-hz.com
SERVER_PROTOCOL HTTP/1.1
REQUEST_SCHEME http
GATEWAY_INTERFACE CGI/1.1
SERVER_SOFTWARE nginx/1.18.0
REMOTE_ADDR 34.239.150.247
REMOTE_PORT 50416
SERVER_ADDR 172.16.231.236
SERVER_PORT 80
SERVER_NAME www.sanyou-hz.com
REDIRECT_STATUS 200
PATH_INFO /news/cid/index.php
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST sanyou-hz.com
PHP_SELF /index.php/news/cid/index.php
REQUEST_TIME_FLOAT 1711713588.4563
REQUEST_TIME 1711713588
Environment Variablesempty
ThinkPHP Constantsempty