Forum Replies Created
-
Hi,
Integration with wordpress can seem a bit complicated. I really suggest watching this :
https://bbpress.org/forums/topic/basic-integration-screencast
The only difference is he is running an older version – but the process is pretty much identical. Instead of looking for the salt keys as he did though, you will see that they are generated for you and you can just paste them in (you’ll see what I mean).
Hope that helps!
I’m not sure if it’s any help but the only clue I have is the error report pasted in the 3rd post. Whatever line of code was attempting to create the bb_posts table was conflicting or producing an error with my version of MySQL.
Hi guys, I found a solution and credited this thread here:
Check your database tables and make sure all of the necessary tables for bbPress have been created in your installation. In my case I was missing the bb_post table (the one involved in actually posting a topic) – it was failing to install properly due to an error in MySQL syntax – all explained in my thread. By downgrading my MySQL version I was able to install bbPress successfully – the missing table (bb_post) was created and I was then able to post forum topics in my groups without any error!
I may have found another solution to this problem here:
Check your database tables and make sure all of the necessary tables for bbPress have been created in your installation. In my case I was missing the bb_post table (the one involved in actually posting a topic) – it was failing to install properly due to an error in MySQL syntax – all explained in my thread. By downgrading my MySQL version I was able to install bbPress succesfully – the missing table (bb_post) was created and I was then able to post forum topics in my groups without any error!
I found a solution to this problem here:
Check your database tables and make sure all of the necessary tables for bbPress have been created in your installation. In my case I was missing the bb_post table (the one involved in actually posting a topic) – it was failing to install properly due to an error in MySQL syntax – all explained in my thread. By downgrading my MySQL version I was able to install bbPress succesfully – the missing table (bb_post) was created and I was then able to post forum topics in my groups without any error!
SUCCESS!
I just made my first successful Group/Forum post in the past 2 days of troubleshooting!
The solution : Downgraded my version of MySQL – as the newer(or newest) version has known hiccups with some people in creating database tables (in this case, my installation was failing to create bb_posts) :
By downgrading my version of MySQL I was able to successfully install bbPress with a fresh copy (I did this manually but am positive it would work with single-click installation as well) – and the missing table (bb_posts) was created during my fresh installation.
I sincerely hope this helps someone else out there as I know the ‘error creating topic’ dilemma has affected many people and there are lots of different solutions. Some of us simply need to try the methods mentioned in other threads (deleting forum_id value, or re-enabling forum option in group admin) –
Others are actually dealing with database issues, including missing table(s). This was my case, and I was missing that table because of a MySQL syntax error during installation of bbPress – fixed by downgrading my MySQL version on my WAMP server. (Hate to repeat myself but I know it’s important to be clear).
I have to thank the posters in the thread I linked in the OP for suggesting a manual installation (and hnla for linking to that thread in another topic) – it was by doing a manual installation that I was able to see the error report and pinpoint which database table in particular was failing to install properly, and why (MySQL syntax error).
As for your question on the versions I am using, hnla:
I am running WordPress 3.1 with BuddyPress 1.2.7 and bbPress 1.0.3.
My server is WAMP Server 2.Well – I’ve made progress already : I did a clean re-install of WordPress, then bbPress –
Doing a manual install of bbPress is helpful (for those having issues) because if there are any issues with installation (which may be occuring during a single click install as well) it will be laid out in the post-installation error report. I’m sure there is an error report log somewhere after a single-click installation I just haven’t bothered to look for one –
In any case I googled the error coming up on my report :
`You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16`
and found mention of errors with SQL syntax involving utf8 on many other sites (not just for bbpress) – the general consensus is that the newer version(s) of MYsQL sometimes have hiccups with utf8 during table creation (I have no idea why). In particular I am running a WAMP server with MySQL version 5.5.8
Seeing as BuddyPress has a min. requirement of MySQL version 4.x (something, hehe) – I figured I would try to run a manual install with a lower version of MySQL, so I installed 5.1.40 (arbitrary, could have used any version I’m sure) : WAMP Server 2 makes this very easy by the way, simply mouse over your MySQL -> Version -> and click ‘More’. You can then toggle between versions.
In any case, with MySQL 5.1.40 installed I was able to do the manual install and there were no errors reported! And checking my database I now see that bb_posts was successfully installed!
Testing now to see if this made any changes in the forum errors I’ve been having with bbPress + BuddyPress.
@hnla –
Thanks! I was sure I was missing at least one or many database tables, and I suppose my error report from the manual install is making it clear that I’m missing bb_posts.
Manual installation of bbpress consists of downloading it in a zip (available on the bbpress site) installing it on the server much like wordpress was installed – and then integrating it with wordpress (which allows it later to be used with buddypress):
The guide I use for manual installation and wordpress integration:
http://www.wpmods.com/integrate-wordpress-bbpress
I always successfully install bbpress but not without the above posted errors. Although manual installation was suggested as a fix to the common posting errors problem it makes no difference for me as the database table “bb_posts” fails to be created whether I do a single-click install or manual.
As for your statement
`It’s not wasting peoples time to suggest all possible solutions to a problem that is difficult to pin down to an exact cause`– I created this thread specifically for people who have pinned down part of the problem – namely that we are missing database table(s) after installation. So maybe we can tackle whatever is causing that issue in particular.
*EDIT*
NOTICE: SOLUTION TO MY PROBLEM HAS BEEN FOUND AND POSTED ON 7TH POST ON THIS PAGE
*Old Post* :
So – finished the manual install and still got the errors – can anyone make sense of them? And are they related to or do they explain the missing database tables?
`SQL ERROR!
>>> Database: wordpress (localhost)
>>>>>> CREATE TABLE IF NOT EXISTS `bb_posts` (
`post_id` bigint(20) NOT NULL auto_increment,
`forum_id` int(10) NOT NULL default 1,
`topic_id` bigint(20) NOT NULL default 1,
`poster_id` int(10) NOT NULL default 0,
`post_text` text NOT NULL,
`post_time` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`poster_ip` varchar(15) NOT NULL default ”,
`post_status` tinyint(1) NOT NULL default 0,
`post_position` bigint(20) NOT NULL default 0,
PRIMARY KEY (`post_id`),
KEY `topic_time` (`topic_id`, `post_time`),
KEY `poster_time` (`poster_id`, `post_time`),
KEY `post_time` (`post_time`),
FULLTEXT KEY `post_text` (`post_text`)
) TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8’;
>>>>>> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16`
