BuddyPress.org

I seem to be getting some SQL errors after upgrading. Seems to be with the ‘id’ variable and all seem to be related to BP tables. It’s like it’s trying to add another column called ‘id’ and set the primary key to this.
Thoughts?

[error] 27109#0: *212 FastCGI sent in stderr: “PHP message: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bp_activity CHANGE COLUMN id id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_admin_init, do_action(‘bp_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_core_admin_components_settings_handler, bp_core_install, bp_core_install_activity_streams, dbDeltaPHP message: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bp_activity_meta CHANGE COLUMN id id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_admin_init, do_action(‘bp_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_core_admin_components_settings_handler, bp_core_install, bp_core_install_activity_streams, dbDeltaPHP message: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bp_invitations CHANGE COLUMN id id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_admin_init, do_action(‘bp_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_core_admin_components_settings_handler, bp_core_install, bp_core_install_invitations, dbDeltaPHP message: WordPress database error Multiple primary key defined for query ALTER TABLE wp_bp_notifications CHANGE COLUMN id id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_admin_init, do_action(‘bp_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, bp_core_admin_components_settings_handler, bp_core_install, bp_core_install_notifications, dbDeltaPHP message: WordPress database error Multiple primary key defined for query AL

This is a cross-post with this one here: https://wordpress.org/support/topic/insert-buddypress-custom-profile-field/

Short story: I was handed over a migration from Joomla! 2.5 to WordPress, which has Community Builder, User Groups, and certificate generation on the fly for a member site (apparently joomla with cb can do that). I’m planning to use Sensei in order to generate the certificates, as it’s just a template with the user’s full name, registration ID (different from the WP UserID), and signup date.

Users have been migrated using FG Joomla to WordPress with the CB add-on, and so have their CB profiles.

Are you aware if it’s at all possible and/or how to show those fields over to Sensei Certificates? If not, any other suggestion on how to generate such a certificate on the fly? (need multiple certificates that will have to go through courses

Thanks!