[10501] PDOException in Connection.php line 687

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bdm68232632_db.jr_add' doesn't exist

  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 `a`.`id`,`a`....', ['ThinkBind_1_422718395_' => ['120', 2]], false, false) in Connection.php line 844
  3. at Connection->find(object(Query)) in Query.php line 3152
  4. at Query->find() in Archives.php line 17
  5. at Archives->query('120') in View.php line 28
  6. at View->index()
  7. at ReflectionMethod->invokeArgs(object(View), []) in Container.php line 395
  8. at Container->invokeReflectMethod(object(View), object(ReflectionMethod), ['tid' => '45', 'id' => '120', 'convert' => false]) in Module.php line 131
  9. at Module->think\route\dispatch\{closure}(object(Request), object(Closure), null)
  10. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  11. at Middleware->think\{closure}(object(Request))
  12. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  13. at Middleware->dispatch(object(Request), 'controller') in Module.php line 136
  14. at Module->exec() in Dispatch.php line 168
  15. at Dispatch->run() in App.php line 432
  16. at App->think\{closure}(object(Request), object(Closure), null)
  17. at call_user_func_array(object(Closure), [object(Request), object(Closure), null]) in Middleware.php line 185
  18. at Middleware->think\{closure}(object(Request))
  19. at call_user_func(object(Closure), object(Request)) in Middleware.php line 130
  20. at Middleware->dispatch(object(Request)) in App.php line 435
  21. at App->run() in index.php line 4

Exception Datas

PDO Error Info
SQLSTATE 42S02
Driver Error Code 1146
Driver Error Message Table 'bdm68232632_db.jr_add' doesn't exist
Database Status
Error Code 10501
Error Message SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bdm68232632_db.jr_add' doesn't exist
Error SQL SELECT `a`.`id`,`a`.`typeid`,`a`.`title`,`a`.`click`,`a`.`writer`,`a`.`shorttitle`,`a`.`pic`,`a`.`pubdate`,`a`.`senddate`,`a`.`state`,`a`.`sort`,`a`.`keywords`,`a`.`description`,`a`.`templates`,t.id as tid,`t`.`typename`,`t`.`typenameen`,`t`.`typeimg`,`t`.`typeurl`,`t`.`channeltype`,`add`.* FROM `jr_archives` `a` LEFT JOIN `jr_arctype` `t` ON `a`.`typeid`=`t`.`id` LEFT JOIN `jr_add` `add` ON `a`.`id`=`add`.`aid` WHERE `a`.`id` = '120' LIMIT 1
Database Config
type mysql
hostname bdm68232632.my3w.com
database bdm68232632_db
hostport 3306
dsn
params []
charset utf8
prefix jr_
debug false
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
DOCUMENT_ROOT /usr/home/wh-abj0mhfduytecwpnmce/htdocs
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT */*
HTTP_CONNECTION close
HTTP_HOST sqcnc.cn
HTTP_REMOTE_HOST 100.26.140.179
HTTP_USER_AGENT claudebot
HTTP_X_FORWARDED_FOR 100.26.140.179
HTTP_X_FORWARDED_PROTO http
HTTP_X_REAL_IP 100.26.140.179
PATH /bin
PHPRC /var/www/php56/hichina_ini/wh-abj0mhfduytecwpnmce
QUERY_STRING
REDIRECT_DOCUMENT_ROOT /usr/home/wh-abj0mhfduytecwpnmce/htdocs
REDIRECT_GATEWAY_INTERFACE CGI/1.1
REDIRECT_HTTP_ACCEPT */*
REDIRECT_HTTP_CONNECTION close
REDIRECT_HTTP_HOST sqcnc.cn
REDIRECT_HTTP_REMOTE_HOST 100.26.140.179
REDIRECT_HTTP_USER_AGENT claudebot
REDIRECT_HTTP_X_FORWARDED_FOR 100.26.140.179
REDIRECT_HTTP_X_FORWARDED_PROTO http
REDIRECT_HTTP_X_REAL_IP 100.26.140.179
REDIRECT_PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
REDIRECT_PATH_INFO products/sanqiangCCDxunbianji_CNCyixingdiaokeji_/s/120.html
REDIRECT_PATH_TRANSLATED redirect:/index.php/s/120.html
REDIRECT_QUERY_STRING
REDIRECT_REMOTE_ADDR 10.0.16.210
REDIRECT_REMOTE_PORT 42146
REDIRECT_REQUEST_METHOD GET
REDIRECT_REQUEST_URI /products/sanqiangCCDxunbianji_CNCyixingdiaokeji_/s/120.html
REDIRECT_SCRIPT_FILENAME /usr/home/wh-abj0mhfduytecwpnmce/htdocs/products
REDIRECT_SCRIPT_NAME /products
REDIRECT_SERVER_ADDR 10.0.16.240
REDIRECT_SERVER_ADMIN webmaster@wh-abj0mhfduytecwpnmce.my3w.com
REDIRECT_SERVER_NAME sqcnc.cn
REDIRECT_SERVER_PORT 80
REDIRECT_SERVER_PROTOCOL HTTP/1.0
REDIRECT_SERVER_SIGNATURE
REDIRECT_SERVER_SOFTWARE Apache
REDIRECT_STATUS 200
REDIRECT_TZ Asia/Shanghai
REDIRECT_UNIQUE_ID ZgWLygoAEPAAJDBc-0EAAAAF
REDIRECT_URL /products/sanqiangCCDxunbianji_CNCyixingdiaokeji_/s/120.html
REMOTE_ADDR 10.0.16.210
REMOTE_PORT 42146
REQUEST_METHOD GET
REQUEST_URI /products/sanqiangCCDxunbianji_CNCyixingdiaokeji_/s/120.html
SCRIPT_FILENAME /usr/home/wh-abj0mhfduytecwpnmce/htdocs/index.php
SCRIPT_NAME /index.php
SERVER_ADDR 10.0.16.240
SERVER_ADMIN webmaster@wh-abj0mhfduytecwpnmce.my3w.com
SERVER_NAME sqcnc.cn
SERVER_PORT 80
SERVER_PROTOCOL HTTP/1.0
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
TZ Asia/Shanghai
UNIQUE_ID ZgWLygoAEPAAJDBc-0EAAAAF
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711639498.7269
REQUEST_TIME 1711639498
Environment Variablesempty
ThinkPHP Constants
DS /
__APP_PATH__ /usr/home/wh-abj0mhfduytecwpnmce/htdocs/app/
__ROOT_PATH__ /usr/home/wh-abj0mhfduytecwpnmce/htdocs/
__CONFIG_PATH__ /usr/home/wh-abj0mhfduytecwpnmce/htdocs/core/config/
__RUNTIME_PATH__ /usr/home/wh-abj0mhfduytecwpnmce/htdocs/core/runtime/