[buddypress-trac] [BuddyPress Trac] #6346: Upgrade DB tables to utf8mb4

[buddypress-trac]

#6346: Upgrade DB tables to utf8mb4
---------------------------------+----------------------------------
 Reporter:  DJPaul               |       Owner:
     Type:  enhancement          |      Status:  new
 Priority:  normal               |   Milestone:  Under Consideration
Component:  Component - Any/All  |     Version:
 Severity:  major                |  Resolution:
 Keywords:                       |
---------------------------------+----------------------------------
Changes (by netweb):

 * severity:  normal => major
 * milestone:  Future Release => Under Consideration


Comment:

 I just had the following notices on an existing install after svn up'ing
 this morning:

 {{{
 WordPress database error: [Duplicate key name 'meta_key']
 ALTER TABLE wp_bp_activity_meta ADD KEY meta_key (meta_key(191))

 WordPress database error: [Duplicate key name 'meta_key']
 ALTER TABLE wp_bp_groups_groupmeta ADD KEY meta_key (meta_key(191))

 WordPress database error: [Duplicate key name 'meta_key']
 ALTER TABLE wp_bp_xprofile_meta ADD KEY meta_key (meta_key(191))

 WordPress database error: [Duplicate key name 'meta_key']
 ALTER TABLE wp_bp_user_blogs_blogmeta ADD KEY meta_key (meta_key(191))
 }}}

 That's 4 of the 6 in r9695

 BuddyPress was already activated so these alter db queries did not occur
 because it was a "new installation" per the commit message of r9695, these
 occurred on an existing installation.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6346#comment:6>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac