http://bbpress.org/forums/ bbPress support forums Topic: Database error en Sun, 12 Oct 2008 00:59:54 +0000 http://bbpress.org/forums/topic/database-error#post-10650 Fri, 31 Aug 2007 22:37:48 +0000 baptiste 10650@http://bbpress.org/forums/ <p>Are you running MySQL 3.23 or v4? v3.23 doesn't support SQL_CALC_FOUND_ROWS - 0.8.2.1 needs v4 or higher </p> http://bbpress.org/forums/topic/database-error#post-10649 Fri, 31 Aug 2007 22:30:36 +0000 netsleds 10649@http://bbpress.org/forums/ <p>Tried upgrading from .8 to .8.2.1 and I keep getting this error. anyone else get this and how do you fix it?</p> <p>bbPress database error: [You have an error in your SQL syntax near 'FROM bb_topics WHERE topic_status = 0 AND topic_sticky &lt;&gt; 2 ORDER BY topic_time' at line 1]<br /> SELECT SQL_CALC_FOUND_ROWS * FROM bb_topics WHERE topic_status = 0 AND topic_sticky &lt;&gt; 2 ORDER BY topic_time DESC LIMIT 10</p> <p>bbPress database error: [You have an error in your SQL syntax near 'FROM bb_topics WHERE topic_sticky = 2 AND topic_status = 0 ORDER BY topic_time ' at line 1]<br /> SELECT SQL_CALC_FOUND_ROWS * FROM bb_topics WHERE topic_sticky = 2 AND topic_status = 0 ORDER BY topic_time DESC </p>