BuddyPress.org

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.

@hnla check the 2nd forum

well i visited it required premium membership . if anyone have this plugin then provide me. or a plugin same looks like facebook if anyone have then gimme

@hnla
i want plugins for

1 = If you have any buddypress version in portuguese then give me link or give me any plugin by which i can provide interface to the users who speak portuguese in their language as i have installed buddypress for one domain in english language. and on other domain i will install buddypress in portguese.
2 – Comment Notifiar which works in real time which can compute nano seconds too.
3 = any plugin which can do object caching in real time.
4 = live stream plugin which could stream the site in real time.

Buddy I want To KNow Can I Install 2 seperate WP on single database ? i just want to integrate 2 different domains on single database . my bandwidth is unlimited using dedicated + reseller host.
Main reason is i want to install one buddypress in english lang and other in portguese. so suggest me what i should do.
i want to use 2 different domains and want to use 1 single databases for both domains. is there any way ?

@auctionbeats
Thanks for your interest in Buddyvents!
We use PayPal as our payment gateway and the Euros will automatically be converted to US Dollars when you pay.
Something similar to the ZIP code search is already possible. Users can enter an address and specify a radius. Not sure how well this works with just the ZIP code, but you could try that before comissioning an add-on