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.
The plugin in question is located at:
http://dev.mbzeus.net/downloads/bbpress_post_en.zip
The first error I recieved was on the ‘admin page’:
WordPress database error: [You have an error in your SQL syntax near
'; ' at line 1]
SELECT forum_id,forum_name FROM bb_forums ;
The second errors were when I tried posting a topic in wordpress:
WordPress database error: [You have an error in your SQL syntax near
'; ' at line 1]
SELECT post_id FROM bb_posts WHERE
forum_id=21 AND
topic_id=242
AND poster_id=14 AND
post_time = '2006-11-05 07:20:10' LIMIT 1;
WordPress database error: [You have an error in your SQL syntax near
'topic_posts=1 WHERE
topic_id=242 LIMIT 1' at line 1]
UPDATE bb_topics SET
topic_last_post_id=,
topic_posts=1 WHERE
topic_id=242 LIMIT 1;
Warning: Cannot modify header information - headers already sent by
(output started at/www/html/wp-includes/wp-db.php:104) in
/www/html/wp-includes/pluggable-functions.php on line 269
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!