$this->PDOStatement->execute();
// 调试结束
$this->debug(false, '', $master);
// 返回结果集
return $this->getResult($pdo, $procedure);
} catch (\PDOException $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw new PDOException($e, $this->config, $this->getLastsql());
} catch (\Throwable $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw $e;
} catch (\Exception $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
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 ') ORDER BY `h`.`vieworder` ASC,`h`.`lasttime` DESC LIMIT 0,8' at line 1 |
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 ') ORDER BY `h`.`vieworder` ASC,`h`.`lasttime` DESC LIMIT 0,8' at line 1 |
Error SQL | SELECT `h`.*,c.name as city_name,t.name as type_name FROM `mo_house` `h` LEFT JOIN `mo_city` `c` ON `h`.`cityid`=`c`.`id` LEFT JOIN `mo_type` `t` ON `h`.`sales_type`=`t`.`id` WHERE ( h.id>0 and h.features regexp 33 and h.unit_price > ) ORDER BY `h`.`vieworder` ASC,`h`.`lasttime` DESC LIMIT 0,8 |
type | mysql |
hostname | 127.0.0.1 |
database | e5902_cn |
hostport | |
dsn | |
params | [] |
charset | utf8 |
prefix | mo_ |
debug | false |
deploy | 0 |
rw_separate | false |
master_num | 1 |
slave_no | |
read_master | false |
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 |