BuddyPress.org

@imjscn

Thanks for your reply.

If I copy/paste the code on my page I get the following error:

Parse error: syntax error, unexpected T_ELSE in /home/domain.nl/public_html/page.php on line 204

Just to be clear I dont want the login form on a wordpress/bp page but on my own site.

Hope you can help

my main motive of keeping single database is to give access to both domains even if the open english version one domain still they could get access in site.Also i am installing wordpress on both domains individually

Well, I do really like Edublogs, but there are many options I would like to tweak. I do have a lot of WordPress experience, but not that much MultiSite/BP experience. I was planning on using WPMU Dev Premium.

I don’t need to host thousands of uses (yet =] )

Think its practical?

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`

Well, I definitely had PHP 4.3 or better, MySQL 4.1.2 or better, and Apache Module mod_rewrite enabled for “pretty permalinks”. I had installed it a couple of times over before that, but I can’t remember whether I tested the clickthrough to the single hello world post for that (just saw the home page and that the dashboard worked), so I wouldn’t know whether I had a fully stable WordPress install to begin with.

I’ll give the reinstall a try and report the results for posterity in this thread.

you say: stay single WP installation,

but other than my main blog, brand new install? hence my main blog if for it purpose…

I do not want users create a blog/site of their own.