bbPress

Info

• 2 posts
• 2 voices
• Started 4 years ago by netsleds
• Latest reply from baptiste
• This topic is not resolved

Tags

• database
• error
• problem
• SQL_CALC_FOUND_ROWS

• Posts in this topic

Database error

1. • 
   • netsleds
   • Member

   • Posted 4 years ago #

   Tried upgrading from .8 to .8.2.1 and I keep getting this error. anyone else get this and how do you fix it?

   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 10

   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]
   SELECT SQL_CALC_FOUND_ROWS * FROM bb_topics WHERE topic_sticky = 2 AND topic_status = 0 ORDER BY topic_time DESC
2. • 
   • baptiste
   • Member

   • Posted 4 years ago #

   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

3. You must log in to post.