Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
872 views
in Q2A Core by

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

A Question2Answer database query failed when generating this page.

by
Is it a brand-new Q2A installation?
by
No, this installation has been working fine since June.
by
Did you upgrade your Q2A installation or install any plug-in recently?
by
Jair, thanks for your response!
I redeployed and restarted the instance after I got the error.
by
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.
by
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
by
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.

Please log in or register to answer this question.

...