错误语句:SELECT * FROM `tp_goods` WHERE `goods_id` IN (:where_goods_id_in_1,:where_goods_id_in_2,:where_goods_id_in_3,:where_goods_id_in_4,:where_goods_id_in_5,:where_goods_id_in_6,:where_goods_id_in_7,:where_goods_id_in_8,:where_goods_id_in_9,:where_goods_id_in_10,:where_goods_id_in_11,:where_goods_id_in_12,:where_goods_id_in_13,:where_goods_id_in_14,:where_goods_id_in_15,:where_goods_id_in_16,:where_goods_id_in_17,:where_goods_id_in_18,:where_goods_id_in_19) ORDER BY `comment_` desc LIMIT 0,20
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comment_' in 'order clause'
// 调试结束
$this->debug(false);
// 返回结果集
return $this->getResult($pdo, $procedure);
} catch (\PDOException $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
echo '错误语句:'. $sql;
throw new PDOException($e, $this->config, $this->getLastsql());
} catch (\Throwable $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
echo '错误语句:'. $sql;
throw $e;
} catch (\Exception $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
Call Stack
- in Connection.php line 391
-
at Connection->query('SELECT * FROM `tp_go...', ['where_goods_id_in_1' => ['104', 1], 'where_goods_id_in_2' => ['105', 1], 'where_goods_id_in_3' => ['106', 1], ...], false, false) in Query.php line 227
-
at Query->query('SELECT * FROM `tp_go...', ['where_goods_id_in_1' => ['104', 1], 'where_goods_id_in_2' => ['105', 1], 'where_goods_id_in_3' => ['106', 1], ...], false, false) in Query.php line 2344
-
at Query->select() in Goods.php line 189
-
at Goods->goodsList()
-
at ReflectionMethod->invokeArgs(object(Goods), []) in App.php line 346
-
at App::invokeMethod([object(Goods), 'goodsList'], []) in App.php line 614
-
at App::module(['Home', 'Goods', 'goodsList'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 460
-
at App::exec(['type' => 'module', 'module' => ['Home', 'Goods', 'goodsList']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 142
-
at App::run() in start.php line 19
-
at require('/usr/home/cj/hzcj/th...') in index.php line 50
Exception Datas
PDO Error Info
SQLSTATE |
42S22 |
Driver Error Code |
1054 |
Driver Error Message |
Unknown column 'comment_' in 'order clause' |
Database Status
Error Code |
10501 |
Error Message |
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'comment_' in 'order clause' |
Error SQL |
SELECT * FROM `tp_goods` WHERE `goods_id` IN (104,105,106,107,108,70,117,118,119,126,127,128,129,131,133,134,95,98,69) ORDER BY `comment_` desc LIMIT 0,20 |
Database Config
type |
mysql |
hostname |
localhost |
database |
cj_purchase |
hostport |
3306 |
dsn |
|
params |
[] |
charset |
utf8 |
prefix |
tp_ |
debug |
true |
deploy |
0 |
rw_separate |
false |
master_num |
1 |
slave_no |
|
fields_strict |
true |
result_type |
2 |
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 |
Environment Variables
Server/Request Data
SCRIPT_FILENAME
/home/cj/hzcj/index.php
QUERY_STRING
s=/Home/Goods/goodsList/id/63/sort/comment_count
REQUEST_URI
/Home/Goods/goodsList/id/63/sort/comment_count
DOCUMENT_ROOT
/home/cj/hzcj
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.12.1
SERVER_ADDR
172.18.175.231
SERVER_NAME
www.gzcjgs.com
PATH_INFO
/Home/Goods/goodsList/id/63/sort/comment_count
HTTP_USER_AGENT
claudebot
REQUEST_TIME_FLOAT
1711690970.2867
argv
[
"s=\/Home\/Goods\/goodsList\/id\/63\/sort\/comment_count"
]
Environment Variables
SCRIPT_FILENAME
/home/cj/hzcj/index.php
QUERY_STRING
s=/Home/Goods/goodsList/id/63/sort/comment_count
REQUEST_URI
/Home/Goods/goodsList/id/63/sort/comment_count
DOCUMENT_ROOT
/home/cj/hzcj
GATEWAY_INTERFACE
CGI/1.1
SERVER_SOFTWARE
nginx/1.12.1
SERVER_ADDR
172.18.175.231
SERVER_NAME
www.gzcjgs.com
HTTP_USER_AGENT
claudebot
REQUEST_TIME_FLOAT
1711690970.2867
argv
[
"s=\/Home\/Goods\/goodsList\/id\/63\/sort\/comment_count"
]
ThinkPHP Constants
PLUGIN_PATH
/usr/home/cj/hzcj/plugins/
UPLOAD_PATH
public/upload/
SITE_URL
http://gzcjgs.com
SERIALNUMBER
20160520065303oCWIoa
APP_PATH
/usr/home/cj/hzcj/application/
THINK_START_TIME
1711690970.2873
THINK_PATH
/usr/home/cj/hzcj/thinkphp/
LIB_PATH
/usr/home/cj/hzcj/thinkphp/library/
CORE_PATH
/usr/home/cj/hzcj/thinkphp/library/think/
TRAIT_PATH
/usr/home/cj/hzcj/thinkphp/library/traits/
ROOT_PATH
/usr/home/cj/hzcj/
EXTEND_PATH
/usr/home/cj/hzcj/extend/
VENDOR_PATH
/usr/home/cj/hzcj/vendor/
RUNTIME_PATH
/usr/home/cj/hzcj/runtime/
LOG_PATH
/usr/home/cj/hzcj/runtime/log/
CACHE_PATH
/usr/home/cj/hzcj/runtime/cache/
TEMP_PATH
/usr/home/cj/hzcj/runtime/temp/
CONF_PATH
/usr/home/cj/hzcj/application/
ThinkPHP
V5.0.15
{ 十年磨一剑-为API开发设计的高性能框架 }