[10501] PDOException in Connection.php line 362

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

  1. // 参数绑定
  2. $this->bindValue($bind);
  3. // 执行查询
  4. $result = $this->PDOStatement->execute();
  5. // 调试结束
  6. $this->debug(false);
  7. $procedure = in_array(strtolower(substr(trim($sql), 0, 4)), ['call', 'exec']);
  8. return $this->getResult($class, $procedure);
  9. } catch (\PDOException $e) {
  10. throw new PDOException($e, $this->config, $this->queryStr);
  11. }
  12. }
  13. /**
  14. * 执行语句
  15. * @access public
  16. * @param string $sql sql指令
  17. * @param array $bind 参数绑定
  18. * @return int

Call Stack

  1. in Connection.php line 362
  2. at Connection->query('SELECT COUNT(*) AS t...', ['where_status' => [1, 1]], false, true) in Query.php line 191
  3. at Query->query('SELECT COUNT(*) AS t...', ['where_status' => [1, 1]], false, true) in Query.php line 2030
  4. at Query->find() in Query.php line 394
  5. at Query->value('COUNT(*) AS tp_count', 0) in Query.php line 492
  6. at Query->count() in Query.php line 1030
  7. at Query->paginate(15, false, ['query' => []]) in Base.php line 223
  8. at Base->index()
  9. at ReflectionMethod->invokeArgs(object(Error), []) in App.php line 232
  10. at App::invokeMethod([object(Error), 'index'], []) in App.php line 401
  11. at App::module(['home', 'page', 'index'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 140
  12. at App::run() in start.php line 48
  13. at require('/usr/home/qxu1099440...') in index.php line 13

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
DOCUMENT_ROOT /usr/home/qxu1099440017/htdocs
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT */*
HTTP_CONNECTION close
HTTP_HOST www.guanggaow.com
HTTP_REFERER http://www.guanggaow.com/home/page/index/id/24.html
HTTP_REMOTE_HOST 44.201.64.238
HTTP_USER_AGENT claudebot
HTTP_X_FORWARDED_FOR 44.201.64.238
HTTP_X_REAL_IP 44.201.64.238
PATH /bin
PHPRC /var/www/php55/hichina_ini/qxu1099440017
QUERY_STRING
REDIRECT_DOCUMENT_ROOT /usr/home/qxu1099440017/htdocs
REDIRECT_GATEWAY_INTERFACE CGI/1.1
REDIRECT_HTTP_ACCEPT */*
REDIRECT_HTTP_CONNECTION close
REDIRECT_HTTP_HOST www.guanggaow.com
REDIRECT_HTTP_REFERER http://www.guanggaow.com/home/page/index/id/24.html
REDIRECT_HTTP_REMOTE_HOST 44.201.64.238
REDIRECT_HTTP_USER_AGENT claudebot
REDIRECT_HTTP_X_FORWARDED_FOR 44.201.64.238
REDIRECT_HTTP_X_REAL_IP 44.201.64.238
REDIRECT_PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO /page/index/id/24.html
REDIRECT_PATH_TRANSLATED redirect:/index.php/page/index/id/24.html/index/id/24.html
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR 10.0.6.240
REDIRECT_REMOTE_PORT 41264
REDIRECT_REQUEST_METHOD GET
REDIRECT_REQUEST_URI /home/page/index/id/24.html
REDIRECT_SCRIPT_FILENAME /usr/home/qxu1099440017/htdocs/home
REDIRECT_SCRIPT_NAME /home
REDIRECT_SERVER_ADDR 10.0.6.249
REDIRECT_SERVER_ADMIN webmaster@qxu1099440017.my3w.com
REDIRECT_SERVER_NAME www.guanggaow.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 ZgU0ZgoABvkACnByvwwAAAAD
REDIRECT_URL /home/page/index/id/24.html
REMOTE_ADDR 10.0.6.240
REMOTE_PORT 41264
REQUEST_METHOD GET
REQUEST_URI /home/page/index/id/24.html
SCRIPT_FILENAME /usr/home/qxu1099440017/htdocs/index.php
SCRIPT_NAME /index.php
SERVER_ADDR 10.0.6.249
SERVER_ADMIN webmaster@qxu1099440017.my3w.com
SERVER_NAME www.guanggaow.com
SERVER_PORT 80
SERVER_PROTOCOL HTTP/1.0
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
TZ Asia/Shanghai
UNIQUE_ID ZgU0ZgoABvkACnByvwwAAAAD
ORIG_PATH_INFO /home/page/index/id/24.html
ORIG_PATH_TRANSLATED /usr/home/qxu1099440017/htdocs/index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711617126.044
REQUEST_TIME 1711617126
PATH_INFO /home/page/index/id/24.html
Environment Variablesempty
ThinkPHP Constants
APP_PATH /usr/home/qxu1099440017/htdocs/xdnet/
TOP_DOMAIN www.guanggaow.com
CMS_VERSION XDCMS 0.8.5
THINK_VERSION 5.0.3
THINK_START_TIME 1711617126.0447
THINK_START_MEM 279360
EXT .php
DS /
THINK_PATH /usr/home/qxu1099440017/htdocs/thinkphp/
LIB_PATH /usr/home/qxu1099440017/htdocs/thinkphp/library/
CORE_PATH /usr/home/qxu1099440017/htdocs/thinkphp/library/think/
TRAIT_PATH /usr/home/qxu1099440017/htdocs/thinkphp/library/traits/
ROOT_PATH /usr/home/qxu1099440017/htdocs/
EXTEND_PATH /usr/home/qxu1099440017/htdocs/extend/
VENDOR_PATH /usr/home/qxu1099440017/htdocs/vendor/
RUNTIME_PATH /usr/home/qxu1099440017/htdocs/xdnet/runtime/
LOG_PATH /usr/home/qxu1099440017/htdocs/xdnet/runtime/log/
CACHE_PATH /usr/home/qxu1099440017/htdocs/xdnet/runtime/cache/
TEMP_PATH /usr/home/qxu1099440017/htdocs/xdnet/runtime/temp/
CONF_PATH /usr/home/qxu1099440017/htdocs/xdnet/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN false
GROUP_NAME home
MODULE_NAME Page
ACTION_NAME index
TIME_OUT_SHOW_INFO