Received the following error when enabling for the first time:
Original
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'description' can't have a default value: CREATE TABLE {membership_entity_type} ( `id` INT NOT NULL auto_increment COMMENT 'Primary Key: Unique profile type ID.', `type` VARCHAR(32) NOT NULL COMMENT 'The machine-readable name of this membership entity type.', `label` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The human-readable name of this membership entity type.', `weight` INT NOT NULL DEFAULT 0 COMMENT 'The weight of this membership entity type in relation to others.', `description` MEDIUMTEXT NOT NULL DEFAULT '' COMMENT 'A brief description of this type.', `data` LONGTEXT NULL DEFAULT NULL COMMENT 'A serialized array of additional settings.', `status` TINYINT NOT NULL DEFAULT 1 COMMENT 'The exportable status of the entity.', `module` VARCHAR(255) NULL DEFAULT NULL COMMENT 'The name of the providing module if the entity has been defined in code.', PRIMARY KEY (`id`), UNIQUE KEY `type` (`type`), UNIQUE KEY `label` (`label`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores information about all defined membership types ...'; Array ( ) in db_create_table() (line 2717 of [docroot]/includes/database/database.inc).
Additional
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cema.membership_entity_type' doesn't exist: SELECT t.id AS id, t.type AS type, t.label AS label, t.description AS description FROM {membership_entity_type} t; Array ( ) in membership_entity_type_get_types() (line 225 of [docroot]/sites/all/modules/contrib/membership_entity/modules/membership_entity_type/membership_entity_type.module).
Comments
Comment #1
Bartuc commentedComment #2
Bartuc commentedSeems to work just fine when I enable just membership entity. The exception above happened when I checked all 3 modules (Membership Entity Types, Membership Entity Terms, and Membership Entity) at once.
Found the issue to be enabling Membership Entity Types.
Comment #3
draenen commentedFixed with latest push.
Comment #5
kebz commentedI am unable to access the "Memberships" link =\
When I click on the button, I get this error message below
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbxxxxx.membership_entity' doesn't exist: SELECT type FROM membership_entity WHERE mid = :mid; Array ( [:mid] => 1 ) in views_handler_field_membership_term_datetime->render() (line 51 of /sites/all/modules/membership_entity/modules/membership_entity_term/views/views_handler_field_membership_term_datetime.inc).
Comment #6
Channel Islander commentedThis is an unrelated issue. Please post a new issue if you would like help.