Transaction isolation level

Created on 31 August 2024, 3 months ago
Updated 5 September 2024, 3 months ago

Problem/Motivation

Errors found
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: wt_dates. See the setting MySQL transaction isolation level page for more information.

Steps to reproduce

A fresh install of Drupal 10.3.2 on Ubuntu 24.04 with nginx/1.24.0, MySQL 8.0.39-0ubuntu0.24.04.2 and PHP 8.3.6.
After an install of Webtrees with shared database I receive the above status report error.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Closed: works as designed

Version

2.5

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States srandolph

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

Comments & Activities

  • Issue created by @srandolph
  • Status changed to Closed: works as designed 3 months ago
  • πŸ‡ΊπŸ‡ΈUnited States bwong

    The wt_dates table is part of Webtrees. The d_index field should be a primary key. If not, you can set it as the primary. My install had the field as the primary key. Not sure which instance of Webtrees you installed.

Production build 0.71.5 2024