Contrib.social

Error on site:install - Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set.

Open on Drupal.org →
Created on 18 February 2025, 4 months ago

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.

🐛 Bug report
Status

Active

Version

3.0

Component

Code

Created by

wotts

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024