[10501] PDOException in Connection.php line 687

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gt' 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 * FROM `cmf_p...', ['ThinkBind_1_' => ['gt', 1]], false, false) in Connection.php line 844
  3. at Connection->find(object(Query)) in Query.php line 3131
  4. at Query->find() in AnliController.php line 24
  5. at AnliController->show()
  6. at ReflectionMethod->invokeArgs(object(AnliController), []) in Container.php line 395
  7. at Container->invokeReflectMethod(object(AnliController), object(ReflectionMethod), ['id' => '1']) 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 29

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'gt' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gt' in 'where clause'
Error SQL SELECT * FROM `cmf_pc_anli` WHERE `list_order` = gt ORDER BY `list_order` ASC LIMIT 1
Database Config
type mysql
hostname 127.0.0.1
database ciila
hostport 3306
dsn
params []
charset utf8mb4
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 zw9VqrQ4MTd8x6KsAL

Environment Variables

GET Data
id 1
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_HOST ciila.com
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME www.ciila.com
SERVER_PORT 80
SERVER_ADDR 172.17.116.49
REMOTE_PORT 59128
REMOTE_ADDR 3.88.60.5
SERVER_SOFTWARE nginx/1.15.9
GATEWAY_INTERFACE CGI/1.1
REQUEST_SCHEME http
SERVER_PROTOCOL HTTP/1.1
DOCUMENT_ROOT /www/wwwroot/www.ciila.com/public
DOCUMENT_URI /index.php
REQUEST_URI /index/anli/show?id=1
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=//index/anli/show&id=1
SCRIPT_FILENAME /www/wwwroot/www.ciila.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711631795.6288
REQUEST_TIME 1711631795
Environment Variablesempty
ThinkPHP Constants
APP_DEBUG true
CMF_ROOT /www/wwwroot/www.ciila.com/
APP_PATH /www/wwwroot/www.ciila.com/app/
WEB_ROOT /www/wwwroot/www.ciila.com/public/
HTMLPURIFIER_PREFIX /www/wwwroot/www.ciila.com/vendor/ezyang/htmlpurifier/library