304am永利集团(中国)有限公司-百度百科

[10501] PDOException in Connection.php line 385

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where 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('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 255
  3. at Query->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 2470
  4. at Query->getPdo() in Query.php line 441
  5. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 576
  6. at Query->aggregate('COUNT', '*', true) in Query.php line 551
  7. at Query->count() in Query.php line 1484
  8. at Query->paginate(16, false, ['type' => 'bootstrap', 'var_page' => 'page', 'list_rows' => 15, ...]) in Index.php line 101
  9. at Index->product()
  10. at call_user_func_array([object(Index), 'product'], []) in Route.php line 78
  11. at Route->execute('wwh', 'index', 'product')
  12. at ReflectionMethod->invokeArgs(object(Route), ['wwh', 'index', 'product']) in App.php line 343
  13. at App::invokeMethod(['\think\addons\Route', 'execute'], ['/product/page/2' => '', 'id' => 'page', 'addon' => 'wwh', ...]) in App.php line 470
  14. at App::exec(['type' => 'method', 'method' => ['\think\addons\Route', 'execute'], 'var' => ['addon' => 'wwh', 'controller' => 'index', 'action' => 'product']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  15. at App::run() in start.php line 19
  16. at require('E:\bjhuacan\Apache24...') in index.php line 23

Exception Datas

PDO Error Info
SQLSTATE 42S22
Driver Error Code 1054
Driver Error Message Unknown column 'page' in 'where clause'
Database Status
Error Code 10501
Error Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where clause'
Error SQL SELECT COUNT(*) AS tp_count FROM `fa_wwh_product` WHERE ( find_in_set(page, `pids`) ) LIMIT 1
Database Config
type mysql
hostname 114.215.26.141
database huacan_maoln_com
hostport 3306
dsn
params []
charset utf8mb4
prefix fa_
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

/product/page/2
POST Data
empty
Files
empty

Cookies

think_var
1
Session
empty

Server/Request Data

REDIRECT_STATUS
200
HTTP_USER_AGENT
Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)
HTTP_HOST
www.bjhuacan.cn
HTTP_ACCEPT
*/*
HTTP_ACCEPT_ENCODING
gzip
HTTP_COOKIE
think_var=1
PATH
C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;E:\DB\mongodb\bin;C:\Program Files\dotnet\;C:\Program Files (x86)\dotnet\;F:\apache-tomcat-7.0.94\lib;F:\apache-tomcat-7.0.94\bin;F:\Program Files\Java\jdk1.8.0_211\bin;F:\Program Files\Java\jdk1.8.0_211\jre\bin;C:\Program Files\Git\cmd;E:\Program Files\VisualSVN Server\bin;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;
SystemRoot
C:\Windows
COMSPEC
C:\Windows\system32\cmd.exe
PATHEXT
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR
C:\Windows
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache/2.4.54 (Win64) PHP/7.2.0
SERVER_NAME
www.bjhuacan.cn
SERVER_ADDR
114.215.26.141
SERVER_PORT
80
REMOTE_ADDR
23.27.102.30
DOCUMENT_ROOT
E:/bjhuacan/Apache24/htdocs/web/public
REQUEST_SCHEME
http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT
E:/bjhuacan/Apache24/htdocs/web/public
SERVER_ADMIN
admin@example.com
SCRIPT_FILENAME
E:/bjhuacan/Apache24/htdocs/web/public/index.php
REMOTE_PORT
49606
REDIRECT_URL
/product/page/2
REDIRECT_QUERY_STRING
/product/page/2
GATEWAY_INTERFACE
CGI/1.1
SERVER_PROTOCOL
HTTP/1.1
REQUEST_METHOD
GET
QUERY_STRING
/product/page/2
REQUEST_URI
/product/page/2
SCRIPT_NAME
/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1710222498.275
REQUEST_TIME
1710222498
PATH_INFO
/product/page/2
Environment Variables
empty

ThinkPHP Constants

APP_PATH
E:\bjhuacan\Apache24\htdocs\web\public/../application/
THINK_VERSION
5.0.24
THINK_START_TIME
1710222498.2786
THINK_START_MEM
409464
EXT
.php
DS
\
THINK_PATH
E:\bjhuacan\Apache24\htdocs\web\thinkphp\
LIB_PATH
E:\bjhuacan\Apache24\htdocs\web\thinkphp\library\
CORE_PATH
E:\bjhuacan\Apache24\htdocs\web\thinkphp\library\think\
TRAIT_PATH
E:\bjhuacan\Apache24\htdocs\web\thinkphp\library\traits\
ROOT_PATH
E:\bjhuacan\Apache24\htdocs\web\
EXTEND_PATH
E:\bjhuacan\Apache24\htdocs\web\extend\
VENDOR_PATH
E:\bjhuacan\Apache24\htdocs\web\vendor\
RUNTIME_PATH
E:\bjhuacan\Apache24\htdocs\web\runtime\
LOG_PATH
E:\bjhuacan\Apache24\htdocs\web\runtime\log\
CACHE_PATH
E:\bjhuacan\Apache24\htdocs\web\runtime\cache\
TEMP_PATH
E:\bjhuacan\Apache24\htdocs\web\runtime\temp\
CONF_PATH
E:\bjhuacan\Apache24\htdocs\web\public/../application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
true
FILTER_VALIDATE_BOOL
258
MB_CASE_UPPER
0
MB_CASE_LOWER
1
MB_CASE_TITLE
2
U_IDNA_PROHIBITED_ERROR
66560
U_IDNA_ERROR_START
66560
U_IDNA_UNASSIGNED_ERROR
66561
U_IDNA_CHECK_BIDI_ERROR
66562
U_IDNA_STD3_ASCII_RULES_ERROR
66563
U_IDNA_ACE_PREFIX_ERROR
66564
U_IDNA_VERIFICATION_ERROR
66565
U_IDNA_LABEL_TOO_LONG_ERROR
66566
U_IDNA_ZERO_LENGTH_LABEL_ERROR
66567
U_IDNA_DOMAIN_NAME_TOO_LONG_ERROR
66568
U_IDNA_ERROR_LIMIT
66569
U_STRINGPREP_PROHIBITED_ERROR
66560
U_STRINGPREP_UNASSIGNED_ERROR
66561
U_STRINGPREP_CHECK_BIDI_ERROR
66562
IDNA_DEFAULT
0
IDNA_ALLOW_UNASSIGNED
1
IDNA_USE_STD3_RULES
2
IDNA_CHECK_BIDI
4
IDNA_CHECK_CONTEXTJ
8
IDNA_NONTRANSITIONAL_TO_ASCII
16
IDNA_NONTRANSITIONAL_TO_UNICODE
32
INTL_IDNA_VARIANT_2003
0
INTL_IDNA_VARIANT_UTS46
1
IDNA_ERROR_EMPTY_LABEL
1
IDNA_ERROR_LABEL_TOO_LONG
2
IDNA_ERROR_DOMAIN_NAME_TOO_LONG
4
IDNA_ERROR_LEADING_HYPHEN
8
IDNA_ERROR_TRAILING_HYPHEN
16
IDNA_ERROR_HYPHEN_3_4
32
IDNA_ERROR_LEADING_COMBINING_MARK
64
IDNA_ERROR_DISALLOWED
128
IDNA_ERROR_PUNYCODE
256
IDNA_ERROR_LABEL_HAS_DOT
512
IDNA_ERROR_INVALID_ACE_LABEL
1024
IDNA_ERROR_BIDI
2048
IDNA_ERROR_CONTEXTJ
4096
ADDON_PATH
E:\bjhuacan\Apache24\htdocs\web\addons\
ThinkPHP V5.0.24 { 十年磨一剑-为API开发设计的高性能框架 }
Baidu
sogou