[Error Message] MyBB has experienced an internal SQL error and cannot continue.

[anarchyforever]

Hi,
I am using scrapeboxforum.com, and I keep getting the following error when posting a thread:


SQL Error:1146 - Table 'scrapebo_sboxforum.mybb_reportedposts' doesn't existQuery:SELECT COUNT(DISTINCT p.pid) AS numreports FROM mybb_posts p INNER JOIN mybb_reportedposts r ON r.pid=p.pid WHERE p.uid=25719 AND p.visible=1 AND r.reportstatus!=0
Please contact the MyBB Group for technical support.

Please help. Thank you.

[.m.]

do you have any plugin related to reported posts ? if so, disable it & check

[sidjames]

Hi,

I'm an admin of that forum. I've checked the plugins and there's no reported posts addon installed.

Anymore ideas? Thanks

[.m.]

^ exactly which version of MyBB you are using ?

run file verification tool from below location. what does it report ?
admin panel >> tools & maintenance >> file verification

ignore reported images & ignore files reported from install folder & its sub-folders

[sidjames]

Currently running: v1.8.10

It was upgraded quite recently to v1.8 which is where the issue has come from. What's strange though is some users have a problem and some don't. People are still posting on the forum without any issues.

I ran file verification and the only result was a missing logo image.

[.m.]

which plugins you have in active status ?
do you remember deactivating the plugins before upgrading ?

either upgrade was not done in correct method or a old plugin file is affecting

[sidjames]

Here's the list:

Akismet 1.2.2
Board announcements manager 1.0
Fassim anti spam 1.3
fit on page 2.3
google analytics 1.5
google seo 1.8.1
hide sigs and website of new users 1.1
my advertisements 2.3
reCaptcha 1.1
register time 1.1
stop forum spam 1.4.1
tapatalk 4.5.6

I've since removed Fassim anti spam and stop forum spam because I've read they're not required with 1.8

I didn't do the upgrade myself, we hired someone to do it.

[.m.]

^ Akismet plugin also needs to be deactivated & removed. that should fix referred issue.

[sidjames]

nice one

I've uninstalled it and ask the user to re-test.

Thanks a lot .m.