MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'p0wxg8if_VGFdata.mybb_reportedposts' doesn't exist
Query:
SELECT COUNT(DISTINCT p.pid) AS numreports FROM mybb_posts p INNER JOIN mybb_reportedposts r ON r.pid=p.pid WHERE p.uid=738 AND p.visible=1 AND r.reportstatus!=0

Getting this for some users when they try to post.

Can't figure it out. Im on the latest version of myBB.

I done a file verification check, all is well there. I don't have any plugins related to reported posts.

Any ideas?

Thanks in advance

It doesn't look like a core query.

Try the Disable All Plugins setting (Configuration → Settings → General Configuration) to make sure it's a plugin, then you can deactivate them successively to find out which one is to blame.

Yup that did the trick. Thanks for the help. Disabled them all, then re-enabled and it came right.