When installing the module with mysql 5.7 the following error occurs:

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                                      [error]
/var/www/html/includes/database/database.inc:2227
Stack trace:
#0 /var/www/html/includes/database/database.inc(2227): PDOStatement->execute(Array)
#1 /var/www/html/includes/database/database.inc(697): DatabaseStatementBase->execute(Array, Array)
#2 /var/www/html/includes/database/schema.inc(667): DatabaseConnection->query('CREATE TABLE {a...')
#3 /var/www/html/includes/database/database.inc(2776): DatabaseSchema->createTable('amber_cache', Array)
#4 /var/www/html/includes/common.inc(7114): db_create_table('amber_cache', Array)

This error is caused by the enhancements of mysql 5.7 that also bring some compatibility problems.

CommentFileSizeAuthor
#4 amber-mysql5.7_compatibility-2945946-4.patch1.22 KBrevagomes
#3 amber-mysql5.7_compatibility-2945946-3.patch720 bytesrevagomes
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

revagomes created an issue. See original summary.

revagomes’s picture

revagomes CreditAttribution: revagomes as a volunteer commented
revagomes’s picture

revagomes CreditAttribution: revagomes as a volunteer commented
Status: Active » Needs review
FileSize
amber-mysql5.7_compatibility-2945946-3.patch720 bytes

This patch add a 'not null' => TRUE, to the 'provider' field.

revagomes’s picture

revagomes CreditAttribution: revagomes as a volunteer commented
Version: 7.x-1.0 » 7.x-1.x-dev
FileSize
amber-mysql5.7_compatibility-2945946-4.patch1.22 KB

I've updated the patch to also add the update hook.