[10501] PDOException in Connection.php line 388

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

  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 (\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 388
  2. at Connection->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 227
  3. at Query->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 2298
  4. at Query->getPdo() in Query.php line 413
  5. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 519
  6. at Query->count() in Query.php line 1348
  7. at Query->paginate(10, false, ['query' => ['id' => 'mzpc', 'baike' => 'baike']]) in Index.php line 555
  8. at Index->category()
  9. at ReflectionMethod->invokeArgs(object(Index), []) in App.php line 343
  10. at App::invokeMethod([object(Index), 'category'], []) in App.php line 598
  11. at App::module(['mzpc', 'index', 'category'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 457
  12. at App::exec(['type' => 'module', 'module' => ['mzpc', 'index', 'category']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  13. at App::run() in start.php line 19
  14. at require('/var/www/html/thinkp...') in index.php line 22

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'mzpc' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mzpc' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `news` `n` INNER JOIN `newscategory` `nc` ON `nc`.`NewsID`=`n`.`ID` INNER JOIN `newstwo` `nt` ON `nc`.`CategoryID`=`nt`.`ID` WHERE ( nc.CategoryID=mzpc and n.IsShow ) LIMIT 1
Database Config
type mysql
hostname rm-wz91a3z9wyh5n55y43o.mysql.rds.aliyuncs.com
database chinabeautycn
hostport 3306
dsn
params []
charset utf8
prefix
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
result_type 2
resultset_type array
auto_timestamp true
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

USER
www
HOME
/home/www
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/var/www/html/public/index.php
QUERY_STRING
s=/mzpc/index/category/id/mzpc/baike/baike.html
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/mzpc/index/category/id/mzpc/baike/baike.html
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/var/www/html/public
SERVER_PROTOCOL
HTTP/2.0
REQUEST_SCHEME
https
HTTPS
on
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.18.0
REMOTE_ADDR
35.173.178.60
REMOTE_PORT
51426
SERVER_ADDR
172.18.32.122
SERVER_PORT
443
SERVER_NAME
www.chinabeauty.cn
REDIRECT_STATUS
200
PATH_INFO
/mzpc/index/category/id/mzpc/baike/baike.html
HTTP_HOST
www.chinabeauty.cn
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
claudebot
HTTP_REFERER
http://www.chinabeauty.cn/mzpc/index/category/id/mzpc/baike/baike.html
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711664137.1581
REQUEST_TIME
1711664137
Environment Variables
empty

ThinkPHP Constants

APP_DEBUG
true
APP_PATH
/var/www/html/public/../app/
THINK_VERSION
5.0.14
THINK_START_TIME
1711664137.1586
THINK_START_MEM
263080
EXT
.php
DS
/
THINK_PATH
/var/www/html/thinkphp/
LIB_PATH
/var/www/html/thinkphp/library/
CORE_PATH
/var/www/html/thinkphp/library/think/
TRAIT_PATH
/var/www/html/thinkphp/library/traits/
ROOT_PATH
/var/www/html/
EXTEND_PATH
/var/www/html/extend/
VENDOR_PATH
/var/www/html/vendor/
RUNTIME_PATH
/var/www/html/runtime/
LOG_PATH
/var/www/html/runtime/log/
CACHE_PATH
/var/www/html/runtime/cache/
TEMP_PATH
/var/www/html/runtime/temp/
CONF_PATH
/var/www/html/public/../app/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false