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)
CommentFileSizeAuthor
#5 test-upgrade-schema.sh_.txt968 byteslyricnz
#4 1154806-comment-schema-update-4.patch961 bytesmarcingy
#1 comment-upgrade-schema-1154806.patch806 byteslyricnz

Comments

lyricnz’s picture

lyricnz commented
Version: 7.0 » 7.x-dev
Status: Active » Needs review
StatusFileSize
new comment-upgrade-schema-1154806.patch806 bytes

I 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.

lyricnz’s picture

lyricnz commented
Title: Schema mismatch after upgrade D6 to D7 » Comment Schema mismatch after upgrade D6 to D7

Update title for clarity

catch’s picture

catch
he/him
Primary language English
commented
Priority: Normal » Major
Issue tags: +D7 upgrade path
marcingy’s picture

marcingy commented
StatusFileSize
new 1154806-comment-schema-update-4.patch961 bytes

Fixes update no and add an index drop.

lyricnz’s picture

lyricnz commented
Status: Needs review » Reviewed & tested by the community
StatusFileSize
new test-upgrade-schema.sh_.txt968 bytes

Tested 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.

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented
Status: Reviewed & tested by the community » Fixed

Awesome. Thanks so much for all of that testing.

Committed to 7.x. Thanks!

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