Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6
-
Fix Version/s: 4.6.1
-
Component/s: None
-
Labels:None
-
Documentation Required?:None
Description
On upgrading I get
ALTER TABLE `civicrm_membership_block` CHANGE `membership_types` `membership_types` VARCHAR( 1024 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Membership types to be exposed by this block.' [nativecode=1265 ** Data truncated for column 'membership_types' at row 5]
This is in response to sql added in;
https://issues.civicrm.org/jira/browse/CRM-16018
I'm not sure why but the database I'm looking at has membership_blocks with null for membership_types. Perhaps a type was deleted at some stage.
Since the schema does not define this as a required field I believe the 'NOT NULL' needs to go.