[10501] PDOException in Connection.php line 453

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

  1.                 $query->readMaster();

  2.             }

  3. 

  4.             $this->numRows = $this->PDOStatement->rowCount();

  5.             return $this->numRows;

  6.         } catch (\PDOException $e) {

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

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

  9.             }

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

  11.         } catch (\Throwable $e) {

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

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

  14.             }

  15.             throw $e;

  16.         } catch (\Exception $e) {

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

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

  19.             }

Call Stack

  1. in Connection.php line 453
  2. at Connection->execute('UPDATE `app_article`...', [], object(Query)) in Query.php line 269
  3. at Query->execute('UPDATE `app_article`...', [], object(Query)) in Query.php line 2437
  4. at Query->update(['click' => ['inc', 1]]) in Query.php line 642
  5. at Query->setField('click', ['inc', 1]) in Query.php line 671
  6. at Query->setInc('click', 1) in Page.php line 17
  7. at Page->index()
  8. at ReflectionMethod->invokeArgs(object(Page), []) in App.php line 343
  9. at App::invokeMethod([object(Page), 'index'], []) in App.php line 611
  10. at App::module(['index', 'Page', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 456
  11. at App::exec(['type' => 'module', 'module' => ['index', 'Page', 'index'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  12. at App::run() in start.php line 19
  13. at require('/usr/home/hyu7870120...') in index.php line 28

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'page' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where clause'
Error SQL UPDATE `app_article` SET `click`=`click`+1 WHERE ( id=page )
Database Config
type mysql
hostname hdm721900629.my3w.com
database hdm721900629_db
hostport 3306
dsn
params []
charset utf8
prefix app_
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 true
datetime_format false
sql_explain false
builder
query \think\db\Query
break_reconnect false

Environment Variables

GET Data
empty
POST Data
empty
Files
empty

Cookies

PHPSESSID
a5koc17l3fpqdt8c4f8sg8l815
Session
empty

Server/Request Data

DOCUMENT_ROOT
/usr/home/hyu7870120001/htdocs
GATEWAY_INTERFACE
CGI/1.1
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
gzip
HTTP_COOKIE
PHPSESSID=a5koc17l3fpqdt8c4f8sg8l815
HTTP_HOST
www.vommatec.com
HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PATH
/bin
PHPRC
/var/www/php70/hichina_ini/hyu7870120001
QUERY_STRING
REDIRECT_DOCUMENT_ROOT
/usr/home/hyu7870120001/htdocs
REDIRECT_GATEWAY_INTERFACE
CGI/1.1
REDIRECT_HTTP_ACCEPT
*/*
REDIRECT_HTTP_ACCEPT_ENCODING
gzip
REDIRECT_HTTP_COOKIE
PHPSESSID=a5koc17l3fpqdt8c4f8sg8l815
REDIRECT_HTTP_HOST
www.vommatec.com
REDIRECT_HTTP_USER_AGENT
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
REDIRECT_PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO
/137/page/132/220.html
REDIRECT_PATH_TRANSLATED
redirect:/index.php/137/page/132/220.html/page/132/220.html
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR
170.130.206.22
REDIRECT_REMOTE_PORT
46418
REDIRECT_REQUEST_METHOD
GET
REDIRECT_REQUEST_URI
//page/137/page/132/220.html
REDIRECT_SCRIPT_FILENAME
/usr/home/hyu7870120001/htdocs/page
REDIRECT_SCRIPT_NAME
/page
REDIRECT_SERVER_ADDR
10.21.65.83
REDIRECT_SERVER_ADMIN
webmaster@hyu7870120001.my3w.com
REDIRECT_SERVER_NAME
www.vommatec.com
REDIRECT_SERVER_PORT
80
REDIRECT_SERVER_PROTOCOL
HTTP/1.1
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE
Apache
REDIRECT_STATUS
200
REDIRECT_TZ
Asia/Shanghai
REDIRECT_UNIQUE_ID
ZkGV@goVQVMAN2S7cdcAAAAL
REDIRECT_URL
/page/137/page/132/220.html
REMOTE_ADDR
170.130.206.22
REMOTE_PORT
46418
REQUEST_METHOD
GET
REQUEST_URI
//page/137/page/132/220.html
SCRIPT_FILENAME
/usr/home/hyu7870120001/htdocs/index.php
SCRIPT_NAME
/index.php
SERVER_ADDR
10.21.65.83
SERVER_ADMIN
webmaster@hyu7870120001.my3w.com
SERVER_NAME
www.vommatec.com
SERVER_PORT
80
SERVER_PROTOCOL
HTTP/1.1
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache
TZ
Asia/Shanghai
UNIQUE_ID
ZkGV@goVQVMAN2S7cdcAAAAL
ORIG_PATH_INFO
/page/137/page/132/220.html
ORIG_PATH_TRANSLATED
/usr/home/hyu7870120001/htdocs/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1715574266.6071
REQUEST_TIME
1715574266
PATH_INFO
/page/137/page/132/220.html
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/usr/home/hyu7870120001/htdocs/application/
WXPAY_PATH
/usr/home/hyu7870120001/htdocs/vendor
THINK_VERSION
5.0.24
THINK_START_TIME
1715574266.6079
THINK_START_MEM
351488
EXT
.php
DS
/
THINK_PATH
/usr/home/hyu7870120001/htdocs/thinkphp/
LIB_PATH
/usr/home/hyu7870120001/htdocs/thinkphp/library/
CORE_PATH
/usr/home/hyu7870120001/htdocs/thinkphp/library/think/
TRAIT_PATH
/usr/home/hyu7870120001/htdocs/thinkphp/library/traits/
ROOT_PATH
/usr/home/hyu7870120001/htdocs/
EXTEND_PATH
/usr/home/hyu7870120001/htdocs/extend/
VENDOR_PATH
/usr/home/hyu7870120001/htdocs/vendor/
RUNTIME_PATH
/usr/home/hyu7870120001/htdocs/runtime/
LOG_PATH
/usr/home/hyu7870120001/htdocs/runtime/log/
CACHE_PATH
/usr/home/hyu7870120001/htdocs/runtime/cache/
TEMP_PATH
/usr/home/hyu7870120001/htdocs/runtime/temp/
CONF_PATH
/usr/home/hyu7870120001/htdocs/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
ThinkPHP V5.0.24 { 十年磨一剑-为API开发设计的高性能框架 }