Skip to:
Content
Pages
Categories
Search
Top
Bottom

Database error

  • @netsleds

    Member

    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

Viewing 1 replies (of 1 total)
  • @baptiste

    Member

    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

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.
Skip to toolbar