[10501] PDOException in Connection.php line 388

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hangye' 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 (\Exception $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. }
  17. }
  18. /**

Call Stack

  1. in Connection.php line 388
  2. at Connection->query('SELECT COUNT(*) c FR...')
  3. at call_user_func_array([object(Mysql), 'query'], ['SELECT COUNT(*) c FR...']) in Db.php line 154
  4. at Db::__callStatic('query', ['SELECT COUNT(*) c FR...']) in Data.php line 55
  5. at Data->list() in 37eb066e92518401ff106dea866dbb40.php line 349
  6. at include('/home/114110comt191s...') in File.php line 50
  7. at File->read('/home/114110comt191s...', ['page_module' => 'demand', 'page_action' => 'index', 'config' => ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], ...]) in Template.php line 197
  8. at Template->fetch('/home/114110comt191s...', ['page_module' => 'demand', 'page_action' => 'index', 'config' => ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], ...], []) in Think.php line 84
  9. at Think->fetch('/home/114110comt191s...', ['page_module' => 'demand', 'page_action' => 'index', 'config' => ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], ...], []) in View.php line 159
  10. at View->fetch('demand@index/index', ['page_module' => 'demand', 'page_action' => 'index', 'config' => ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], ...], [], []) in Controller.php line 112
  11. at Controller->fetch('demand@index/index') in Index.php line 43
  12. at Index->index()
  13. at ReflectionMethod->invokeArgs(object(Index), []) in App.php line 197
  14. at App::invokeMethod([object(Index), 'index'], []) in App.php line 415
  15. at App::module(['demand', 'index', 'index'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 296
  16. at App::exec(['type' => 'module', 'module' => ['demand', 'index', 'index']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 124
  17. at App::run() in start.php line 18
  18. at require('/home/114110comt191s...') in index.php line 20

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'hangye' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hangye' in 'where clause'
Error SQL SELECT COUNT(*) c FROM `yhc_demand` l WHERE 1 = 1 AND l.`state` = 1 AND l.`utype` = hangye AND l.`cityid` = 1
Database Config
type mysql
hostname 127.0.0.1
database 114110com
hostport
dsn
params []
charset utf8
prefix yhc_
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

yhc_cityinfo
{"id":1,"parentid":0,"typename":"\u5317\u4eac","weight":2,"pinyin":"beijing","level":1,"longitude":"116.395645","latitude":"39.929986","zxs":1}
Session
empty

Server/Request Data

USER
114110com
HOME
/home/114110comt191s4z141c01cboym
SCRIPT_NAME
/index.php
REQUEST_URI
/demand/index/index/utype/hangye/huodong
QUERY_STRING
REQUEST_METHOD
GET
SERVER_PROTOCOL
HTTP/1.1
GATEWAY_INTERFACE
CGI/1.1
REDIRECT_URL
/demand/index/index/utype/hangye/huodong
REMOTE_PORT
57000
SCRIPT_FILENAME
/home/114110comt191s4z141c01cboym/wwwroot/public/index.php
SERVER_ADMIN
webmaster@114110com
CONTEXT_DOCUMENT_ROOT
/home/114110comt191s4z141c01cboym/wwwroot/public
CONTEXT_PREFIX
REQUEST_SCHEME
http
DOCUMENT_ROOT
/home/114110comt191s4z141c01cboym/wwwroot/public
REMOTE_ADDR
107.21.137.184
SERVER_PORT
80
SERVER_ADDR
127.0.0.1
SERVER_NAME
114110.com
SERVER_SOFTWARE
Apache
SERVER_SIGNATURE
<address>Apache Server at 114110.com Port 80</address>
PATH
/sbin:/usr/sbin:/bin:/usr/bin
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
HTTP_CONNECTION
close
HTTP_HOST
114110.com
HTTP_X_REAL_IP
107.21.137.184
HTTP_X_FORWARDED_FOR
107.21.137.184
UNIQUE_ID
ZgaXu5NLo@rEJzN1USSyfwAAAAE
REDIRECT_STATUS
200
REDIRECT_UNIQUE_ID
ZgaXu5NLo@rEJzN1USSyfwAAAAE
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711708091.2726
REQUEST_TIME
1711708091
PATH_INFO
/demand/index/index/utype/hangye/huodong
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/home/114110comt191s4z141c01cboym/wwwroot/app/
ENTER_PATH
/home/114110comt191s4z141c01cboym/wwwroot/public/
INI_PATH
/home/114110comt191s4z141c01cboym/wwwroot/ini/
THINK_VERSION
5.0.11
THINK_START_TIME
1711708091.2729
THINK_START_MEM
359360
EXT
.php
DS
/
THINK_PATH
/home/114110comt191s4z141c01cboym/wwwroot/thinkphp/
LIB_PATH
/home/114110comt191s4z141c01cboym/wwwroot/thinkphp/library/
CORE_PATH
/home/114110comt191s4z141c01cboym/wwwroot/thinkphp/library/think/
TRAIT_PATH
/home/114110comt191s4z141c01cboym/wwwroot/thinkphp/library/traits/
ROOT_PATH
/home/114110comt191s4z141c01cboym/wwwroot/
EXTEND_PATH
/home/114110comt191s4z141c01cboym/wwwroot/extend/
VENDOR_PATH
/home/114110comt191s4z141c01cboym/wwwroot/vendor/
RUNTIME_PATH
/home/114110comt191s4z141c01cboym/wwwroot/runtime/
LOG_PATH
/home/114110comt191s4z141c01cboym/wwwroot/runtime/log/
CACHE_PATH
/home/114110comt191s4z141c01cboym/wwwroot/runtime/cache/
TEMP_PATH
/home/114110comt191s4z141c01cboym/wwwroot/runtime/temp/
CONF_PATH
/home/114110comt191s4z141c01cboym/wwwroot/app/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
FURL
IS_MOBILE
false