错误语句:SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE ( `goods_name` LIKE :where_goods_name OR `keywords` LIKE '%华为%' ) AND `is_on_sale` = 1 LIMIT 1

[10501] PDOException in Connection.php line 391

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

  1. // 调试结束
  2. $this->debug(false);
  3. // 返回结果集
  4. return $this->getResult($pdo, $procedure);
  5. } catch (\PDOException $e) {
  6. if ($this->isBreak($e)) {
  7. return $this->close()->query($sql, $bind, $master, $pdo);
  8. }
  9. echo '错误语句:'. $sql;
  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. echo '错误语句:'. $sql;
  16. throw $e;
  17. } catch (\Exception $e) {
  18. if ($this->isBreak($e)) {
  19. return $this->close()->query($sql, $bind, $master, $pdo);

Call Stack

  1. in Connection.php line 391
  2. at Connection->query('SELECT COUNT(*) AS t...', ['where_goods_name' => ['%华为%', 2]], false, true) in Query.php line 227
  3. at Query->query('SELECT COUNT(*) AS t...', ['where_goods_name' => ['%华为%', 2]], false, true) in Query.php line 2291
  4. at Query->getPdo() in Query.php line 413
  5. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 519
  6. at Query->count() in Goods.php line 281
  7. at Goods->search()
  8. at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 346
  9. at App::invokeMethod([object(Goods), 'search'], []) in App.php line 612
  10. at App::module(['Home', 'Goods', 'search'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 459
  11. at App::exec(['type' => 'module', 'module' => ['Home', 'Goods', 'search']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 142
  12. at App::run() in start.php line 19
  13. at require('/wwwroot/data/www/a....') in index.php line 61

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'keywords' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'keywords' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE ( `goods_name` LIKE '%华为%' OR `keywords` LIKE '%华为%' ) AND `is_on_sale` = 1 LIMIT 1
Database Config
type mysql
hostname localhost
database fjsjgroup_com
hostport 3306
dsn
params []
charset utf8
prefix tp_
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

q
华为
POST Data
empty
Files
empty

Cookies

is_mobile
0
Session
empty

Server/Request Data

USER
www
HOME
/home/www
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
HTTP_HOST
ftkmall.com
PATH_INFO
/Home/Goods/search/q/%E5%8D%8E%E4%B8%BA
REDIRECT_STATUS
200
SERVER_NAME
a.ftkmall.com
SERVER_PORT
443
SERVER_ADDR
172.17.0.2
REMOTE_PORT
40994
REMOTE_ADDR
54.163.14.144
SERVER_SOFTWARE
nginx/1.22.1
GATEWAY_INTERFACE
CGI/1.1
HTTPS
on
REQUEST_SCHEME
https
SERVER_PROTOCOL
HTTP/2.0
DOCUMENT_ROOT
/wwwroot/data/www/a.ftkmall.com
DOCUMENT_URI
/index.php/Home/Goods/search/q/华为
REQUEST_URI
/index.php/Home/Goods/search/q/%E5%8D%8E%E4%B8%BA
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
SCRIPT_FILENAME
/wwwroot/data/www/a.ftkmall.com/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php/Home/Goods/search/q/%E5%8D%8E%E4%B8%BA
REQUEST_TIME_FLOAT
1711651826.0276
REQUEST_TIME
1711651826
Environment Variables
empty

ThinkPHP Constants

PLUGIN_PATH
/wwwroot/data/www/a.ftkmall.com/plugins/
UPLOAD_PATH
public/upload/
TPSHOP_CACHE_TIME
1
SITE_URL
https://ftkmall.com
INSTALL_DATE
1463741583
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/wwwroot/data/www/a.ftkmall.com/application/
NOW_TIME
1711651826
THINK_VERSION
5.0.15
THINK_START_TIME
1711651826.0281
THINK_START_MEM
393864
EXT
.php
DS
/
THINK_PATH
/wwwroot/data/www/a.ftkmall.com/thinkphp/
LIB_PATH
/wwwroot/data/www/a.ftkmall.com/thinkphp/library/
CORE_PATH
/wwwroot/data/www/a.ftkmall.com/thinkphp/library/think/
TRAIT_PATH
/wwwroot/data/www/a.ftkmall.com/thinkphp/library/traits/
ROOT_PATH
/wwwroot/data/www/a.ftkmall.com/
EXTEND_PATH
/wwwroot/data/www/a.ftkmall.com/extend/
VENDOR_PATH
/wwwroot/data/www/a.ftkmall.com/vendor/
RUNTIME_PATH
/wwwroot/data/www/a.ftkmall.com/runtime/
LOG_PATH
/wwwroot/data/www/a.ftkmall.com/runtime/log/
CACHE_PATH
/wwwroot/data/www/a.ftkmall.com/runtime/cache/
TEMP_PATH
/wwwroot/data/www/a.ftkmall.com/runtime/temp/
CONF_PATH
/wwwroot/data/www/a.ftkmall.com/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
EXTEND_MODULE
1
EXTEND_ANDROID
2
EXTEND_IOS
3
EXTEND_ENTRUST
4
EXTEND_MINIAPP
5
EXTEND_H5
6
TIME_MOUTH
4
IS_AJAX
false
IS_GET
true
IS_POST
false
MODULE_NAME
home
CONTROLLER_NAME
Goods
ACTION_NAME
search
PREFIX
tp_
SESSION_ID