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

I have moved my site to a new server and recreated the db, but get the following error:

+1 vote
asked Jul 25, 2013 in Q2A Core by Rudolph

Below is my error that I get, requesting the site works the first time, the second time returns this error and then the 3rd one works again:

Question2Answer query failed:

LOCK TABLES qa_blobs WRITE, qa_cache WRITE, qa_categories WRITE, qa_categorymetas WRITE, qa_contentwords WRITE, qa_cookies WRITE, qa_iplimits WRITE, qa_mamlmconfirm WRITE, qa_messages WRITE, qa_options WRITE, qa_pages WRITE, qa_postmeta WRITE, qa_postmetas WRITE, qa_posts WRITE, qa_posttags WRITE, qa_sharedevents WRITE, qa_tagmetas WRITE, qa_tagwords WRITE, qa_titlewords WRITE, qa_userevents WRITE, qa_userfavorites WRITE, qa_userfields WRITE, qa_userlimits WRITE, qa_userlogins WRITE, qa_usermetas WRITE, qa_usernotices WRITE, qa_userpoints WRITE, qa_userprofile WRITE, qa_users WRITE, qa_uservotes WRITE, qa_widgets WRITE, qa_words WRITE

Error 1146: Table 'xxx.qa_mamlmconfirm' doesn't exist

commented Jul 25, 2013 by gidgreen
Do you have any idea what this qa_mamlmconfirm table is from?
commented Jul 26, 2013 by rudolphk
moved Jul 26, 2013 by Scott
No I do not know, but by the looks of table structure and data it is for subscribing to MailChimp.  The table do exists and as I've mentioned this only happens every second request.

2 Answers

0 votes
answered Jul 26, 2013 by rudolphk
Thanks, I've removed the table and now its working fine. It was a table for a mailing list manager.
0 votes
answered Dec 27, 2017 by Will Dville

I had to remove the qa_mamlmConfirm.* files from "/var/lib/mysql/mydatabase" folder

mv qa_mamlmConfirm.* /tmp

And it was fine