[bramruiter]

Because the plugin-section of this site is mainly dead, and I really need to fix this problem, I’ll copy the same thing:

The plug-in is great, but somehow it turns off randomly. With the forum going live in about a week, I really need some help with this.

[bramruiter]

It indeed was aMySQL issue. It’s been solved now.

[bramruiter]

Ah, I thought it was something like that. I’ve just ordered a new hosting, which works on MySQL 5.

Thanks for the help.

[bramruiter]

Sorry, I don’t check this forum daily, so here’s a late answer:

1. From what I know, it has always been like this. It’s only when I perform a search.

2. The version is bbPress 0.9.0.2 and it was installed somewhere between june 26 and june 31.

3. I didn’t. I only screwed around with the template files.

4. No, they did no update or change whatsoever.

5. Like I said, it was there before the plug-ins, but here’s the list.

Private Forums, BBPress Private Messaging (not working), Post Count Plus – Dynamic.Titles & More!, Akismet, Avatar, Last-Post, Limit Latest Discussion, Bozo Users, BBcode Lite, Move It, Quote, Simple Onlinelist, Allow Images, Human Test for bbPress & Front Page Topics.

6. The second error appears only when someone perform a search. The first error is only noted in the admin area, in the first tab, beneath ‘User Registrations’.

7. Yes. It does happen.

The MySQL version is 3.23.58.

I’m not a big guy when it comes to coding/scripting, so I have no idea what these errors mean. I’m glad somebody wants to help.

[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

[bramruiter]

Anyone?