On trying to upgrade my website from 1.6.3 to 1.8.0, I got the following error.
Database query error 1100
Table 'qa_messages' was not locked with LOCK TABLES
ALTER TABLE qa_messages ADD COLUMN tohidden TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER fromhidden
I ignored the error and reloaded the page. The upgrade continued with few more similar errors around locks and finally got stuck at qa_iplimits. At this point, even after refreshing the page multiple times, I kept getting the same error.
The version of mysql that I am using is around 4 years old.
Can someone please help in resolving this error?