Contrib.social

install - error on create table

Open on Drupal.org →
Created on 8 February 2018, about 7 years ago
Updated 3 November 2024, 5 months ago

Problem/Motivation

Hello,

I get an error during the install :

Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Here the create table :
CREATE TABLE {nodeaccess} (
`nid` INT unsigned NOT NULL DEFAULT 0,
`gid` INT unsigned NOT NULL DEFAULT 0,
`realm` VARCHAR(255) NOT NULL DEFAULT '',
`grant_view` TINYINT unsigned NOT NULL DEFAULT 0,
`grant_update` TINYINT unsigned NOT NULL DEFAULT 0,
`grant_delete` TINYINT unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`nid`, `gid`, `realm`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4;

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

Introduced terminology

API changes

Data model changes

Release notes snippet

🐛 Bug report
Status

Postponed: needs info

Version

11.0 🔥

Component

database system

Created by

🇧🇪Belgium philalawst

Live updates comments and jobs are added and updated live.
  • Needs issue summary update

    Issue summaries save everyone time if they are kept up-to-date. See Update issue summary task instructions.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment 5 months ago →
    🇳🇿New Zealand quietone

    Since there has been not activity here for 5 years, I am checking in to get confirmation that this is still a problem. Is it?

    I found several related issues which are all closed, so perhaps this one should be closed as well. I am setting the status at Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

    Thanks!

  • Status changed to Closed: outdated about 1 month ago
  • Comment about 1 month ago →
    🇺🇸United States smustgrave

    Since there hasn't been any follow up going to close out, if still an issue please reopen.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024