MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1406 - Data too long for column 'lastpostsubject' at row 1
Query:
UPDATE mybb_forums SET `lastpost`=1673533852, `lastposter`='53R3N17Y', `lastposteruid`=24, `lastposttid`=1759, `lastpostsubject`='Hello guys testing this thread subject why this is not working and why long thread subject is going to an error - test one' WHERE fid='79'

I started to get this error now,

I was stuck and finally found a solution to fix this and changed max thread character to 160 :- https://community.mybb.com/thread-237424.html

But after fixing that, when I try to post a thread I get this mysql error. How do I fix this error now? Please someone help me out!

You also have to change mybb_forums.lastpostsubject max length in MySQL

Okay was able to fix it by going to

MyBB Database > Table: mybb_forums > Edit Structure > lastpostsubject > change varchar from 120 to 160 and the issue is fixed.