[10501] PDOException in Connection.php line 383

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1

  1. $this->bindValue($bind);
  2. }
  3. // 执行查询
  4. $this->PDOStatement->execute();
  5. // 调试结束
  6. $this->debug(false);
  7. // 返回结果集
  8. return $this->getResult($pdo, $procedure);
  9. } catch (\PDOException $e) {
  10. throw new PDOException($e, $this->config, $this->getLastsql());
  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 383
  2. at Connection->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 226
  3. at Query->query('SELECT COUNT(*) AS t...', [], false, true) in Query.php line 2234
  4. at Query->getPdo() in Query.php line 412
  5. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 523
  6. at Query->count() in Query.php line 1331
  7. at Query->paginate(15, false, ['query' => []]) in Audience.php line 351
  8. at Audience->detail()
  9. at ReflectionMethod->invokeArgs(object(Audience), []) in App.php line 224
  10. at App::invokeMethod([object(Audience), 'detail'], []) in App.php line 392
  11. at App::module(['home', 'audience', 'detail'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 130
  12. at App::run() in start.php line 18
  13. at require('/home/wwwroot/zlmng....') in index.php line 17

Exception Datas

PDO Error Info
SQLSTATE 42000
Driver Error Code 1064
Driver Error Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1
Database Status
Error Code 10501
Error Message SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1
Error SQL SELECT COUNT(*) AS tp_count FROM `pub_zl_productimg` `zp` INNER JOIN `pub_zl_companyinfo` `zc` ON `zp`.`user_id`=`zc`.`user_id` WHERE ( zp.status=1 AND zc.status=1 AND zp.user_id= ) LIMIT 1
Database Config
type mysql
hostname localhost
database zhanlang
username root
password XIAOwu@8899
hostport 3306
dsn
params []
charset utf8
prefix pub_
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

Environment Variables

GET Dataempty
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
FCGI_ROLE RESPONDER
SCRIPT_FILENAME /home/wwwroot/zlmng.jiekui.net/index.php
QUERY_STRING s=//home/audience/detail/id/www.xukang.cn
REQUEST_METHOD GET
CONTENT_TYPE
CONTENT_LENGTH
SCRIPT_NAME /index.php
REQUEST_URI /home/audience/detail/id/www.xukang.cn
DOCUMENT_URI /index.php
DOCUMENT_ROOT /home/wwwroot/zlmng.jiekui.net
SERVER_PROTOCOL HTTP/1.1
REQUEST_SCHEME http
GATEWAY_INTERFACE CGI/1.1
SERVER_SOFTWARE nginx/1.16.1
REMOTE_ADDR 44.192.132.66
REMOTE_PORT 43006
SERVER_ADDR 172.18.98.185
SERVER_PORT 80
SERVER_NAME cantonrehacare.com
REDIRECT_STATUS 200
PHP_ADMIN_VALUE open_basedir=/home/wwwroot/zlmng.jiekui.net/:/tmp/:/proc/:/home/wwwroot/
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST cantonrehacare.com
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711661571.9198
REQUEST_TIME 1711661571
PATH_INFO //home/audience/detail/id/www.xukang.cn
Environment Variablesempty
ThinkPHP Constants
APP_PATH /home/wwwroot/zlmng.jiekui.net/application/
THINK_VERSION 5.0.5
THINK_START_TIME 1711661571.9204
THINK_START_MEM 259528
EXT .php
DS /
THINK_PATH /home/wwwroot/zlmng.jiekui.net/thinkphp/
LIB_PATH /home/wwwroot/zlmng.jiekui.net/thinkphp/library/
CORE_PATH /home/wwwroot/zlmng.jiekui.net/thinkphp/library/think/
TRAIT_PATH /home/wwwroot/zlmng.jiekui.net/thinkphp/library/traits/
ROOT_PATH /home/wwwroot/zlmng.jiekui.net/
EXTEND_PATH /home/wwwroot/zlmng.jiekui.net/extend/
VENDOR_PATH /home/wwwroot/zlmng.jiekui.net/vendor/
RUNTIME_PATH /home/wwwroot/zlmng.jiekui.net/runtime/
LOG_PATH /home/wwwroot/zlmng.jiekui.net/runtime/log/
CACHE_PATH /home/wwwroot/zlmng.jiekui.net/runtime/cache/
TEMP_PATH /home/wwwroot/zlmng.jiekui.net/runtime/temp/
CONF_PATH /home/wwwroot/zlmng.jiekui.net/application/
CONF_EXT .php
ENV_PREFIX PHP_
IS_CLI false
IS_WIN false