Contrib.social

Database schema inconsistent

Open on Drupal.org →
Created on 1 September 2018, over 6 years ago
Updated 19 September 2024, 4 months ago

Hello,

I inherited a D7 website and get an error about an inconsistent DB scheme:

Tables for which the schema and database are different:
xmlsitemap
primary key:
declared: array('id', 'type')
actual: array('id', 'type', 'language')

Now to me it doesn't look like this is anything critical, so I'm wondering if I should do something about this, and if so how best to do it. I didn't build it so I don't know when/why this warning first popped.

Thanks in advance!

💬 Support request
Status

Closed: won't fix

Version

2.0

Component

xmlsitemap.module

Created by

🇧🇪Belgium ttnt

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment 4 months ago →
    🇸🇰Slovakia poker10

    Thanks for reporting and working on this.

    xmlsitemap_schema() does not set language column in the primary key. So the question is, how you ended with that column included in the primary key? I installed the latest 7.x-2.x on Drupal 7.101 and checked with the Schema module if there are any warnings - but there are none. We will not add a new column to the PK without knowing the reason how it appeared there. Feel free to reopen this if you have a steps to reproduce how to achieve the language column in the primary key of the xmlsitemap table. Thanks!

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024