Missing primary key in table `restrict_ip_paths' and `restrict_ip_whitelisted_ip_addresses'

Created on 7 September 2023, about 1 year ago
Updated 29 August 2024, 3 months ago

Hi,

When the Transaction Level in MariaDB is set to READ-COMMITTED, the following warning appears on the report page (/admin/reports/status).

TRANSACTION ISOLATION LEVEL
READ-COMMITTED
For this to work correctly, all tables must have a primary key. The following table(s) do not have a primary key: forum_index, honeypot_user, restrict_ip_paths, restrict_ip_whitelisted_ip_addresses. See the setting MySQL transaction isolation level page for more information.

# My site is on Drupal version 10.1.2.

Reference URL:
https://www.drupal.org/docs/getting-started/system-requirements/setting-the-mysql-transaction-isolation-level

Can you please consider supporting this?

🐛 Bug report
Status

Needs review

Version

4.0

Component

Code

Created by

🇯🇵Japan Ryo Ichiyama

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

Merge Requests

Comments & Activities

Production build 0.71.5 2024