Primary keys missing

Created on 26 October 2023, about 1 year ago
Updated 9 November 2023, about 1 year ago

Problem/Motivation

Primary keys are missing from the publishing_options_bundles and publishing_options_option_node tables. This causes the following warning on the status page:

Transaction isolation level
REPEATABLE-READ
The recommended level for Drupal is "READ COMMITTED". For this to work correctly, all tables must have a primary key. The following table(s) do not have a primary key: publishing_options_bundles, publishing_options_option_node. See the setting MySQL transaction isolation level page for more information.

Steps to reproduce

Install module and have db stet to READ COMMITTED. Navigate to the /admin/reports/status page.

Proposed resolution

Update schema definition and add update hook in publishing_options.install file.

✨ Feature request
Status

Needs review

Version

2.0

Component

Code

Created by

🇺🇸United States mizage@gmail.com

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

Comments & Activities

Production build 0.71.5 2024