When installing the Quiz Question module (version 7.x-5.0-beta2 on the latest MySQL Comminity version 5.7.9 got this error:
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: CREATE TABLE {quiz_question_properties} ( `qqp_id` INT auto_increment DEFAULT NULL COMMENT 'The primary identifier for this Question.', `nid` INT unsigned NOT NULL COMMENT 'The node ID of this Question.', `vid` INT unsigned NOT NULL COMMENT 'The version ID of this Question.', `max_score` INT unsigned DEFAULT 0 COMMENT 'The unscaled max score of this Question.', `feedback` TEXT NULL DEFAULT NULL COMMENT 'The generic feedback text to show for this Question.', `feedback_format` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Text format for the feedback text.', PRIMARY KEY (`qqp_id`), INDEX `question_id` (`vid`, `nid`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Properties common for all quizzes'; Array ( ) in db_create_table() (line 2720 of /Users/kandyba/Sites/mbl/docroot/includes/database/database.inc).

Apparently the quiz_question_properties schema needs to be adjusted slightlly.

Steps to reproduce:
MySQL version: 5.7.9 (tested against it specifically, but any 5.7.x version will do)
Module to install: Quiz Question 7.x-5.x-beta2 (or latest dev)

Comments

meramo created an issue. See original summary.

meramo’s picture

Title: Compatibility with MySQL 5.7.9 » Compatibility with MySQL 5.7.x
meramo’s picture

Version: 7.x-5.0-beta2 » 7.x-5.x-dev
StatusFileSize
new525 bytes

Patch attached. Any feedback is welcomed

meramo’s picture

Issue summary: View changes
meramo’s picture

StatusFileSize
new910 bytes

During the testing found another place

djdevin’s picture

Status: Active » Needs review
djdevin’s picture

StatusFileSize
new1.78 KB

Thanks, I found a few more in the update hooks (just in case someone is going from 4-5).

  • djdevin committed f3c8abf on 7.x-5.x authored by meramo
    Issue #2617044 by meramo, djdevin: Compatibility with MySQL 5.7.x
    
djdevin’s picture

Status: Needs review » Fixed

Thanks!

The D7 testbots are up to MySQL 5.6, 5.7 would be nice...

Status: Fixed » Closed (fixed)

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