Skip to:
Content
Pages
Categories
Search
Top
Bottom

Database error after upgrade to WP4.3/BP2.3.3

  • @reggie3

    Participant

    10 years ago

    Hi-

    We’re seeing the following httpd log error after upgrading:

    [Fri Aug 28 07:49:46 2015] [error] [client redacted] WordPress database error Can’t DROP ‘meta_key’; check that column/key exists for query ALTER TABLE wp_bp_user_blogs_blogmeta DROP INDEX meta_key made by do_action(‘admin_init’), call_user_func_array, bp_admin_init, do_action(‘bp_admin_init’), call_user_func_array, bp_setup_updater, bp_version_updater, bp_core_install, bp_pre_schema_upgrade, referer: https://redacted.org/wp-admin/

    We’re running WordPress 4.3, BuddyPress 2.3.3, with BuddyPress Widget Theme 1.2.1 on top of BuddyPress Default theme 1.8.1

    The only reference we’ve been able to find is this discussion about recent changes to BuddyPress that deals with switching DB tables to utf8mb4 and talks about using a “meta_key”: https://buddypress.trac.wordpress.org/ticket/6346

    Any insights/suggestions for a fix would be much appreciated!

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

  • @danbp

    Participant

    10 years ago

    Hi @reggie3,

    wp_bp_user_blogs_blogmeta table exist only on a multisite install. Unlike all WP tables while 4.3 update, BP tables structure where’nt modified to utf8mb4 during 2.3.3 update.

    Was the site still in network mode before the update ?

    @djpaul

    Keymaster

    10 years ago

    Hmm. Related to https://buddypress.trac.wordpress.org/changeset/9716/trunk/src/bp-core/admin/bp-core-admin-schema.php and https://buddypress.trac.wordpress.org/changeset/9695


    @reggie3     what version did you upgrade from?

    @reggie3

    Participant

    10 years ago

    @djpaul – We upgraded from WP 4.2 and whatever the BuddyPress version was prior to 2.3.3 (sorry I don’t recall, but we’ve been staying up-to-date, upgrading as new versions become available.)


    @danbp     – Not quite sure I follow your question, but…we upgraded from the Network Admin interface, not the individual site, and then performed a Network upgrade.

    For whatever it’s worth, we do not see this error in any of today’s httpd error logs…

    @djpaul

    Keymaster

    10 years ago

    If the SQL operation was carried out successfully (eventually), BP will have bumped a database version number, and next time, it wouldn’t have checked for schema updates.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error after upgrade to WP4.3/BP2.3.3’ is closed to new replies.

Topic Info

Skip to toolbar