MyBB Community Forums

Whenever I click on a forum I get this error (or something really similar for each forum):

Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 't.prefix' in 'on clause'
Query:
SELECT t.*, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='1') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='4' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20
Please contact the MyBB Group for support.

---

I think this may be because I forgot to disable all my plugins before I upgraded...

First off why are you running a beta on a live site?? It looks like you've not run the upgrade script.

Yeah I ran the upgrade script and this isn't a live site.

---

Nevermind I'm just going to restore my backup.

I have the same problem, any fix to this problem?

Read above

Try and restore backup->disable plugins->upgrade again.

The problem would be not running the upgrade script.

(2010-08-23, 01:36 PM)MattRogowski Wrote: [ -> ]The problem would be not running the upgrade script.

Yeah that seems to be the problem. Got it fixed, thanks!