On D10, when doing a drush site:install we encountered this error:
In ExceptionHandler.php line 56:
SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key t
o the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult y
our DBA before changing this setting.: CREATE TABLE "s3fs_file" (
"uri" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The S3 URI of the file.',
"filesize" BIGINT unsigned NOT NULL DEFAULT 0 COMMENT 'The size of the file in bytes.',
"timestamp" INT unsigned NOT NULL DEFAULT 0 COMMENT 'UNIX timestamp for when the file was added.',
"dir" INT NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether or not this object is a directory.',
"version" VARCHAR(255) NULL DEFAULT '' COMMENT 'The S3 VersionId of the object.',
INDEX "timestamp" ("timestamp")
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Stores metadata about files in S3.'; Array
(
)
I've attached a patch which isn't a fix per se, but allowed us to do a site install.
Active
3.0
Code
D.O. has migrated away from patch files.
In order for tests to run we require all submissions to be in the form of a Merge Request.
More details may be found at: https://www.drupal.org/docs/develop/git/using-gitlab-to-contribute-to-dr... →