[10501] PDOException in Connection.php line 388

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'L' in boolean mode) ) ORDER BY id desc LIMIT 10' at line 1

  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 42000
Driver Error Code 1064
Driver Error Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'L' in boolean mode) ) ORDER BY id desc LIMIT 10' at line 1
Database Status
Error Code 10501
Error Message SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'L' in boolean mode) ) ORDER BY id desc LIMIT 10' at line 1
Error SQL SELECT * FROM `gppz_stock` WHERE ( MATCH(title) AGAINST('QPL INT'L' in boolean mode) ) ORDER BY id desc LIMIT 10
Database Config
type mysql
hostname 127.0.0.1
database www_xj_xry_com
username www_xj_xry_com
password DJiWpJM4yP8fCbxz
hostport 3306
dsn
params []
charset utf8
prefix gppz_
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