[buddypress-trac] [BuddyPress Trac] #6036: MySQL Strict Mode

[buddypress-trac]

#6036: MySQL Strict Mode
------------------------------+-----------------
 Reporter:  imath             |      Owner:
     Type:  defect (bug)      |     Status:  new
 Priority:  normal            |  Milestone:  2.2
Component:  Warnings/Notices  |    Version:
 Severity:  normal            |   Keywords:
------------------------------+-----------------
 Since [https://core.trac.wordpress.org/changeset/30400 WP changeset 30400]
 WPDB: Force {{{STRICT_ALL_TABLES}}}. Although i didn't see any warning
 using BuddyPress so far, i've noticed a test was failing in
 tests/phpunit/testcases/groups/cache.php :
 {{{BP_Tests_Group_Cache->test_groups_get_group_admins_cache}}}

 The problem in the test is that it's running groups_promote_member() on a
 user that is not yet a member. So some fields are not set in the db.

 As boonebgorges suggested, this ticket can act as a catch-all for fixing
 our INSERT/UPDATE statements so that they're strict-mode compatible.

 For now i'll attach the patch i suggest for the unit test to fix the
 Database error it's generating.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6036>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac