[10501] PDOException in Connection.php line 700

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'desc' in 'order clause'

  1. $this->debug(false);
  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 700
  2. at Connection->query('SELECT `id`,`title` ...', [], false, false) in Connection.php line 938
  3. at Connection->select(object(Query)) in Query.php line 2686
  4. at Query->select() in Article.php line 212
  5. at Article->cnarticledetail()
  6. at ReflectionMethod->invokeArgs(object(Article), []) in Container.php line 285
  7. at Container->invokeReflectMethod(object(Article), object(ReflectionMethod), ['id' => '112']) in Module.php line 133
  8. at Module->run() in App.php line 377
  9. at App->think\{closure}(object(Request), object(Closure), null)
  10. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 105
  11. at Middleware->think\{closure}(object(Request))
  12. at call_user_func(object(Closure), object(Request)) in Middleware.php line 66
  13. at Middleware->dispatch(object(Request)) in App.php line 398
  14. at App->run() in index.php line 24

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'desc' in 'order clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'desc' in 'order clause'
Error SQL SELECT `id`,`title` FROM `ko_theory_articles` ORDER BY `desc`
Database Config
type mysql
hostname rm-bp15a92zu759q8hzo9o.mysql.rds.aliyuncs.com
database literature_read
hostport 3306
dsn
params []
charset utf8mb4
prefix ko_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
resultset_type collection
auto_timestamp false
datetime_format Y-m-d H:i:s
sql_explain false
builder
query \think\db\Query
break_reconnect false
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Session
think_ { "start": "1" }
Server/Request Data
USER www
HOME /home/www
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
HTTP_HOST www.puppyreading.com
PATH_INFO //zixun/112.html
REDIRECT_STATUS 200
SERVER_NAME www.puppyreading.com
SERVER_PORT 443
SERVER_ADDR 172.16.115.50
REMOTE_PORT 34936
REMOTE_ADDR 3.85.211.2
SERVER_SOFTWARE nginx/1.22.0
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/2.0
DOCUMENT_ROOT /data/www_puppyreading_com
DOCUMENT_URI /index.php
REQUEST_URI /zixun/112.html
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=//zixun/112.html
SCRIPT_FILENAME /data/www_puppyreading_com/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711654581.464
REQUEST_TIME 1711654581
Environment Variablesempty
ThinkPHP Constants
ENTR_PATH
ROOT_PATH /data/www_puppyreading_com/
DS /
APP_PATH /data/www_puppyreading_com/application/
ADDON_PATH /data/www_puppyreading_com/addons/
MINIAPP_PATH /data/www_puppyreading_com/miniapp/
ADDON_ROUTE /app/
EXTEND_PATH /data/www_puppyreading_com/extend/
MODULE_NAME compile
CONTROLLER_NAME article
ACTION_NAME cnarticledetail
UID
OPENID