MyBB Community Forums

I tried logging into my forum today and was greeted with this error message:

MySQL error: 1223
Can't execute the query because you have a conflicting read lock
Query: UPDATE mybb_users SET newpms='0' WHERE uid='1' MySQL error: 1223
Can't execute the query because you have a conflicting read lock
Query: UPDATE mybb_users SET lastvisit='1177518897', lastactive='1177562043' WHERE uid='1'

And I get this when I try to log into the Admin panel:

MySQL error: 1223
Can't execute the query because you have a conflicting read lock
Query: INSERT INTO mybb_adminsessions (sid, uid, loginkey, ip, dateline, lastactive) VALUES ('5fadf18da1fec86360c8249442968e30', '1', 'j5KVc1gDYWhQc5gJWwlA3qXctTf5RNU3LbSN3YrvrYHtwN6Ofj', '76.100.194.122', '1177562736', '1177562736')

Any ideas?

Run the repair query. Otherwise contact your host to sort out the issue.

Tikitiki Wrote:Run the repair query. Otherwise contact your host to sort out the issue.

I know where to run the queries, but I have no idea how or what syntax to use.

Use this then: REPAIR TABLE mybb_users; REPAIR TABLE mybb_adminsessions;

http://dev.mysql.com/doc/refman/5.0/en/repair.html

Tikitiki Wrote:Use this then: REPAIR TABLE mybb_users; REPAIR TABLE mybb_adminsessions;

http://dev.mysql.com/doc/refman/5.0/en/repair.html

Thanks Tiki. I appreciate the quick response.