Web based family history software

Question 1142 UPDATE command denied

  • elfersi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 month ago #1 by elfersi
1142 UPDATE command denied was created by elfersi
Hi,My website is down due to this error: `PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 UPDATE command denied to user`
Can you help?
Best

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
1 year 1 month ago #2 by bertkoor
Replied by bertkoor on topic 1142 UPDATE command denied
The error means that webtrees can no longer update a row in one (or more) database table(s).

Has something changed in the database setup or its authorizations? If you thought webtrees can run with only "read" privileges, then that's the error. webtrees stores for instance session data (also of visitors) in the database.

Look in the file data/config.ini.php what "dbuser" is used to connect with. Review access privileges for that user on the webtrees tables.

stamboom.BertKoor.nl runs on webtrees v2.1.20

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
1 year 1 month ago - 1 year 1 month ago #3 by bertkoor
Replied by bertkoor on topic 1142 UPDATE command denied
Judging from the stack trace, your website tries to complete an upgrade and fails in an attempt to create a new setting (insert or update a row in table wt_site_setting) for the default language.

Are you perhaps running latest development code now instead of the latest official release?

stamboom.BertKoor.nl runs on webtrees v2.1.20
Last edit: 1 year 1 month ago by bertkoor.

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #4 by fisharebest
Replied by fisharebest on topic 1142 UPDATE command denied
> PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 UPDATE command denied to user 'elfersi_db'@'10.10.20.123' for table 'wt_site_setting'

Is this your own server or are you using a web-hosting company?

Can you access the database - e.g. using phpMyAdmin?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • elfersi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 1 month ago #5 by elfersi
Replied by elfersi on topic 1142 UPDATE command denied
it is hosted but i can access the db (using phpMyAdmin for instance)

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #6 by fisharebest
Replied by fisharebest on topic 1142 UPDATE command denied
You should be able to use phpMyAdmin to view the permissions that your db-user has on your database.

Be sure that it includes UPDATE.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • elfersi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 2 weeks ago #7 by elfersi
Replied by elfersi on topic 1142 UPDATE command denied
After looking into my provider (OVHcloud), I realized that my db had run out of space. So I upgraded my account. Now I have a different error msg: "Class "Doctrine\Common\Lexer\AbstractLexer" not found …/vendor/egulias/email-validator/src/EmailLexer.php:7"
Can you help?

Please Log in or Create an account to join the conversation.

More
1 year 2 weeks ago #8 by fisharebest
Replied by fisharebest on topic 1142 UPDATE command denied
Delete the /vendor folder and reinstall

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • elfersi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 2 weeks ago #9 by elfersi
Replied by elfersi on topic 1142 UPDATE command denied
awesome. this worked! thanks so much

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum