2011-01-21, 10:24 AM
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
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