[0] Exception in Builder.php line 398

查询表达式错误:EXP

  1. $whereStr .= '(' . implode($array, ' ' . strtoupper($logic) . ' ') . ')';
  2. } else {
  3. $whereStr .= $key . ' ' . $exp . ' ' . $this->parseValue($value, $field);
  4. }
  5. } elseif ('EXP' == $exp) {
  6. // 表达式查询
  7. if ($value instanceof Expression) {
  8. $whereStr .= '( ' . $key . ' ' . $value->getValue() . ' )';
  9. } else {
  10. throw new Exception('where express error:' . $exp);
  11. }
  12. } elseif (in_array($exp, ['NOT NULL', 'NULL'])) {
  13. // NULL 查询
  14. $whereStr .= $key . ' IS ' . $exp;
  15. } elseif (in_array($exp, ['NOT IN', 'IN'])) {
  16. // IN 查询
  17. if ($value instanceof \Closure) {
  18. $whereStr .= $key . ' ' . $exp . ' ' . $this->parseClosure($value);
  19. } else {

Call Stack

  1. in Builder.php line 398
  2. at Builder->parseWhereItem('', ['exp', 'FIND_IN_SET("9",cate...'], 'AND', ['multi' => ['AND' => ['pId' => [['IN', [177]]], 'isDisable' => [['<>', 1]], [['exp', 'FIND_IN_SET("9",cate...']]]], 'where' => ['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], 'field' => [object(Expression)], ...], ['id' => 1, 'pId' => 1, 'cateid' => 2, ...]) in Builder.php line 303
  3. at Builder->buildWhere(['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], ['multi' => ['AND' => ['pId' => [['IN', [177]]], 'isDisable' => [['<>', 1]], [['exp', 'FIND_IN_SET("9",cate...']]]], 'where' => ['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], 'field' => [object(Expression)], ...]) in Builder.php line 240
  4. at Builder->parseWhere(['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], ['multi' => ['AND' => ['pId' => [['IN', [177]]], 'isDisable' => [['<>', 1]], [['exp', 'FIND_IN_SET("9",cate...']]]], 'where' => ['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], 'field' => [object(Expression)], ...]) in Builder.php line 719
  5. at Builder->select(['multi' => ['AND' => ['pId' => [['IN', [177]]], 'isDisable' => [['<>', 1]], [['exp', 'FIND_IN_SET("9",cate...']]]], 'where' => ['AND' => ['pId' => ['IN', [177]], 'isDisable' => ['<>', 1], ['exp', 'FIND_IN_SET("9",cate...']]], 'field' => [object(Expression)], ...]) in Query.php line 2462
  6. at Query->getPdo() in Query.php line 441
  7. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 576
  8. at Query->aggregate('COUNT', '*', true) in Query.php line 551
  9. at Query->count() in Query.php line 1484
  10. at Query->paginate(12) in Kuxiaoju.php line 165
  11. at Kuxiaoju->kuxiaoju()
  12. at ReflectionMethod->invokeArgs(object(Kuxiaoju), []) in App.php line 343
  13. at App::invokeMethod([object(Kuxiaoju), 'kuxiaoju'], []) in App.php line 611
  14. at App::module(['mobilemall', 'Kuxiaoju', 'kuxiaoju'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], false) in App.php line 457
  15. at App::exec(['type' => 'module', 'module' => ['mobilemall', 'Kuxiaoju', 'kuxiaoju'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 139
  16. at App::run() in start.php line 19
  17. at require('/data/work/html/2019...') in index.php line 26

Environment Variables

GET Data

/yunhuojia/
label
9
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

REDIRECT_HTTPS
on
REDIRECT_SSL_TLS_SNI
mobile.bardiss.com
REDIRECT_STATUS
200
HTTPS
on
SSL_TLS_SNI
mobile.bardiss.com
HTTP_ACCEPT
*/*
HTTP_USER_AGENT
claudebot
HTTP_HOST
mobile.bardiss.com
PATH
/sbin:/usr/sbin:/bin:/usr/bin
SERVER_SIGNATURE
SERVER_SOFTWARE
Apache
SERVER_NAME
mobile.bardiss.com
SERVER_ADDR
172.18.172.83
SERVER_PORT
443
REMOTE_ADDR
3.235.46.191
DOCUMENT_ROOT
/data/work/html/2019bardisscom
SERVER_ADMIN
root@localhost
SCRIPT_FILENAME
/data/work/html/2019bardisscom/index.php
REMOTE_PORT
38858
REDIRECT_QUERY_STRING
/yunhuojia/&label=9
REDIRECT_URL
/yunhuojia/
GATEWAY_INTERFACE
CGI/1.1
SERVER_PROTOCOL
HTTP/1.1
REQUEST_METHOD
GET
QUERY_STRING
/yunhuojia/&label=9
REQUEST_URI
/yunhuojia/?label=9
SCRIPT_NAME
/index.php
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711645242.958
REQUEST_TIME
1711645242
PATH_INFO
/yunhuojia/
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/data/work/html/2019bardisscom/application/
WX_PATH
./weixinToken/
THINK_VERSION
5.0.24
THINK_START_TIME
1711645242.959
THINK_START_MEM
257128
EXT
.php
DS
/
THINK_PATH
/data/work/html/2019bardisscom/thinkphp/
LIB_PATH
/data/work/html/2019bardisscom/thinkphp/library/
CORE_PATH
/data/work/html/2019bardisscom/thinkphp/library/think/
TRAIT_PATH
/data/work/html/2019bardisscom/thinkphp/library/traits/
ROOT_PATH
/data/work/html/2019bardisscom/
EXTEND_PATH
/data/work/html/2019bardisscom/extend/
VENDOR_PATH
/data/work/html/2019bardisscom/vendor/
RUNTIME_PATH
/data/work/html/2019bardisscom/runtime/
LOG_PATH
/data/work/html/2019bardisscom/runtime/log/
CACHE_PATH
/data/work/html/2019bardisscom/runtime/cache/
TEMP_PATH
/data/work/html/2019bardisscom/runtime/temp/
CONF_PATH
/data/work/html/2019bardisscom/application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false