Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

database query failed when generating this page

+2 votes
asked Oct 3, 2014 in Q2A Core by vmgk

I have integrated  Q2A with WordPress. When I click on Ask Question and post a question as anonymous user I get this error message:

A Question2Answer database query failed when generating this page.
A full description of the failure is available in the web server's error log file.
Can anyone please guide me on how to fix this ?
commented Oct 3, 2014 by maxjtechno
Check your webserver's (Apache ?) error log file. There you should see the details of the error message
commented Oct 7, 2014 by vmgk
Thank you for your reply.

The webserver error is :

PHP Question2Answer MySQL query error 1146: Table 'user_messageboard.qa_postmeta' doesn't exist - Query: SELECT qa_posts.postid as postid,qa_posts.title as title FROM qa_postmeta, qa_posts WHERE qa_postmeta.meta_key='merged_with' AND qa_postmeta.post_id='images' AND qa_posts.postid=qa_postmeta.meta_value"

Could you suggest some way to fix this?
commented Oct 7, 2014 by pupi1985
That is not an appropriate error. The error states table user_messageboard does not exist and the query in your error is not referencing it. Clearly the error and the query have nothing to do. Please, provide the appropriate error and query.

Having said that, clearly, some query is using user_messageboard which just doesn't exist. Probably a plugin is using that table but I don't know of any which does... and even if it is a plugin then the plugin developer should correct the table name as it is not using the "qa" prefix

Please log in or register to answer this question.