http://bbpress.org/forums/ bbPress support forums Topic: bbPress Database Error en Wed, 03 Dec 2008 03:36:32 +0000 http://bbpress.org/forums/topic/bbpress-database-error-1#post-16797 Wed, 18 Jun 2008 12:15:17 +0000 bramruiter 16797@http://bbpress.org/forums/ <p>It indeed was aMySQL issue. It's been solved now. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16794 Wed, 18 Jun 2008 10:12:49 +0000 bramruiter 16794@http://bbpress.org/forums/ <p>Ah, I thought it was something like that. I've just ordered a new hosting, which works on MySQL 5.</p> <p>Thanks for the help. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16762 Sat, 14 Jun 2008 18:13:48 +0000 chrishajer 16762@http://bbpress.org/forums/ <p>bbPress requires MySQL 4.0 minimum. I think 3.23 is too low:<br /> <a href="http://bbpress.org/about/requirements/" rel="nofollow">http://bbpress.org/about/requirements/</a> </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16759 Sat, 14 Jun 2008 10:13:23 +0000 bramruiter 16759@http://bbpress.org/forums/ <p>Sorry, I don't check this forum daily, so here's a late answer:</p> <p>1. From what I know, it has always been like this. It's only when I perform a search.</p> <p>2. The version is bbPress 0.9.0.2 and it was installed somewhere between june 26 and june 31.</p> <p>3. I didn't. I only screwed around with the template files.</p> <p>4. No, they did no update or change whatsoever.</p> <p>5. Like I said, it was there before the plug-ins, but here's the list.<br /> Private Forums, BBPress Private Messaging (not working), Post Count Plus - Dynamic.Titles &#38; More!, Akismet, Avatar, Last-Post, Limit Latest Discussion, Bozo Users, BBcode Lite, Move It, Quote, Simple Onlinelist, Allow Images, Human Test for bbPress &#38; Front Page Topics.</p> <p>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'.</p> <p>7. Yes. It does happen.</p> <p>The MySQL version is 3.23.58.</p> <p>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. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16671 Mon, 09 Jun 2008 19:32:12 +0000 bobbyh 16671@http://bbpress.org/forums/ <p>Check your mysql version number. Is it really low? </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16667 Mon, 09 Jun 2008 15:52:37 +0000 chrishajer 16667@http://bbpress.org/forums/ <p>Interestingly, I copied and pasted your SQL query from above, and used it on my installation unchanged, and it did not error out, it just return the expected results.</p> <p><code>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 = &#39;0&#39; AND p.post_status = &#39;0&#39; AND ( (t.topic_title LIKE &#39;%ja%&#39;) OR p.post_text LIKE &#39;%ja%&#39; ) GROUP BY t.topic_id ORDER BY t.topic_time DESC LIMIT 20</code></p> <p>See the results <a href="http://www.chrishajer.com/bbpress/sqlerror.png" title="no SQL error here">here</a>.</p> <p>This is an old bbPress installation as well, 1.0-alpha from over a year ago. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16666 Mon, 09 Jun 2008 15:25:17 +0000 chrishajer 16666@http://bbpress.org/forums/ <p>1. Has this installation always been like this, or did something change recently?</p> <p>2. What version are you running and when was it installed?</p> <p>3. Did you change hosting or make any other changes to the installation?</p> <p>4. Did your host upgrade PHP or MySQL or your .htaccess file or something else that would have affected this?</p> <p>5. What plugins are installed, and does disabling them help with the error?</p> <p>6. Does the problem described in the first post happen only when searching, or is that from something else and you now have the problem described in the last post as well?</p> <p>7. Does the problem happen when using the stock theme?</p> <p>You don't have a normal run-of-mill type problem that can be easily and simply solved, so people are going to need more info to help. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16663 Mon, 09 Jun 2008 13:48:29 +0000 bramruiter 16663@http://bbpress.org/forums/ <p>The problem got a bit bigger. When someone tries to find something through the search they get:</p> <p>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]<br /> 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</p> <p>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]<br /> 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 </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16659 Sun, 08 Jun 2008 22:28:49 +0000 chrishajer 16659@http://bbpress.org/forums/ <p>What do you have to do to get that error to show up? Installation, view profile, post a new topic, post a reply, add a tag, etc... </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16657 Sun, 08 Jun 2008 17:39:52 +0000 bramruiter 16657@http://bbpress.org/forums/ <p>bbPress database error: [You have an error in your SQL syntax near 'ON ( t.topic_id = p.topic_id ) WHERE p.post_status != '0' AND t.topic_status = '' at line 1]<br /> SELECT p.* FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_status != '0' AND t.topic_status = '0' ORDER BY p.post_time DESC LIMIT 5</p> <p>What does it mean? </p>