MyBB Community Forums

Just another SQL 1054 thread

Today I noticed that I'm not able to edit my post in the forum as I'm getting the error below:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'editreason' in 'field list'
Query:
UPDATE mybb_posts SET `subject`='RE: HONDAZ in PICS', `message`='[url=http://www.typeone.jp/?p=19117]Source[/url]\r\n\r\n[img]http://www.typeone.jp/wp-content/uploads/2017/12/IMG_9317.jpg[/img]', `editreason`='', `icon`=0, `smilieoff`='0', `includesig`='1', `edituid`=3, `edittime`=1512732020 WHERE pid='51286'
Please contact the MyBB Group for technical support.

I don't really want to start messing with SQL without pro advice so I'm asking here for help.  I do remember I had a plugin for editing reasons but it was disabled since I upgraded the forum from 1.6 to 1.8 so not really sure what next.

Forum link - www.hondatalk.ro

Thanks in advance

exactly which version of MyBB you have now & what is your php version ?
do you remember running the upgrade script [forumURL/install/upgrade.php] ?

this reply can be helpful in fixing above referred issue

Sorry, I had the current version there but edited the text after

Current version is 1.8.13, PHP Version 5.4.45 and yes I did run the upgrade script when upgraded from 1.8.12. Should I try to go to x.14 and see what happens?

try this suggestion to fix above referred issue.
And we always suggest to upgrade forum to the latest available version.

Thanks for that .m. run the query and everything is fine now.

I've searched the forum but somehow I missed that thread.