Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 UTC on 18 March 2024, to get $100 off your ticket.
comment
column status - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE, 'default' => 1)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'size' => 'tiny', 'not null' => TRUE, 'default' => 0)
column thread - difference on: default
declared: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => 255, 'not null' => TRUE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'varchar', 'length' => '255', 'not null' => TRUE, 'default' => '')
indexes comment_status_pid: missing in database
indexes comment_pid_status: unexpected (not an error)
indexes nid: unexpected (not an error)
indexes timestamp: unexpected (not an error)
indexes tracker_changed: unexpected (not an error)
indexes tracker_subscription: unexpected (not an error)
Comment | File | Size | Author |
---|---|---|---|
#5 | test-upgrade-schema.sh_.txt | 968 bytes | lyricnz |
#4 | 1154806-comment-schema-update-4.patch | 961 bytes | marcingy |
#1 | comment-upgrade-schema-1154806.patch | 806 bytes | lyricnz |
Comments
Comment #1
lyricnz CreditAttribution: lyricnz commentedI reran this analysis with latest Schema module (default '' issue fixed), and performed a D6>D7 upgrade with all Core modules enabled. I did not get the last three issues you reported, but here's a patch that fixes the rest.
Comment #2
lyricnz CreditAttribution: lyricnz commentedUpdate title for clarity
Comment #3
catchComment #4
marcingy CreditAttribution: marcingy commentedFixes update no and add an index drop.
Comment #5
lyricnz CreditAttribution: lyricnz commentedTested a D6-dev to D7-devl upgrade using the attached script. With the six patches (including this one) from:
#1154802: Block Schema mismatch after upgrade D6 to D7
#1154806: Comment Schema mismatch after upgrade D6 to D7
#1154808: Node Schema mismatch after upgrade D6 to D7
#1154812: Poll Schema mismatch after upgrade D6 to D7
#1154820: System Schema mismatch after upgrade D6 to D7
#1154822: User Schema mismatch after upgrade D6 to D7
and the latest Schema-D7 module, I get 92 matches, and 6 extra - no missmatch. The six extra are raised in #1157662: Tables left over after D6>D7 upgrade
RTBC here.
Comment #6
webchickAwesome. Thanks so much for all of that testing.
Committed to 7.x. Thanks!