[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:                       |
---------------------------------+----------------------------------

Comment (by netweb):

 To add some more context:

 This was my Windows PC running native PHP, MariaDB and Apache (i.e. Not
 VVV) at r9683 yesterday:

 {{{
 F:\BuddyPressPS>svn up
 Updating '.':
 U    src\bp-core\bp-core-functions.php
 U    src\bp-loader.php

 Fetching external item into 'src\bp-forums\bbpress':

 Fetching external item into 'src\bp-forums\bbpress\bb-includes\backpress':

 Fetching external item into 'src\bp-forums\bbpress\bb-
 includes\backpress\pomo':
 Updated external to revision 191.

 At revision 361.
 At revision 5670.
 At revision 9683.

 F:\BuddyPressPS>phpunit
 Installing...
 Running as single site... To run multisite, use -c
 tests/phpunit/multisite.xml
 Installing BuddyPress...
 Not running ajax tests... To execute these, use --group ajax.
 PHPUnit 4.2.6 by Sebastian Bergmann.

 Configuration read from F:\BuddyPress\phpunit.xml.dist

 ...............................................................  63 / 951
 (  6%)
 ............................................................... 126 / 951
 ( 13%)
 ............................................................... 189 / 951
 ( 19%)
 }}}

 I was not seeing the WordPress DB error that @JohnJamesJacoby saw
 [https://wordpress.slack.com/archives/buddypress/p1428179994001134 here]
 reported in Slack:
 {{{
 vagrant at vvv:/srv/www/wordpress-develop/src/wp-content/plugins/buddypress$
 phpunit
 Installing...
 Running as single site... To run multisite, use -c
 tests/phpunit/multisite.xml
 Installing BuddyPress...
 WordPress database error Duplicate key name 'meta_key' for query ALTER
 TABLE wptests_bp_notifications_meta ADD KEY meta_key (meta_key) made by
 bp_version_updater, bp_core_install, bp_core_install_notifications,
 dbDelta
 <div id='error'>
             <p class='wpdberror'><strong>WordPress database
 error:</strong> [Duplicate key name 'meta_key']<br />
             <code>ALTER TABLE wptests_bp_notifications_meta ADD KEY
 meta_key (meta_key)</code></p>
             </div>Not running ajax tests. To execute these, use --group
 ajax.
 Not running ms-files tests. To execute these, use --group ms-files.
 Not running external-http tests. To execute these, use --group external-
 http.
 PHPUnit 4.0.20 by Sebastian Bergmann.
 }}}

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