Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: bbPress Database Error


bramruiter
Member

@bramruiter

The problem got a bit bigger. When someone tries to find something through the search they get:

bbPress database error: [You have an error in your SQL syntax near ‘ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE ‘%ja%’ AND p.post_status =’ at line 1]

SELECT p.*, 0 AS search_score, MAX(post_time) AS post_time FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE ‘%ja%’ AND p.post_status = ‘0’ AND t.topic_status = ‘0’ GROUP BY t.topic_id ORDER BY p.post_time DESC LIMIT 5

bbPress database error: [You have an error in your SQL syntax near ‘ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = ‘0’ AND p.post_status = ‘0’ at line 1]

SELECT t.*, MIN(p.post_id) as post_id, p.post_text, 0 AS search_score FROM bb_topics AS t JOIN bb_posts as p ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = ‘0’ AND p.post_status = ‘0’ AND ( (t.topic_title LIKE ‘%ja%’) OR p.post_text LIKE ‘%ja%’ ) GROUP BY t.topic_id ORDER BY t.topic_time DESC LIMIT 20

Skip to toolbar