Hi guys

I have just noticed in my status reports an error stating database schema inconsistent. With a link to see details.

I've not seen this one in the report before. It says I have 41 modules with matching tables and 2 with mismatched.

I've read the report it produces but i'm not sure what to do about it. I've googled and been advised to run update.php but I already have and it makes no difference.

What should I do about this.

Heres the full report, not sure what extra info youll need so feel free to request anything.

BACKUP_MIGRATE_PROFILES
column profile_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0')
actual: array('description' => 'The primary identifier for a profile.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '0')
HIDEBACKUP_MIGRATE_DESTINATIONS
column destination_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0')
actual: array('description' => 'The primary identifier for a profile.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '0')
HIDEBACKUP_MIGRATE_SCHEDULES
column schedule_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0')
actual: array('description' => 'The primary identifier for a profile.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '0')
column source_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => 'db')
actual: array('description' => 'The backup_migrate_destination.destination_id of the source to backup from.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => 'db')
column destination_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0')
actual: array('description' => 'The backup_migrate_destination.destination_id of the destination to back up to.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '0')
column profile_id - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '0')
actual: array('description' => 'The primary identifier for a profile.', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '0')
OCUPLOAD_TEMPLATES
column template - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '!filename')
actual: array('description' => 'Template', 'type' => 'varchar', 'length' => '255', 'not null' => TRUE, 'default' => '!filename')
column template_select - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '!text')
actual: array('description' => 'Template for replace selected text', 'type' => 'varchar', 'length' => '255', 'not null' => TRUE, 'default' => '!text')

Comments

John_B’s picture

You should check whether you need to run database updates (you can do this by visiting update.php). Bear in mind that running updates on a mission-critical site is usually low risk but not risk-free so it is good practice to run updates on a test copy of the site first.

If there are no database updates pending, you should then ask yourself (or whoever maintains the site if you had it professionally built) why the Schema module, which is probably generating this message, is active on the site. You will have (or at least should have!) Googled before posting so will have seen other threads on teh topic already e.g. https://drupal.org/node/1909278

bigmonmulgrew’s picture

As I said I have tried running update.php. No errors and nothing to update.
I have googled and most of the posts I get just suggest running update.php

The post you have linked just suggests opening a thread on the relevant modules issue queue, beyonde the previously mentioned update.php

I was under the impression since this revealed issues with more than one module that it would possibly be something generic.

If you think opening separate issues for each module mentioned in the error is the only way to go then I'll do that.

John_B’s picture

Personally I would ignore it if the site is working. My second suggestion was to ask yourself why you have Schema module (which I assume is responsible for this message) enabled at all. The last paragraph was just to draw your attention to the fact there are other ideas out there, in case you find you do have a good reason for keeping this module enabled.