[10501] PDOException in Connection.php line 385

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

  1. $this->PDOStatement->execute();
  2. // 调试结束
  3. $this->debug(false, '', $master);
  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 (\Throwable $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. } catch (\Exception $e) {
  17. if ($this->isBreak($e)) {
  18. return $this->close()->query($sql, $bind, $master, $pdo);
  19. }

Call Stack

  1. in Connection.php line 385
  2. at Connection->query() in Query.php line 255
  3. at Query->query() in Query.php line 2523
  4. at Query->select() in Query.php line 1485
  5. at Query->paginate() in Search.php line 78
  6. at Search->index()
  7. at call_user_func_array() in Route.php line 78
  8. at Route->execute()
  9. at ReflectionMethod->invokeArgs() in App.php line 343
  10. at App::invokeMethod() in App.php line 470
  11. at App::exec() in App.php line 139
  12. at App::run() in start.php line 19
  13. at require('/www/wwwroot/www.gep...') in index.php line 23

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'createtime' in 'order clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'createtime' in 'order clause'
Error SQL SELECT * FROM `yb_market_service` WHERE ( `title` LIKE '%手机号登录%' OR `description` LIKE '%手机号登录%' ) ORDER BY `createtime` DESC LIMIT 0,12
Database Config
type mysql
hostname 47.103.139.223
database 24cod
hostport
dsn
params []
charset utf8mb4
prefix yb_
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 false
sql_explain false
builder
query \think\db\Query
break_reconnect false

Environment Variables

GET Data

q
手机号登录
orderby
createtime
orderway
desc
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

USER
www
HOME
/home/www
HTTP_HOST
gepardshop.com
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
PATH_INFO
/market/s.html
REDIRECT_STATUS
200
SERVER_NAME
gepardshop.com
SERVER_PORT
80
SERVER_ADDR
172.31.81.166
REMOTE_PORT
36080
REMOTE_ADDR
54.87.17.177
SERVER_SOFTWARE
nginx/1.18.0
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/www.gepardshop.com/public
DOCUMENT_URI
/index.php
REQUEST_URI
/market/s.html?q=%E6%89%8B%E6%9C%BA%E5%8F%B7%E7%99%BB%E5%BD%95&orderby=createtime&orderway=desc
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/market/s.html&q=%E6%89%8B%E6%9C%BA%E5%8F%B7%E7%99%BB%E5%BD%95&orderby=createtime&orderway=desc
SCRIPT_FILENAME
/www/wwwroot/www.gepardshop.com/public/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711653043.3718
REQUEST_TIME
1711653043
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/www/wwwroot/www.gepardshop.com/public/../application/
THINK_VERSION
5.0.24
THINK_START_TIME
1711653043.372
THINK_START_MEM
414536
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/www.gepardshop.com/thinkphp/
LIB_PATH
/www/wwwroot/www.gepardshop.com/thinkphp/library/
CORE_PATH
/www/wwwroot/www.gepardshop.com/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/www.gepardshop.com/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/www.gepardshop.com/
EXTEND_PATH
/www/wwwroot/www.gepardshop.com/extend/
VENDOR_PATH
/www/wwwroot/www.gepardshop.com/vendor/
RUNTIME_PATH
/www/wwwroot/www.gepardshop.com/runtime/
LOG_PATH
/www/wwwroot/www.gepardshop.com/runtime/log/
CACHE_PATH
/www/wwwroot/www.gepardshop.com/runtime/cache/
TEMP_PATH
/www/wwwroot/www.gepardshop.com/runtime/temp/
CONF_PATH
/www/wwwroot/www.gepardshop.com/public/../application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false
FILTER_VALIDATE_BOOL
258
ADDON_PATH
/www/wwwroot/www.gepardshop.com/addons/