MyBB Community Forums

Oh, your query worked fine with mybb_templates > status.
I also have he same problem with mybb_posts > posthash,
when I replaced the names like
ALTER TABLE mybb_posts MODIFY COLUMN posthash varchar(10) NOT NULL default '',
the error says "Error Code: 1265. Data truncated for column 'posthash' at row 1"

you think the other bug needs a different varchar(10) number?

I don't think, I know that. As I said, you can't use random numbers, they need to be at least as long as the longest record. That's the proper size: https://github.com/mybb/mybb/blob/featur...es.php#L83

Thanks man!
After weeks problem is being solved using your query + github.
I'm now fixing the errors as fast as they show up.

SOLVED!