[10501] PDOException in PDOConnection.php line 713

SQLSTATE[42000]: Syntax error or access violation: 1142 UPDATE command denied to user 'buylamps'@'localhost' for table 'cd_lamp_city_product'

  1. }
  2. return $this->PDOStatement;
  3. } catch (\Throwable | \Exception $e) {
  4. if ($this->isBreak($e)) {
  5. return $this->close()->getPDOStatement($sql, $bind, $master, $procedure);
  6. }
  7. if ($e instanceof \PDOException) {
  8. throw new PDOException($e, $this->config, $this->getLastsql());
  9. } else {
  10. throw $e;
  11. }
  12. }
  13. }
  14. /**
  15. * 执行语句
  16. * @access public

Call Stack

  1. in PDOConnection.php line 713
  2. at PDOConnection->getPDOStatement('UPDATE `cd_lamp_city...', ['ThinkBind_1_205938680_' => ['595', 1]], true, false) in PDOConnection.php line 769
  3. at PDOConnection->queryPDOStatement(object(Query), 'UPDATE `cd_lamp_city...', ['ThinkBind_1_205938680_' => ['595', 1]]) in PDOConnection.php line 739
  4. at PDOConnection->execute(object(Query), 'UPDATE `cd_lamp_city...', ['ThinkBind_1_205938680_' => ['595', 1]]) in PDOConnection.php line 968
  5. at PDOConnection->update(object(Query)) in BaseQuery.php line 1020
  6. at BaseQuery->update() in LampCityProduct.php line 32
  7. at LampCityProduct->index()
  8. at ReflectionMethod->invokeArgs(object(LampCityProduct), []) in Container.php line 342
  9. at Container->invokeReflectMethod(object(LampCityProduct), object(ReflectionMethod), ['id' => '595']) in Controller.php line 105
  10. at Controller->think\route\dispatch\{closure}(object(Request)) in Pipeline.php line 59
  11. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 65
  12. at Pipeline->then(object(Closure)) in Controller.php line 108
  13. at Controller->exec() in Dispatch.php line 96
  14. at Dispatch->run() in Route.php line 747
  15. at Route->think\{closure}(object(Request)) in Pipeline.php line 59
  16. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 65
  17. at Pipeline->then(object(Closure)) in Route.php line 748
  18. at Route->dispatch(object(Request), object(Closure)) in Http.php line 213
  19. at Http->dispatchToRoute(object(Request)) in Http.php line 203
  20. at Http->think\{closure}(object(Request)) in Pipeline.php line 59
  21. at Pipeline->think\{closure}(object(Request)) in TraceDebug.php line 71
  22. at TraceDebug->handle(object(Request), object(Closure), null)
  23. at call_user_func([object(TraceDebug), 'handle'], object(Request), object(Closure), null) in Middleware.php line 142
  24. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 84
  25. at Pipeline->think\{closure}(object(Request)) in MultiApp.php line 65
  26. at MultiApp->think\app\{closure}(object(Request)) in Pipeline.php line 59
  27. at Pipeline->think\{closure}(object(Request)) in SessionInit.php line 67
  28. at SessionInit->handle(object(Request), object(Closure), null)
  29. at call_user_func([object(SessionInit), 'handle'], object(Request), object(Closure), null) in Middleware.php line 142
  30. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 84
  31. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 65
  32. at Pipeline->then(object(Closure)) in MultiApp.php line 66
  33. at MultiApp->handle(object(Request), object(Closure), null)
  34. at call_user_func([object(MultiApp), 'handle'], object(Request), object(Closure), null) in Middleware.php line 142
  35. at Middleware->think\{closure}(object(Request), object(Closure)) in Pipeline.php line 84
  36. at Pipeline->think\{closure}(object(Request)) in Pipeline.php line 65
  37. at Pipeline->then(object(Closure)) in Http.php line 204
  38. at Http->runWithRequest(object(Request)) in Http.php line 162
  39. at Http->run() in index.php line 12

Environment Variables

GET Data
id 595
POST Dataempty
Filesempty
Cookiesempty
Sessionempty
Server/Request Data
USER www
HOME /home/www
HTTP_USER_AGENT claudebot
HTTP_ACCEPT */*
HTTP_HOST www.buylamps.cn
PATH_INFO
REDIRECT_STATUS 200
SERVER_NAME www.buylamps.cn
SERVER_PORT 443
SERVER_ADDR 172.16.26.95
REMOTE_PORT 44794
REMOTE_ADDR 18.212.87.137
SERVER_SOFTWARE nginx/1.18.0
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/2.0
DOCUMENT_ROOT /www/wwwroot/www.buylamps.cn/public
DOCUMENT_URI /index.php
REQUEST_URI /index/city.LampCityProduct/index.html?id=595
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING s=/index/city.LampCityProduct/index.html&id=595
SCRIPT_FILENAME /www/wwwroot/www.buylamps.cn/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711659862.605
REQUEST_TIME 1711659862
Environment Variables
APP_DEBUG 1
APP_DEFAULT_TIMEZONE Asia/Shanghai
DATABASE_TYPE mysql
DATABASE_HOSTNAME localhost
DATABASE_DATABASE buylamps
DATABASE_USERNAME buylamps
DATABASE_PASSWORD 5de8LnyhsE7WnmWs
DATABASE_PREFIX cd_
DATABASE_HOSTPORT 3306
DATABASE_CHARSET utf8
DATABASE_DEBUG 1
LANG_DEFAULT_LANG zh-cn
ThinkPHP Constants
PHP_OS_FAMILY Linux
QINIU_FUNCTIONS_VERSION 7.2.9
BASE_URL https://www.buylamps.cn
DS /
0.033993s