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)
| Comment | File | Size | Author |
|---|---|---|---|
| #7 | compatibility_with-2617044-7.patch | 1.78 KB | djdevin |
| #5 | quiz-mysql5.7_support-2617044-2.patch | 910 bytes | meramo |
| #3 | quiz-mysql5.7_support-2617044-1.patch | 525 bytes | meramo |
Comments
Comment #2
meramo commentedComment #3
meramo commentedPatch attached. Any feedback is welcomed
Comment #4
meramo commentedComment #5
meramo commentedDuring the testing found another place
Comment #6
djdevinComment #7
djdevinThanks, I found a few more in the update hooks (just in case someone is going from 4-5).
Comment #9
djdevinThanks!
The D7 testbots are up to MySQL 5.6, 5.7 would be nice...