$this->debug(false, '', $master);
// 返回结果集
return $this->getResult($pdo, $procedure);
} catch (\PDOException $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw new PDOException($e, $this->config, $this->getLastsql());
} catch (\Throwable $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
}
throw $e;
} catch (\Exception $e) {
if ($this->isBreak($e)) {
return $this->close()->query($sql, $bind, $master, $pdo);
SQLSTATE | 42000 |
Driver Error Code | 1055 |
Driver Error Message | Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpccart.op.products_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
Error Code | 10501 |
Error Message | SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpccart.op.products_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
Error SQL | SELECT p.products_id,p.manufacturers_series_id, p.products_price, p.products_image, op.products_name,sum(op.products_quantity) as sale FROM `orders_products` `op` INNER JOIN `products` `p` ON `op`.`products_id`=`p`.`products_id` WHERE `p`.`manufacturers_id` = '1829' AND `p`.`manufacturers_series_id` IN ('8073','8074','8075','8076') GROUP BY `op`.`products_id` ORDER BY `sale` DESC LIMIT 0,5 |
type | mysql |
hostname | rm-wz9n99e7id2n306u6ao.mysql.rds.aliyuncs.com |
database | gpccart |
hostport | 3306 |
dsn | |
params | [] |
charset | utf8 |
prefix | |
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 | [] |
db2 | { "type": "mysql", "hostname": "127.0.0.1", "database": "gpccart", "username": "gpccart", "password": "gpc0771", "hostport": "", "params": [], "charset": "utf8", "prefix": "" } |
db3 | { "type": "mysql", "hostname": "127.0.0.1", "database": "test", "username": "gpccart", "password": "gpc0771", "hostport": "", "params": [], "charset": "utf8", "prefix": "" } |
USER | www |
HOME | /home/www |
HTTP_USER_AGENT | claudebot |
HTTP_ACCEPT | */* |
HTTP_CONNECTION | close |
HTTP_HOST | www.gpcang.com |
PHP_ADMIN_VALUE | open_basedir=/www/wwwroot/www.gpcang.com/:/www/wwwroot/www.gpcang.com/images/:/www/wwwroot/www.gpcang.com/tp5/:/www/wwwroot/www.gpcang.com/tp5/application/:/tmp/ |
PATH_INFO | |
REDIRECT_STATUS | 200 |
SERVER_NAME | www.gpcang.com |
SERVER_PORT | 443 |
SERVER_ADDR | 172.18.36.102 |
REMOTE_PORT | 54440 |
REMOTE_ADDR | 39.108.54.53 |
SERVER_SOFTWARE | nginx/1.8.1 |
GATEWAY_INTERFACE | CGI/1.1 |
HTTPS | on |
SERVER_PROTOCOL | HTTP/1.0 |
DOCUMENT_ROOT | /www/wwwroot/www.gpcang.com |
DOCUMENT_URI | /tp5/tp7.php |
REQUEST_URI | /tp5/tp7.php?s=Brand/brand_cate/b_id/1829.html |
SCRIPT_NAME | /tp5/tp7.php |
CONTENT_LENGTH | |
CONTENT_TYPE | |
REQUEST_METHOD | GET |
QUERY_STRING | s=Brand/brand_cate/b_id/1829.html |
SCRIPT_FILENAME | /www/wwwroot/www.gpcang.com/tp5/tp7.php |
FCGI_ROLE | RESPONDER |
PHP_SELF | /tp5/tp7.php |
REQUEST_TIME_FLOAT | 1711674404.4644 |
REQUEST_TIME | 1711674404 |
APP_PATH | /www/wwwroot/www.gpcang.com/tp5/application/ |
THINK_VERSION | 5.0.15 |
THINK_START_TIME | 1711674404.4648 |
THINK_START_MEM | 422424 |
EXT | .php |
DS | / |
THINK_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/ |
LIB_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/ |
CORE_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/think/ |
TRAIT_PATH | /www/wwwroot/www.gpcang.com/tp5/thinkphp/library/traits/ |
ROOT_PATH | /www/wwwroot/www.gpcang.com/tp5/ |
EXTEND_PATH | /www/wwwroot/www.gpcang.com/tp5/extend/ |
VENDOR_PATH | /www/wwwroot/www.gpcang.com/tp5/vendor/ |
RUNTIME_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/ |
LOG_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/log/ |
CACHE_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/cache/ |
TEMP_PATH | /www/wwwroot/www.gpcang.com/tp5/runtime/temp/ |
CONF_PATH | /www/wwwroot/www.gpcang.com/tp5/application/ |
CONF_EXT | .php |
ENV_PREFIX | PHP_ |