[10501] PDOException in Connection.php line 388

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'list_51' 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 `id`,`title` ...', [], false, false) in Query.php line 227
  3. at Query->query('SELECT `id`,`title` ...', [], false, false) in Query.php line 2499
  4. at Query->find() in News.php line 46
  5. at News->content()
  6. at ReflectionMethod->invokeArgs(object(News), []) in App.php line 345
  7. at App::invokeMethod([object(News), 'content'], []) in App.php line 599
  8. at App::module(['index', 'news', 'content'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 461
  9. at App::exec(['type' => 'module', 'module' => ['index', 'news', 'content'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 140
  10. at App::run() in start.php line 19
  11. at require('/var/www/html/www.ka...') in index.php line 36

Exception Datas

PDO Error Info
SQLSTATE
42S22
Driver Error Code
1054
Driver Error Message
Unknown column 'list_51' in 'where clause'
Database Status
Error Code
10501
Error Message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'list_51' in 'where clause'
Error SQL
SELECT `id`,`title` FROM `news` WHERE ( id <list_51 ) ORDER BY id desc LIMIT 1
Database Config
type
mysql
hostname
47.97.220.239
database
jt
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
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

MYSQL_PORT_33060_TCP
tcp://172.17.0.4:33060
REDIS_PORT
tcp://172.17.0.3:6379
PHP_EXTRA_CONFIGURE_ARGS
--enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi
REDIS_PORT_6379_TCP_ADDR
172.17.0.3
HOSTNAME
60be0f30d3be
REDIS_NAME
/php/redis
PHP_INI_DIR
/usr/local/etc/php
REDIS_PORT_6379_TCP_PORT
6379
HOME
/var/www
REDIS_PORT_6379_TCP_PROTO
tcp
REDIS_ENV_REDIS_DOWNLOAD_URL
http://download.redis.io/releases/redis-5.0.0.tar.gz
REDIS_ENV_REDIS_VERSION
5.0.0
PHP_LDFLAGS
-Wl,-O1 -Wl,--hash-style=both -pie
MYSQL_ENV_WORK_PATH
/usr/local/work
PHP_CFLAGS
-fstack-protector-strong -fpic -fpie -O2
PHP_MD5
MYSQL_ENV_INSTALL_DATA_SHELL
install_data.sh
PHP_VERSION
5.6.38
MYSQL_ENV_MYSQL_MAJOR
5.7
GPG_KEYS
0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3
REDIS_PORT_6379_TCP
tcp://172.17.0.3:6379
PHP_CPPFLAGS
-fstack-protector-strong -fpic -fpie -O2
PHP_ASC_URL
https://secure.php.net/get/php-5.6.38.tar.xz.asc/from/this/mirror
PHP_URL
https://secure.php.net/get/php-5.6.38.tar.xz/from/this/mirror
MYSQL_PORT_3306_TCP_ADDR
172.17.0.4
MYSQL_ENV_MYSQL_ROOT_PASSWORD
1qq2ww3ee4rr
PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
MYSQL_ENV_GOSU_VERSION
1.7
MYSQL_PORT_3306_TCP_PORT
3306
MYSQL_PORT_3306_TCP_PROTO
tcp
REDIS_ENV_REDIS_DOWNLOAD_SHA
70c98b2d0640b2b73c9d8adb4df63bcb62bad34b788fe46d1634b6cf87dc99a4
MYSQL_PORT_33060_TCP_ADDR
172.17.0.4
MYSQL_ENV_AUTO_RUN_DIR
/docker-entrypoint-initdb.d
MYSQL_PORT
tcp://172.17.0.4:3306
MYSQL_PORT_3306_TCP
tcp://172.17.0.4:3306
MYSQL_PORT_33060_TCP_PORT
33060
MYSQL_ENV_MYSQL_VERSION
5.7.24-1debian9
REDIS_ENV_GOSU_VERSION
1.10
MYSQL_PORT_33060_TCP_PROTO
tcp
MYSQL_NAME
/php/mysql
PHPIZE_DEPS
autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c
PWD
/var/www/html
PHP_SHA256
c2fac47dc6316bd230f0ea91d8a5498af122fb6a3eb43f796c9ea5f59b04aa1e
MYSQL_ENV_FILE_1
sql.sql
USER
www-data
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/var/www/html/www.kailinjt.com/index.php
PATH_INFO
news/list_51.html
QUERY_STRING
s=news/list_51.html
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/news/list_51.html
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/var/www/html/www.kailinjt.com
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.15.5
REMOTE_ADDR
154.219.153.225
REMOTE_PORT
20000
SERVER_ADDR
172.17.0.5
SERVER_PORT
80
SERVER_NAME
www.kailinjt.com
REDIRECT_STATUS
200
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
www.kailinjt.com
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
deflate, gzip
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1568859641.8001
REQUEST_TIME
1568859641
argv
[ "s=news\/list_51.html" ]
argc
1

Environment Variables

MYSQL_PORT_33060_TCP
tcp://172.17.0.4:33060
REDIS_PORT
tcp://172.17.0.3:6379
PHP_EXTRA_CONFIGURE_ARGS
--enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi
REDIS_PORT_6379_TCP_ADDR
172.17.0.3
HOSTNAME
60be0f30d3be
REDIS_NAME
/php/redis
PHP_INI_DIR
/usr/local/etc/php
REDIS_PORT_6379_TCP_PORT
6379
HOME
/var/www
REDIS_PORT_6379_TCP_PROTO
tcp
REDIS_ENV_REDIS_DOWNLOAD_URL
http://download.redis.io/releases/redis-5.0.0.tar.gz
REDIS_ENV_REDIS_VERSION
5.0.0
PHP_LDFLAGS
-Wl,-O1 -Wl,--hash-style=both -pie
MYSQL_ENV_WORK_PATH
/usr/local/work
PHP_CFLAGS
-fstack-protector-strong -fpic -fpie -O2
PHP_MD5
MYSQL_ENV_INSTALL_DATA_SHELL
install_data.sh
PHP_VERSION
5.6.38
MYSQL_ENV_MYSQL_MAJOR
5.7
GPG_KEYS
0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3
REDIS_PORT_6379_TCP
tcp://172.17.0.3:6379
PHP_CPPFLAGS
-fstack-protector-strong -fpic -fpie -O2
PHP_ASC_URL
https://secure.php.net/get/php-5.6.38.tar.xz.asc/from/this/mirror
PHP_URL
https://secure.php.net/get/php-5.6.38.tar.xz/from/this/mirror
MYSQL_PORT_3306_TCP_ADDR
172.17.0.4
MYSQL_ENV_MYSQL_ROOT_PASSWORD
1qq2ww3ee4rr
PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
MYSQL_ENV_GOSU_VERSION
1.7
MYSQL_PORT_3306_TCP_PORT
3306
MYSQL_PORT_3306_TCP_PROTO
tcp
REDIS_ENV_REDIS_DOWNLOAD_SHA
70c98b2d0640b2b73c9d8adb4df63bcb62bad34b788fe46d1634b6cf87dc99a4
MYSQL_PORT_33060_TCP_ADDR
172.17.0.4
MYSQL_ENV_AUTO_RUN_DIR
/docker-entrypoint-initdb.d
MYSQL_PORT
tcp://172.17.0.4:3306
MYSQL_PORT_3306_TCP
tcp://172.17.0.4:3306
MYSQL_PORT_33060_TCP_PORT
33060
MYSQL_ENV_MYSQL_VERSION
5.7.24-1debian9
REDIS_ENV_GOSU_VERSION
1.10
MYSQL_PORT_33060_TCP_PROTO
tcp
MYSQL_NAME
/php/mysql
PHPIZE_DEPS
autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c
PWD
/var/www/html
PHP_SHA256
c2fac47dc6316bd230f0ea91d8a5498af122fb6a3eb43f796c9ea5f59b04aa1e
MYSQL_ENV_FILE_1
sql.sql
USER
www-data
FCGI_ROLE
RESPONDER
SCRIPT_FILENAME
/var/www/html/www.kailinjt.com/index.php
PATH_INFO
QUERY_STRING
s=news/list_51.html
REQUEST_METHOD
GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME
/index.php
REQUEST_URI
/news/list_51.html
DOCUMENT_URI
/index.php
DOCUMENT_ROOT
/var/www/html/www.kailinjt.com
SERVER_PROTOCOL
HTTP/1.1
REQUEST_SCHEME
http
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.15.5
REMOTE_ADDR
154.219.153.225
REMOTE_PORT
20000
SERVER_ADDR
172.17.0.5
SERVER_PORT
80
SERVER_NAME
www.kailinjt.com
REDIRECT_STATUS
200
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
www.kailinjt.com
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
deflate, gzip
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1568859641.8001
REQUEST_TIME
1568859641
argv
[ "s=news\/list_51.html" ]
argc
1

ThinkPHP Constants

BIND_MODULE
index
APP_PATH
/var/www/html/www.kailinjt.com/application/
THINK_VERSION
5.0.15
THINK_START_TIME
1568859641.8003
THINK_START_MEM
243296
EXT
.php
DS
/
THINK_PATH
/var/www/html/www.kailinjt.com/thinkphp/
LIB_PATH
/var/www/html/www.kailinjt.com/thinkphp/library/
CORE_PATH
/var/www/html/www.kailinjt.com/thinkphp/library/think/
TRAIT_PATH
/var/www/html/www.kailinjt.com/thinkphp/library/traits/
ROOT_PATH
/var/www/html/www.kailinjt.com/
EXTEND_PATH
/var/www/html/www.kailinjt.com/extend/
VENDOR_PATH
/var/www/html/www.kailinjt.com/vendor/
RUNTIME_PATH
/var/www/html/www.kailinjt.com/runtime/
LOG_PATH
/var/www/html/www.kailinjt.com/runtime/log/
CACHE_PATH
/var/www/html/www.kailinjt.com/runtime/cache/
TEMP_PATH
/var/www/html/www.kailinjt.com/runtime/temp/
CONF_PATH
/var/www/html/www.kailinjt.com/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false