My php error logs are showing the following after updating:

[30-Jun-2010 16:29:36] WordPress database error Table ‘db_name.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, W3_Db->query
[30-Jun-2010 16:29:36] 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,
CHANGE ‘ext’ ‘ext’ VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
CHANGE ‘mime’ ‘mime’ VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
CHANGE ‘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, W3_Db->query

Disabling and re-enabling W3 Total Cache plugin, and enabling group forum extra, and the problem seems to be resolved. No more db errors.

[@r-a-y Keymaster 14 years, 6 months ago]

Read this:
https://buddypress.org/community/groups/creating-extending/forum/topic/forum-attachments-for-buddypress-bb-attachments-errors/

[EDIT]
Okay, glad you fixed it. Curious to know what options you were using for W3 Total Cache?

[@lph2005 Participant 14 years, 6 months ago]

Thanks r-a-y !

Turns out I disabled and re-enabled and this solved the errors. I must have done the update to my post as you were answering me.

[@lph2005 Participant 14 years, 6 months ago]

Well, after disabling a few other items from the site – guess what returned? Yes and I can’t get this one fixed … .

The table bb-attachments is definitely in the database.
Disabling plugins to see if there is a conflict with one.

[@boonebgorges Keymaster 14 years, 6 months ago]

@LPH2005 – It looks like the plugin is trying to create the table. I don’t think it should be doing that every time you load. I will have a closer look when I get a chance and see if I can reproduce.

[@lph2005 Participant 14 years, 6 months ago]

OK. I looked at line 9 of forum-attachments-for-buddypress-bp-functions.php

$results = $wpdb->query( “SELECT * FROM `bb-attachments`” );

Made a change to the last ` … and now the error is gone. Maybe it was just the resaving of the file … dunno

[@boonebgorges Keymaster 14 years, 6 months ago]

Woo hoo! Quite possible that that’s a bug in the original plugin (though I’m not sure how it snuck through)