I am getting the following error: "A Question2Answer database query failed when generating this page.

Question

I am getting the below error when trying to access my application. 

A Question2Answer database query failed when generating this page.

Comments

Jair, thanks for your response!
I redeployed and restarted the instance after I got the error.

---

You're welcome!

There’s something going on with your database and/or plug-ins. You can find more information about it in the server’s log.

---

The log his showing the following issue:

PHP Question2Answer MySQL query error 1142: INSERT,UPDATE command denied to user 'ba133c8ecc40e5'@'52.204.50.0' for table 'qa_iplimits' - Query: INSERT INTO qa_iplimits (ip, action, period, count) VALUES (COALESCE(INET_ATON('10.109.140.73'), 0), 'L', 436287, 1) ON DUPLICATE KEY UPDATE count=IF(period=436287, count+1, 1), period=436287

---

In the installation guide here:
https://docs.question2answer.org/install/

The fourth step says: “Create a MySQL database, and a MySQL user with full permissions for that database. If you're interested, the privileges actually needed are: CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES”

Are you sure the username in qa-config.php actually has these privileges? Make sure it contains the current database credentials.