http://bbpress.org/forums/ bbPress support forums Topic: bbPress posts from WP en Wed, 03 Dec 2008 03:18:29 +0000 http://bbpress.org/forums/topic/bbpress-posts-from-wp#post-1166 Mon, 06 Nov 2006 23:26:24 +0000 Trent 1166@http://bbpress.org/forums/ <p>I managed to change around the mySQL queries a bit and got this plugin working with my site (except a few small things I can't fix myself) and it seems to be fine for posting the Wordpress posts in bbPress and placing a link. It wouldn't be a problem if I didn't have an old mySQL database! </p> http://bbpress.org/forums/topic/bbpress-posts-from-wp#post-1113 Sun, 05 Nov 2006 20:14:42 +0000 Trent 1113@http://bbpress.org/forums/ <p>I have talked it over with the author of the plugin and we are trying to figure out some code for older mySQL databases. He wrote the plugin for mySQL over version 4 and I have 3.23.58. While the plugin works for me (with many errors) I just need to make a couple of changes to the mySQL statements in the plugin to get rid of the errors. </p> <p>The plugin in question is located at:</p> <p><a href="http://dev.mbzeus.net/downloads/bbpress_post_en.zip" rel="nofollow">http://dev.mbzeus.net/downloads/bbpress_post_en.zip</a></p> <p>The first error I recieved was on the 'admin page':</p> <p><code>WordPress database error: [You have an error in your SQL syntax near<br /> &#39;; &#39; at line 1]<br /> SELECT forum_id,forum_name FROM </code>bb_forums<code> ;</code></p> <p>The second errors were when I tried posting a topic in wordpress:</p> <p><code>WordPress database error: [You have an error in your SQL syntax near<br /> &#39;; &#39; at line 1]<br /> SELECT post_id FROM </code>bb_posts<code> WHERE </code>forum_id<code>=21 AND </code>topic_id<code>=242<br /> AND </code>poster_id<code>=14 AND </code>post_time<code> = &#39;2006-11-05 07:20:10&#39; LIMIT 1;<br /> WordPress database error: [You have an error in your SQL syntax near<br /> &#39;</code>topic_posts<code>=1 WHERE </code>topic_id<code>=242 LIMIT 1&#39; at line 1]<br /> UPDATE </code>bb_topics<code> SET </code>topic_last_post_id<code>=,</code>topic_posts<code>=1 WHERE<br /> </code>topic_id<code>=242 LIMIT 1;<br /> Warning: Cannot modify header information - headers already sent by<br /> (output started at/www/html/wp-includes/wp-db.php:104) in<br /> /www/html/wp-includes/pluggable-functions.php on line 269</code></p> <p>If anyone could help me with this I would be greatly appreciated. I am sure it is just changing around the mySQL statements in their formatting, but I can't seem to figure it out! </p> http://bbpress.org/forums/topic/bbpress-posts-from-wp#post-754 Sun, 29 Oct 2006 07:59:08 +0000 mbyte 754@http://bbpress.org/forums/ <p>I wroted plugin for WP, which create topic and post in bbPres forum, when you publish post in WP blog. Plugin can edit post in bbPress forum, when you edit it in WP.<br /> <a href="http://dev.mbzeus.net/">Page of plugin.</a></p> <p>Sorry for my English. </p>