[10501] PDOException in Connection.php line 687

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type2' in 'field list'

  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 `id`,`title`,...', ['ThinkBind_1_150525938_' => [1, 1], 'ThinkBind_2_1195118574_' => [50, 1]], false, false) in Connection.php line 923
  3. at Connection->select(object(Query)) in Query.php line 3028
  4. at Query->select() in Query.php line 1805
  5. at Query->paginate(8, false, ['type' => 'bootstrap', 'var_page' => 'page', 'list_rows' => 15, ...]) in Reagentclinical.php line 41
  6. at Reagentclinical->getPageList(['catid' => 50]) in Index.php line 347
  7. at Index->reagent_food()
  8. at ReflectionMethod->invokeArgs(object(Index), []) in Container.php line 395
  9. at Container->invokeReflectMethod(object(Index), object(ReflectionMethod), []) in Module.php line 131
  10. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  11. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  12. at Middleware->think\{closure}(object(Request))
  13. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  14. at Middleware->dispatch(object(Request), 'controller') in Module.php line 136
  15. at Module->exec() in Dispatch.php line 208
  16. at Dispatch->run() in App.php line 432
  17. at App->think\{closure}(object(Request), object(Closure), null)
  18. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  19. at Middleware->think\{closure}(object(Request))
  20. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  21. at Middleware->dispatch(object(Request)) in App.php line 435
  22. at App->run() in index.php line 35

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'type2' in 'field list'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type2' in 'field list'
Error SQL SELECT `id`,`title`,`test_method`,`thumb`,`type2`,`workflow`,`technical` FROM `yzn_reagentclinical` WHERE `status` = 1 AND `catid` = 50 ORDER BY `listorder`,`id` LIMIT 0,8
Database Config
type mysql
hostname 127.0.0.1
database coyotebio_com
hostport
dsn
params []
charset utf8
prefix yzn_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
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
break_match_str []

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
HTTP_HOST coyotebio.com
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME coyotebio.com
SERVER_PORT 443
SERVER_ADDR 172.24.182.66
REMOTE_PORT 52848
REMOTE_ADDR 18.206.83.160
SERVER_SOFTWARE nginx/1.20.2
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/2.0
DOCUMENT_ROOT /www/wwwroot/coyotebio.com/public
DOCUMENT_URI /index.php
REQUEST_URI /reagent_food.html
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/reagent_food.html
SCRIPT_FILENAME /www/wwwroot/coyotebio.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711692695.9978
REQUEST_TIME 1711692695
Environment Variablesempty
ThinkPHP Constants
IF_PUBLIC true
ROOT_PATH /www/wwwroot/coyotebio.com/public/../
APP_PATH /www/wwwroot/coyotebio.com/public/../application/
DS /
ADDON_PATH /www/wwwroot/coyotebio.com/public/../addons/
ROOT_URL /
TEMPLATE_PATH /www/wwwroot/coyotebio.com/public/../templates/
PINYIN_DEFAULT 4096
PINYIN_TONE 2
PINYIN_NO_TONE 4
PINYIN_ASCII_TONE 8
PINYIN_NAME 16
PINYIN_KEEP_NUMBER 32
PINYIN_KEEP_ENGLISH 64
PINYIN_UMLAUT_V 128
PINYIN_KEEP_PUNCTUATION 256