Found this schema module complains after D5 to D6 upgrade.

project_release_supported_versions
column recommended_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)
column latest_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)
column latest_security_release - difference on: not null
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => FALSE, 'default' => 0)

We should run an update hook and correct the 'not null' and descriptions to make the schema consistent.

Comments

hass’s picture

hass’s picture

Status: Active » Needs review

Schema is clean after running this update hook.

hass’s picture

Issue tags: +6.x-1.0 blocker
hass’s picture

Issue summary: View changes

A

hass’s picture

Version: 6.x-1.x-dev » 7.x-2.x-dev
Issue summary: View changes

The bug also exist in D7

drumm’s picture

Status: Needs review » Needs work

This patch doesn't apply for D7.

hass’s picture

Status: Needs work » Needs review
StatusFileSize
new2.2 KB

Here is the fully tested D7 patch. After running this I have no longer any schema mismatches.

  • drumm committed 7c2c255 on 7.x-2.x authored by hass
    Issue #1925728 by hass: Schema inconsistent: several columns difference...
drumm’s picture

Status: Needs review » Fixed

Update runs well, and Drupal.org's database doesn't have any NULL values for these columns. Committed.

hass’s picture

Version: 7.x-2.x-dev » 6.x-1.x-dev
Status: Fixed » Needs review

D6 patch is in #1.

hass’s picture

Status: Needs review » Fixed

  • hass committed 0549a16 on 6.x-1.x
    Issue #1925728 by hass: Schema inconsistent: several columns difference...

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.