BuddyPress.org

Is this creating the problem: “DEFAULT CHARACTER SET utf8” ??

From the Apache error log, this is the same syntax error I saw earlier when BP was trying to create tables (see earlier posts):

[suexec 11180] Chdir to /kunden/homepages/14/d123456789/htdocs/exploreouroceans

[suexec 11180] Executing PHP4 /usr/lib/cgi-bin/php4 /kunden/homepages/14/d123456789/htdocs/exploreouroceans/index.php

WordPress database error 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 ‘DEFAULT CHARACTER SET utf8’ at line 14 for query CREATE TABLE wp_user_3_activity (

id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

item_id int(11) NOT NULL,

secondary_item_id int(11),

user_id int(11) NOT NULL,

component_name varchar(75) NOT NULL,

component_action varchar(75) NOT NULL,

date_recorded datetime NOT NULL,

is_private tinyint(1) NOT NULL,

KEY item_id (item_id),

KEY user_id (user_id),

KEY is_private (is_private),

KEY component_name (component_name)

) DEFAULT CHARACTER SET utf8; made by dbdelta

Thanks for your reply. I’ve never had to fiddle with mysql user permissions with other WP databases — where is this done? I tried entering, “DEFAULT CHARACTER SET utf8” (sans quotes) manually via phpMyAdmin and received the same syntax error message. Is this a clue or a rabbit hole?

I’m using wordpress-mu-2.6.5 and bp combo beta. No other plug-ins, etc.

Do you have phpMyAdmin running? Can you go to it or whatever Database admin program that your host gives you and then run the following command on your database?

CREATE TABLE wp_user_3_activity (

id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

item_id int(11) NOT NULL,

secondary_item_id int(11),

user_id int(11) NOT NULL,

component_name varchar(75) NOT NULL,

component_action varchar(75) NOT NULL,

date_recorded datetime NOT NULL,

is_private tinyint(1) NOT NULL,

KEY item_id (item_id),

KEY user_id (user_id),

KEY is_private (is_private),

KEY component_name (component_name)

)

See if it will actually create the tables manually?

Hey guys what is this ‘made by dbDelta’ stuff?

It’s in both his err logs near the charset collation spec. That seems to be what mysql is complaining about.

In code it just appends ‘{$charset_collate};’ where did this come from?

This is an Andy question. Modifying bp core is of course a pain to maintain. You, of course, can do anything you like. But…

back to the original part of this topic…was there ever talk of NOT making the 2rd field (recent news) in Group creation a required field? Doesn’t seem so necessary.

@mikepratt I would create a ticket in trac an a future enhancement for that. Might catch on with people as I had trouble creating groups due to that as well. Darn required fields

Hi zenseeker,

You have the following error message on http://www.artistswap.com:

Problem in wp-config.php – $base is set to BASE when it should be the path like “/” or “/blogs/”! Please fix it!

In my opinion you are trying to install WordPress Mu manually , by editing wp-config.php file (just like WordPress) and I think that it’s not really a good method.