- Posts: 7
Before asking for help please read "Requesting Help and Suggestions" by clicking on that tab above here.
Question 1142 UPDATE command denied
- elfersi
-
Topic Author
- Offline
- New Member
-
Less
More
2 months 20 hours 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
Can you help?
Best
Please Log in or Create an account to join the conversation.
- bertkoor
-
- Offline
- Platinum Member
-
- Greetings from Utrecht, Holland
2 months 18 hours ago #2
by bertkoor
stamboom.BertKoor.nl runs on webtrees v1.7.13
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.
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 v1.7.13
Please Log in or Create an account to join the conversation.
- bertkoor
-
- Offline
- Platinum Member
-
- Greetings from Utrecht, Holland
2 months 18 hours ago - 2 months 18 hours ago #3
by bertkoor
stamboom.BertKoor.nl runs on webtrees v1.7.13
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?
Are you perhaps running latest development code now instead of the latest official release?
stamboom.BertKoor.nl runs on webtrees v1.7.13
Last edit: 2 months 18 hours ago by bertkoor.
Please Log in or Create an account to join the conversation.
- fisharebest
-
- Offline
- Administrator
-
1 month 3 weeks ago #4
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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?
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
-
Less
More
- Posts: 7
1 month 3 weeks 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.
- fisharebest
-
- Offline
- Administrator
-
1 month 3 weeks ago #6
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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.
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
-
Less
More
- Posts: 7
3 weeks 14 hours 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?
Can you help?
Please Log in or Create an account to join the conversation.
- fisharebest
-
- Offline
- Administrator
-
3 weeks 12 hours ago #8
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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
-
Less
More
- Posts: 7
2 weeks 4 days 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.