Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
node
moderate: unexpected column in database
indexes changed: unexpected (not an error)
indexes node_moderate: unexpected (not an error)
node_revision
column status - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'not null' => TRUE, 'default' => 1)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'not null' => TRUE, 'default' => 0)
indexes timestamp: unexpected (not an error)
node_type
column type - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 32, 'not null' => TRUE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => '32', 'not null' => TRUE, 'default' => '')
column module - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE)
actual: array('description' => 'The module defining this node type.', 'type' => 'varchar', 'length' => '255', 'not null' => TRUE, 'default' => '')
column has_title - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE, 'default' => 0)
Comment | File | Size | Author |
---|---|---|---|
#1 | node-upgrade-schema-1154808.patch | 880 bytes | lyricnz |
Comments
Comment #1
lyricnz CreditAttribution: lyricnz commentedFix issues reported by current schema module.
Comment #2
catchComment #3
marcingy CreditAttribution: marcingy commentedLooks good.
Comment #4
webchickCommitted to 7.x. Thanks!
Comment #6
David_Rothstein CreditAttribution: David_Rothstein commentedI found this issue while looking for something else, but note that {node}->moderate was deliberately left in the table for sites upgrading from D6, since contrib modules use it and the intention was not to destroy any data. (See discussion in #564462: Remove moderate column from node_schema().)
I'm not sure if that reasoning still applies, but if so, that part of the patch here should be reverted and/or pushed to D8.