Related problem: after loading a backup from two days ago (software and DB), emptying the caches, waiting a few minutes, the website worked for about 10 minutes. Then we got this message on several tables (cache..., watchdog). We can repeat this unlimited. We can assume it's not a syntax error.
Apache, drupal 9.5.5, PHP 8.1.17, MYSQL 5.7.40
We are a senior club.
Thanks in advance.
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user '...............' for table 'watchdog': INSERT INTO "watchdog"
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT, UPDATE command denied to user '................' for table 'cache_config': INSERT INTO "cache_config"
Related problem: after loading a backup from two days ago (software and DB), emptying the caches, waiting a few minutes, the website worked for about 10 minutes. Then we got this message on several tables (cache..., watchdog). We can repeat this unlimited. We can assume it's not a syntax error.
Apache, drupal 9.5.5, PHP 8.1.17, MYSQL 5.7.40
We are a senior club.
Thanks in advance.
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user '...............' for table 'watchdog': INSERT INTO "watchdog"
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT, UPDATE command denied to user '................' for table 'cache_config': INSERT INTO "cache_config"
Yes, attached the normal front page.
the error only occurs with a login form the selected user roles.
i did what you asked. I notice that the error only occurs after selecting user roles.
Here is a print screen of what I get.
(sorry, i don't now how to make a new issue)
In 8.x we defined one rule and only a 'Request Pad': /admin123 /* Our module used the alternative theme. Simple but it worked fine.
Now we installed 2.x in our test environment and received only a form from the front page with a update menu. Tried everything, even two rules. Only after we restore the original version from the patch above it worked again. Can you explain this? Thanks.
(Drupal 9.5.5, PHP 8.1)