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

Bartuc’s picture

Issue summary: View changes
Bartuc’s picture

Seems 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.

draenen’s picture

Status: Active » Fixed

Fixed with latest push.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

kebz’s picture

Version: » 7.x-1.x-dev
Status: Closed (fixed) » Active

I 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).

Channel Islander’s picture

Status: Active » Closed (fixed)

This is an unrelated issue. Please post a new issue if you would like help.