Mysql read-committed

Created on 1 May 2023, over 1 year ago
Updated 13 May 2023, over 1 year ago

Problem/Motivation

MYSQL READ-COMMITTED
For this to work correctly, all tables must have a primary key. The following table(s) do not have a primary key: regcode_users. See the setting MySQL transaction isolation level page β†’ for more information.

Drupal 9.5.8
php8.1

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Closed: works as designed

Version

1.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

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

Comments & Activities

  • Issue created by @SocialNicheGuru
  • Status changed to Closed: works as designed over 1 year ago
  • πŸ‡ΊπŸ‡ΈUnited States tr Cascadia

    This module does not define a regcode_users table, so you must be using some custom code or a patch which adds that table. I can't help you with that. If you are using a patch, provide feedback in the issue where you got the patch.

    This error is a result of a change made to Drupal core 10.1 about two weeks ago - see https://www.drupal.org/node/3264101 β†’ . The change record does not say that the same change was made to Drupal 10.0 or Drupal 9.x - as far as I know this is only for Drupal 10.1 and above. If you are seeing this error with Drupal 9.5 then I think it's because you made a change to your database settings different that the default that core Drupal 9 uses.

    Regardless, this is not a problem with the 8.x-1.x branch of this module because this module does not contain that table. This module defines only one table, regcode, which DOES have a primary key and does not have this problem.

  • πŸ‡ΊπŸ‡ΈUnited States SocialNicheGuru

    You are right. Regcode_user was addressed here: ✨ Display all users which used the current regcode. Needs review

    Apologies for not placing this issue in the right place.

Production build 0.71.5 2024