MyBB Community Forums

Hi all.
It's my first time with myBB and i'm having problems :/

I've a fresh install, everything went fine without any problem. When i try to open the demo forum (or any other forum that i created in admin control panel), i can't, i just get this fatal error:

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

SQL Error:
42803 - ERROR: column "t.fid" must appear in the GROUP BY clause or be used in an aggregate function
Query:
SELECT t.*, p.displaystyle AS threadprefix, CASE WHEN t.numratings=0 THEN 0 ELSE t.totalratings/t.numratings::numeric END 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='0') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='3' AND t.visible='1' GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpost desc LIMIT 20 OFFSET 0

This is my config:
MyBB: 1.6.1
PHP: 5.2.14
SQL Engine: PGsql 8.1.22

Ah yes, this was reported as a bug, I don't think they've tried to fix it yet. I'm afraid you'll have to wait. (Or use MySQL or something)

Remove GROUP BY t.tid from line 709 of ./forumdisplay.php.

Use MySQL if you can.