Transaction isolation level READ-COMMITTED google_analytics_counter_storage missing primary key.

Created on 23 October 2023, almost 2 years ago

Problem/Motivation

Upgraded to D10 and now have the following on my status report.

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: google_analytics_counter_storage. See the setting MySQL transaction isolation level page for more information.
https://www.drupal.org/docs/getting-started/system-requirements/setting-... →

Steps to reproduce

Upgrade core to D10, visit status report.

Proposed resolution

Add nid as the primary key and create a database update for past users.

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report

Status

Fixed

Version

4.0

Component

Code

Created by

🇺🇸United States NicholasS

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @NicholasS
Open in Jenkins → Open on Drupal.org →
Core: 9.5.x + Environment: PHP 8.1 & MySQL 8
last update almost 2 years ago
8 pass
@nicholass opened merge request.
Comment almost 2 years ago →
🇺🇸United States NicholasS
Comment almost 2 years ago →
🇺🇸United States NicholasS
Status changed to Fixed almost 2 years ago1:26pm 23 October 2023
Comment almost 2 years ago →
🇸🇰Slovakia kaszarobert
Looks good! Thank you for your contribution!
Comment almost 2 years ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024