MyBB Community Forums

Full Version: Show 'Similar Threads' Table with Postgres Exception 42601
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi Community,

there seems to be a bug using the 'Show Similar Threads Table functionality on Postgres (8.3)

When i try to display a thread myBB raise the exception:

SQL Error:
42601 - FEHLER: Syntaxfehler bei »AGAINST« LINE 2: ...le AS threadprefix, u.username, MATCH (t.subject) AGAINST ('... ^
Query:
SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('jQuery BlockUI update to 2.36') AS relevance FROM mybb_threads t LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='6' AND t.tid!='2' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('jQuery BlockUI update to 2.36') >= '1' ORDER BY t.lastpost DESC LIMIT 10 OFFSET 0

Postgres do not know the 'MATCH AGAINST' Syntax like mySQL.

Some Facts:
- Clean Installation of myBB1.6 on Postgres8.3 and PHP5.3
- Removed GROUP BY clause (other Bug on myBB with Postgres)

Marcus
Report this on http://dev.mybb.com Smile