[10501] PDOException in Connection.php line 687

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

  1. $this->debug(false, '', $master);
  2. // 返回结果集
  3. return $this->getResult($pdo, $procedure);
  4. } catch (\PDOException $e) {
  5. if ($this->isBreak($e)) {
  6. return $this->close()->query($sql, $bind, $master, $pdo);
  7. }
  8. throw new PDOException($e, $this->config, $this->getLastsql());
  9. } catch (\Throwable $e) {
  10. if ($this->isBreak($e)) {
  11. return $this->close()->query($sql, $bind, $master, $pdo);
  12. }
  13. throw $e;
  14. } catch (\Exception $e) {
  15. if ($this->isBreak($e)) {
  16. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 687
  2. at Connection->query('SELECT `name` FROM `...', ['ThinkBind_1_' => ['mall-xq', 1]], false, true) in Connection.php line 1299
  3. at Connection->value(object(Query), 'name', null) in Query.php line 594
  4. at Query->value('name') in IndexController.php line 109
  5. at IndexController->search()
  6. at ReflectionMethod->invokeArgs(object(IndexController), []) in Container.php line 395
  7. at Container->invokeReflectMethod(object(IndexController), object(ReflectionMethod), ['pid' => 'mall-xq']) in Module.php line 132
  8. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  9. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  10. at Middleware->think\{closure}(object(Request))
  11. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  12. at Middleware->dispatch(object(Request), 'controller') in Module.php line 137
  13. at Module->exec() in Dispatch.php line 168
  14. at Dispatch->run() in App.php line 475
  15. at App->think\{closure}(object(Request), object(Closure), null)
  16. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  17. at Middleware->think\{closure}(object(Request))
  18. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  19. at Middleware->dispatch(object(Request)) in App.php line 478
  20. at App->run() in index.php line 22

Exception Datas

PDO Error Info
SQLSTATE
42S22
Driver Error Code
1054
Driver Error Message
Unknown column 'mall' in 'where clause'
Database Status
Error Code
10501
Error Message
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mall' in 'where clause'
Error SQL
SELECT `name` FROM `cmf_goods_category` WHERE `id` = mall-xq LIMIT 1
Database Config
type
mysql
hostname
127.0.0.1
database
hnjhjsj_shop
hostport
3306
dsn
params
[]
charset
utf8
prefix
cmf_
debug
true
deploy
0
rw_separate
false
master_num
1
slave_no
read_master
false
fields_strict
true
resultset_type
collection
auto_timestamp
false
datetime_format
false
sql_explain
true
builder
query
\think\db\Query
break_reconnect
false
break_match_str
[]
authcode
UUX8MSAOAE3WRIudMA

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER
www
HOME
/home/www
FCGI_ROLE
RESPONDER
REDIRECT_STATUS
200
proxy-nokeepalive
1
HTTP_USER_AGENT
Mozilla/5.0+(compatible;+Baiduspider/2.0;++http://www.baidu.com/search/spider.html)
HTTP_HOST
hnjhjsj.com
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
deflate, gzip
PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
LD_LIBRARY_PATH
/www/server/apache/lib
SERVER_SIGNATURE
<address>Apache Server at hnjhjsj.com Port 80</address>
SERVER_SOFTWARE
Apache
SERVER_NAME
hnjhjsj.com
SERVER_ADDR
172.31.223.173
SERVER_PORT
80
REMOTE_ADDR
154.209.152.112
DOCUMENT_ROOT
/www/wwwroot/www.hnjhjsj.com/public
REQUEST_SCHEME
http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT
/www/wwwroot/www.hnjhjsj.com/public
SERVER_ADMIN
webmaster@example.com
SCRIPT_FILENAME
/www/wwwroot/www.hnjhjsj.com/public/index.php
REMOTE_PORT
20000
REDIRECT_URL
/portal/index/search/pid/mall-xq.html
REDIRECT_QUERY_STRING
s=portal/index/search/pid/mall-xq.html
GATEWAY_INTERFACE
CGI/1.1
SERVER_PROTOCOL
HTTP/1.1
REQUEST_METHOD
GET
QUERY_STRING
s=portal/index/search/pid/mall-xq.html
REQUEST_URI
/portal/index/search/pid/mall-xq.html
SCRIPT_NAME
/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1603835190.5626
REQUEST_TIME
1603835190
Environment Variablesempty
ThinkPHP Constants
APP_DEBUG
true
CMF_ROOT
/www/wwwroot/www.hnjhjsj.com/
APP_PATH
/www/wwwroot/www.hnjhjsj.com/app/
WEB_ROOT
/www/wwwroot/www.hnjhjsj.com/public/
HTMLPURIFIER_PREFIX
/www/wwwroot/www.hnjhjsj.com/vendor/ezyang/htmlpurifier/library
0.176711s