Topic: Error after upgrading.

Error after upgrading.

teleputer
Participant

@teleputer

4 years, 4 months ago

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

Viewing 4 replies - 1 through 4 (of 4 total)

John

Participant

@thesun2012

4 years, 3 months ago

I get the errors while enabling/disabling the components, I’m using the Buddypress newest version: 6.1.0

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_activity CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_activity_meta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_invitations CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_notifications CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_notifications_meta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_friends CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_groups CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_groups_members CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_groups_groupmeta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_messages_messages CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_messages_recipients CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_messages_notices CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_messages_meta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_xprofile_groups CHANGE COLUMN <code>id</code> id bigint(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_xprofile_fields CHANGE COLUMN <code>id</code> id bigint(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_xprofile_data CHANGE COLUMN <code>id</code> id bigint(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_xprofile_meta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_user_blogs CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

WordPress database error: [Multiple primary key defined]
ALTER TABLE wp_bp_user_blogs_blogmeta CHANGE COLUMN <code>id</code> id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY

Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/workspace/wordpress/wp-includes/wp-db.php:1491) in /home/xxx/workspace/wordpress/wp-includes/pluggable.php on line 1281

Warning: Cannot modify header information - headers already sent by (output started at /home/xxx/workspace/wordpress/wp-includes/wp-db.php:1491) in /home/xxx/workspace/wordpress/wp-includes/pluggable.php on line 1284