BuddyPress.org

Getting these errors in the apache logs… something’s b0rked!

[Mon Mar 29 09:48:09 2010] [error] [client 127.0.0.1] WordPress database error Table 'sitename_wpmu_buddypress.bb-attachments' doesn't exist for query SELECT * FROM 'bb-attachments' made by require_once, require, do_action, call_user_func_array, bp_forum_attachments_check_installed, referer: http://localhost.localdomain/sitename/wp-admin/

[Mon Mar 29 09:48:09 2010] [error] [client 127.0.0.1] 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 ''ext' 'ext' VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,' at line 2 for query ALTER TABLE bb_attachments DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci,nCHANGE 'ext' 'ext' VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,nCHANGE 'mime' 'mime' VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,nCHANGE 'filename' 'filename' VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL made by require_once, require, do_action, call_user_func_array, bp_forum_attachments_check_installed, bb_attachments_install, referer: http://localhost.localdomain/sitename/wp-admin/

The bb-attachments table does exist, though, and is populated with data.

You’re talking about separating your WordPress blog from BuddyPress?

If you’re using WPMU, you can do this:

https://codex.buddypress.org/how-to-guides/install-buddypress-on-a-secondary-blog/

On the roadmap for post-1.3, the team is going to look at WordPress user roles with a view to integrating them.

@warut

Once you’ve done what Bowe has said.

You will need to know how to use SVN or you can use a SVN client.

If you’re using Windows, TortoiseSVN is the most popular SVN program..

Here’s a nice tutorial for Tortoise:

http://weblogtoolscollection.com/archives/2007/06/17/listing-your-plugin-at-the-wordpressorg-plugin-directory/

You should have a WordPress account and then go to:

https://wordpress.org/extend/plugins/add/

Submit your plugin, and it will get added to the repository after it has been approved.. this will take a short while

@beeza

Did you create a directory ‘bb-attachments’ one level above your WP root as per the instructions here?

https://wordpress.org/extend/plugins/forum-attachments-for-buddypress/installation/

https://wordpress.org/extend/plugins/forum-attachments-for-buddypress/ – you can upload different file types … images, swf, etc.

edit- depends on what kind of attachment site admin allows, of course.

This might also be a great solution here: http://justintadlock.com/archives/2009/09/17/members-wordpress-plugin

I think it’s easily extensible, for example gravity forms uses it’s power:

Role Management Integration

Gravity Forms is compatible with Justin Tadlock’s Members plugin for role management. Have granular control over what users can and can’t do within Gravity Forms.

I agree there is a need for a user role just under Site Admin.

I don’t think the BP team needs to address it though. I also think it should be plugin based.

User roles internal to WordPress are due for an overhaul, but it’s been pushed back a bit.

You could sort of tackle this via the Menus plugin for MU. That’d be a bit kludgey though.

testbp now runs regular WordPress, not MU, which is why that has “disappeared.”

the avatar has vanished from my site too with the new version.

i dont have Settings -> Miscellaneous Settings in my wordpress MU version:(

Thanks Ray:) You’re right I rarely do come in here as all I ever hear is problems, lol:)

@heathj85 – Make sure you installed it correctly. Meaning that there was a bp-chat/config/bp-chat-config.php file created and it’s contents are right. If not you would get this error as well. But few people do. Although reasons you might get it are:

1. You don’t allow table creation for the wordpress user/password in wp-config

2. You didn’t chmod 777 the config directory on install

3. Your information in bp-chat-config.php is wrong or not present.

Hope that helps.

Thanks,

Dave

The only one I found is: https://wordpress.org/extend/plugins/buddypress-like/

It only does “thumbs up” (like) but no “thumbs down” but does work with the activity stream.

Gene

I use BlueHost. Your friend was talking about the WPMU + BP installation via SimpleScripts (kind of like Fantastico de Luxe, but much more responsive to upgrades).

SimpleScripts calls it “BuddyPress”, but it is really BP + WPMU.

I used SimpleScripts to do my initial BP + WPMU installation. I had a complete site failure yesterday when I upgraded to the most recent BP version. I also had some bugs creating user blogs with the original installation.

I think SimpleScripts automatically configures WPMU to create user blogs as subdomains. For this to work, your hosting provider MUST support “wildcarding”. When opened a support ticket with BlueHost to do this, they quickly replied: “No our system does not support wildcarding.”

If you were creating your own blogs as subdomains, this would not be a problem because you could use the DNS tool (e.g. cPanel > Simple DNS Zone Editor) to support define each one when you create it. But, it seems likely you’re using WPMU to support multiple users. In that case, it would be nearly impossible to define a new subdomain each time your users created a new blog. The wildcard gets you out of that predicament by immediately supporting any subdomain when they create the blog.

If you install WPMU + BP manually, you don’t need a hosting provider that supports wildcarding. During the configuration, just select the option to create user blogs as *subdirectories* instead of subdomains.

I did the manual installation for the first time today. I don’t think I’ll need the SimpleScripts approach again.

Hope this helps.

@MrMaz I’ve got some good news for you. While I still can’t get the avatars to work via the thumbnail chooser, I have gotten avatars to work on a single wordpress install when choosing to “Customize” the link’s avatar. In my case it can crop the image and upload the thumbnail and fullsize pic to /wp-content/uploads/link-avatars/

In case this helps anyone else… I had to use the “Full URL path” in wordpress’ Settings > Miscellaneous to get BuddyPress user avatars to upload (in case someone wants to use a different avatar than their Gravatar)

Full URL path example: http://www.mysite.com/wp-content/uploads