[buddypress-trac] [BuddyPress] #1233: Can't create a new group

[buddypress-trac at lists.automattic.com]

#1233: Can't create a new group
------------------------+---------------------------------------------------
Reporter:  netweblogic  |       Owner:       
    Type:  defect       |      Status:  new  
Priority:  blocker      |   Milestone:  1.1.2
Keywords:  groups       |  
------------------------+---------------------------------------------------
 I upgraded to 1.1.1 and I can't create new groups. Error and my solution
 below:

 Error logs say this:
 [15-Oct-2009 02:57:25] WordPress database error: [Field
 'avatar_thumb' doesn't have a default value]
 INSERT INTO wp_bp_groups (
                                         creator_id,
                                         name,
                                         slug,
                                         description,
                                         news,
                                         status,
                                         enable_wire,
                                         enable_forum,
                                         date_created
                                 ) VALUES (
                                         173, 'Forum Testing',
 'forum-testing', 'Test', 'test',
 '', 1, 1, FROM_UNIXTIME(1255546645)
                                 )

 My Solution:
 Change the default values of avatar_thumb and avatar_full:

 ALTER TABLE `wp_bp_groups` CHANGE `date_created` `date_created` DATETIME
 NOT NULL ,
 CHANGE `avatar_thumb` `avatar_thumb` VARCHAR( 250 ) CHARACTER SET utf8
 COLLATE utf8_general_ci NULL DEFAULT NULL ,
 CHANGE `avatar_full` `avatar_full` VARCHAR( 250 ) CHARACTER SET utf8
 COLLATE utf8_general_ci NULL DEFAULT NULL

-- 
Ticket URL: <http://trac.buddypress.org/ticket/1233>
BuddyPress <http://buddypress.org/>
BuddyPress