- Posts: 9
Question 1142 UPDATE command denied
- elfersi
- Topic Author
- Offline
- New Member
Less
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
Can you help?
Best
Please Log in or Create an account to join the conversation.
- bertkoor
- Offline
- Platinum Member
- Greetings from Utrecht, Holland
1 year 1 month ago #2
by bertkoor
stamboom.BertKoor.nl runs on webtrees v2.1.20
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 v2.1.20
Please Log in or Create an account to join the conversation.
- bertkoor
- Offline
- Platinum Member
- Greetings from Utrecht, Holland
1 year 1 month ago - 1 year 1 month ago #3
by bertkoor
stamboom.BertKoor.nl runs on webtrees v2.1.20
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 v2.1.20
Last edit: 1 year 1 month ago by bertkoor.
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
1 year 1 month 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: 9
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.
- fisharebest
- Offline
- Administrator
1 year 1 month 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: 9
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?
Can you help?
Please Log in or Create an account to join the conversation.
- fisharebest
- Offline
- Administrator
1 year 2 weeks 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: 9
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.