Can anyone tell me how to begin to address this problem? After installing on web server getting this error:

bbPress database error: [You have an error in your SQL syntax near ‘FROM bb_topics WHERE topic_status = 0 AND topic_sticky <> 2 ORDER BY topic_time’ at line 1]

SELECT SQL_CALC_FOUND_ROWS * FROM bb_topics WHERE topic_status = 0 AND topic_sticky <> 2 ORDER BY topic_time DESC LIMIT 30

I don’t even know where to begin to fix this. I’ve run bbpress on local environment and other hosts flawlessly, but on this company I’m getting these errors. I’m a SQL novice so if anyone can babystep this for me I’d appreciate it.

Thanks

[@fel64 Member 17 years, 5 months ago]

Not a clue. Maybe that host’s MySQL version doesn’t support SQL_CALC_FOUND_ROWS on *? Or something. Your best bet is to report this problem on trac as the bug it is.