[10501] PDOException in Connection.php line 388

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

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'brand' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'brand' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `yunu_content` `con` INNER JOIN `yunu_diy_producthongganji` `diy` ON `con`.`vid`=`diy`.`conid` WHERE `create_time` < 1711726457 AND ( `cid` IN (5) OR ( CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('5',',','|'),'),') ) ) AND ( ( `area` is NULL ) or `area` = '' or `area` = ',,' or `area` LIKE '%,88888888,%' ) AND ( ( 1 = 1 ) and ((brand LIKE '%高能效常温热水机%')) and ( 1 = 1 ) and ( 1 = 1 ) ) LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database oubite_foshannet
username oubite_foshannet
password wk4JK7hfXYJ3eSdZ
hostport 3306
dsn
params []
charset utf8
prefix yunu_
debug 0
deploy 0
rw_separate
master_num 1
slave_no
fields_strict 1
result_type 2
resultset_type array
auto_timestamp
datetime_format Y-m-d H:i:s
sql_explain
builder
query \think\db\Query
break_reconnect false