[10501] PDOException in Connection.php line 362

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2boschhome' in 'where clause'

  1. // 参数绑定
  2. $this->bindValue($bind);
  3. // 执行查询
  4. $result = $this->PDOStatement->execute();
  5. // 调试结束
  6. $this->debug(false);
  7. $procedure = in_array(strtolower(substr(trim($sql), 0, 4)), ['call', 'exec']);
  8. return $this->getResult($class, $procedure);
  9. } catch (\PDOException $e) {
  10. throw new PDOException($e, $this->config, $this->queryStr);
  11. }
  12. }
  13. /**
  14. * 执行语句
  15. * @access public
  16. * @param string $sql sql指令
  17. * @param array $bind 参数绑定
  18. * @return int

Call Stack

  1. in Connection.php line 362
  2. at Connection->query('SELECT `slug`,`id`,`...', [], false, false) in Query.php line 191
  3. at Query->query('SELECT `slug`,`id`,`...', [], false, false) in Query.php line 1992
  4. at Query->find() in Detail.php line 41
  5. at Detail->index()
  6. at ReflectionMethod->invokeArgs(object(Detail), []) in App.php line 229
  7. at App::invokeMethod([object(Detail), 'index']) in App.php line 386
  8. at App::module([null, 'Detail', 'index'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => true, ...], false) in App.php line 137
  9. at App::run() in start.php line 18
  10. at require('/home/manuala/public...') in index.php line 26

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column '2boschhome' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column '2boschhome' in 'where clause'
Error SQL SELECT `slug`,`id`,`brand_id`,`product_id`,`model_id`,`current_url`,`type_id`,`suffix`,`size`,`page`,`relate_id`,`html_id`,`sub_info` FROM `mg_detail` WHERE ( brand_id = 104 and model_id = 1100402 and type_id = 30 and suffix = 2boschhome ) LIMIT 1
Database Config
type mysql
hostname localhost
database manuala_agent
username manuala_db
password DB31415926535
hostport 3306
dsn
params []
charset utf8
prefix mg_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
fields_strict true
resultset_type array
auto_timestamp false
sql_explain false
builder
query \think\db\Query

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
TZ US/Pacific
REDIRECT_REDIRECT_UNIQUE_ID ZgWzhkVmGx0hDkyAHIaZWgAAAAs
REDIRECT_REDIRECT_SCRIPT_URL /boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
REDIRECT_REDIRECT_SCRIPT_URI http://www.manualagent.com/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
REDIRECT_REDIRECT_STATUS 200
REDIRECT_UNIQUE_ID ZgWzhkVmGx0hDkyAHIaZWgAAAAs
REDIRECT_SCRIPT_URL /boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
REDIRECT_SCRIPT_URI http://www.manualagent.com/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
REDIRECT_HANDLER application/x-httpd-ea-php56
REDIRECT_STATUS 200
UNIQUE_ID ZgWzhkVmGx0hDkyAHIaZWgAAAAs
SCRIPT_URL /boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
SCRIPT_URI http://www.manualagent.com/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
HTTP_HOST www.manualagent.com
HTTP_CONNECTION Keep-Alive
HTTP_ACCEPT_ENCODING gzip, br
HTTP_X_FORWARDED_FOR 34.230.68.214
HTTP_CF_RAY 86b999ad7cee8847-IAD
HTTP_X_FORWARDED_PROTO https
HTTP_CF_VISITOR {"scheme":"https"}
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_CF_CONNECTING_IP 34.230.68.214
HTTP_CDN_LOOP cloudflare
HTTP_CF_IPCOUNTRY US
PATH /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
SERVER_SIGNATURE
SERVER_SOFTWARE Apache
SERVER_NAME www.manualagent.com
SERVER_ADDR 45.33.80.25
SERVER_PORT 80
REMOTE_ADDR 172.70.42.84
DOCUMENT_ROOT /home/manuala/public_html
REQUEST_SCHEME http
CONTEXT_PREFIX /cgi-sys
CONTEXT_DOCUMENT_ROOT /usr/local/cpanel/cgi-sys/
SERVER_ADMIN webmaster@manualagent.com
SCRIPT_FILENAME /home/manuala/public_html/index.php
REMOTE_PORT 32108
REDIRECT_URL /index.php/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
SCRIPT_NAME /index.php
PATH_INFO /boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
PATH_TRANSLATED /home/manuala/public_html/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
ORIG_PATH_INFO /index.php/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
ORIG_SCRIPT_NAME /cgi-sys/ea-php56
ORIG_SCRIPT_FILENAME /usr/local/cpanel/cgi-sys/ea-php56
ORIG_PATH_TRANSLATED /home/manuala/public_html/index.php/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
PHP_SELF /index.php/boschhome/300series-stainlesssteel/instruction-manual-2boschhome/300series-stainlesssteel/instruction-manual-2/page-43
REQUEST_TIME_FLOAT 1711649670.4361
REQUEST_TIME 1711649670
argv []
argc 0
Environment Variablesempty
ThinkPHP Constants
APP_PATH /home/manuala/public_html/application/
WEB_URL
THINK_VERSION 5.0.2dev
THINK_START_TIME 1711649670.4366
THINK_START_MEM 249288
EXT .php
DS /
THINK_PATH /home/manuala/public_html/thinkphp/
LIB_PATH /home/manuala/public_html/thinkphp/library/
CORE_PATH /home/manuala/public_html/thinkphp/library/think/
TRAIT_PATH /home/manuala/public_html/thinkphp/library/traits/
ROOT_PATH /home/manuala/public_html/
EXTEND_PATH /home/manuala/public_html/extend/
VENDOR_PATH /home/manuala/public_html/vendor/
RUNTIME_PATH /home/manuala/public_html/runtime/
LOG_PATH /home/manuala/public_html/runtime/log/
CACHE_PATH /home/manuala/public_html/runtime/cache/
TEMP_PATH /home/manuala/public_html/runtime/temp/
CONF_PATH /home/manuala/public_html/application/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN false
0.142662s