Contrib.social

Imported database loses UID

Open on Drupal.org →
Created on 20 August 2023, about 1 year ago

Not sure how to categorize this one.

I rebuilt my mysql Drupal7 site, converting it to mysql Drupal9 in a Docker container. When I look at the contact message lists, the User ID displays cleanly. While I was working on it, Pantheon switched exclusively to mariadb.

To move my work to production, I exported the mysql Drupal9 docker database and imported it into mariadb. Then I imported it into Pantheon.

However, when I look at my contact messages my admin/structure/contact list on the new site, everything appears to have moved cleanly EXCEPT for the User ID, which are now blank. And since my site depends on user ids to serve custom data correctly, this is a major problem.

I've since looked at each of the databases in each stage, and they all show the right UID fields in the contact_message table. How can this be the case when the user id isn't showing in the site admin list?

💬 Support request
Status

Active

Version

1.3

Component

Code

Created by

tonka67

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

Comments & Activities

  • Issue created by @tonka67
  • Comment about 1 year ago →
    tonka67

    I'm still testing functionality and it looks like the system is picking up the UID even though it's not showing in the contact message list. However, not being able to cross-check ids makes it difficult to know for sure.

    There was some old work done to help facilitate contact message manipulation in views here: https://www.drupal.org/project/contact_storage/issues/3052300 ✨ Add views relationship for user that submitted the contact form Active , but nothing since.

    So, this comes down to the question: why does the UID display cleanly in my docker container but not in my live site environment, everything else being equal? I've checked the databases, I've checked the list display views on both sites. I don't see how the server environment could be affecting the display.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024