MyBB Community Forums

Full Version: MyBB has experienced an internal SQL error and cannot continue.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
do you have any plugin related to reported posts ? if so, disable it & check
Hi,

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

Anymore ideas? Thanks
^ 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
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.
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
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.
^ Akismet plugin also needs to be deactivated & removed. that should fix referred issue.
nice one Smile

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

Thanks a lot .m.