I am getting following error while trying to enable this module

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead in /app/includes/database/database.inc:2227

issue

CommentFileSizeAuthor
#3 2979300-03.patch465 bytesvisabhishek
Screenshot from 2018-06-13 13-35-16.png110.54 KBpoojasharmaece
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

poojasharmaece created an issue. See original summary.

poojasharmaece’s picture

poojasharmaece CreditAttribution: poojasharmaece as a volunteer and commented
Title: Getting Error at the time enabling module » Getting Error while trying to enable module
Issue summary: View changes
visabhishek’s picture

visabhishek CreditAttribution: visabhishek as a volunteer and at Azri Solutions commented
Status: Active » Needs review
FileSize
2979300-03.patch465 bytes

Added not null constraints in the install file.

markusd1984’s picture

markusd1984 CreditAttribution: markusd1984 commented

Thanks @visabhishek, after applying this I had to drop the cmp_permissions table which was created with the first attempt of enable the module and preventing me from enabling it i disabled + applied the patch and then tried to enable it patched.

DatabaseSchemaObjectExistsException: Table cmp_permissions already exists. in DatabaseSchema->createTable() (line 663 of /var/www/html/opigno/includes/database/schema.inc).

Celebrated to early, unfortunately the module seems unusable as it takes ages to load the configuration page listing too many entries. Was hoping i can use it to make a simple menu -> Link item available that currently is not showing (also using admin_menu).