Just home from work to see my forum has experienced several database errors today. Indeed, as I attempted to post to the forum, I received the error below.
Only recent change to the forum was modifying the charset to UTF-8. I upgraded my forum May 29th and paid for telephone support, but no one is answering.
Any ideas on steps to take to resolve this?
Thank you.
Only recent change to the forum was modifying the charset to UTF-8. I upgraded my forum May 29th and paid for telephone support, but no one is answering.
The email I receive from the error looks something like this:
Database error in vBulletin 5.4.1:
Invalid SQL:
UPDATE node AS node
SET node.lastcontent = CASE WHEN 1529437888 >= node.lastcontent THEN 1529437888 ELSE node.lastcontent END,
node.lastcontentid = CASE WHEN 1529437888 >= node.lastcontent THEN 1580495 ELSE node.lastcontentid END,
node.lastcontentauthor = CASE WHEN 1529437888 >= node.lastcontent THEN '-Deborah-' ELSE node.lastcontentauthor END,
node.lastauthorid = CASE WHEN 1529437888 >= node.lastcontent THEN 3 ELSE node.lastauthorid END
WHERE node.nodeid IN (1,2,14,16,7508) /**setLastDataParentList**/;
MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Tuesday, June 19th 2018 @ 07:51:28 PM
Error Date : Tuesday, June 19th 2018 @ 07:52:20 PM
Any ideas on steps to take to resolve this?
Thank you.
Comment