Forum Replies Created
In reply to: Private Forums Plugin
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.
It indeed was aMySQL issue. It’s been solved now.
Ah, I thought it was something like that. I’ve just ordered a new hosting, which works on MySQL 5.
Thanks for the help.
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.
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 20In reply to: Gravatar Disable Issue