Drupal 6 -> 7 upgrade can fail due to unique indexes added in Drupal 6

ouch.

@catch - Can you please describe me more detailed what has to be done to "solve" this? You've mentioned ALTER IGNORE but I don't now when, where and how I should use this.

Thanks

OK I found out what to do so now I did upgrade without failures - of course nothing is perfect - another issues has been found like:

The specified file temporary://filenkJq1g could not be copied, because the destination directory is not properly configured

or

Notice: Undefined index: distribution_name in drupal_install_profile_distribution_name() (line 202 of

But I think that filter problem is gone ;-) Anyway - I am not sure if it was a drupal 6 issue with the missing unique key 'fmd' - as I am quite lazy, maybe I skipped or ignore something during 5 to 6 upgrade process.

T.

@Texis - could you share what you did? I'm still struggling here. So interesting that it came from migrating 5>6>7. I imagine there are quite a few people who will hit this. I had no errors in the upgrade from 5>6.

I am trying to do a similar thing as Texis and am encountering similar issues. I am at 5.10, going to 5.23 (no updates seem required there), then going to 6.22 where System Update 6043 fails when creating a new index on tables blocks and filters due to duplicate entries. I was able to get around this with the following:

/** REMOVE DUPLICATE ENTRIES FROM TABLE blocks **/
CREATE TABLE new_blocks AS SELECT * FROM blocks GROUP BY theme, module, delta;
DROP TABLE blocks;
RENAME TABLE new_blocks TO blocks;

/** REMOVE DUPLICATE ENTRIES FROM TABLE filters **/
CREATE TABLE new_filters AS SELECT * FROM filters GROUP BY format, module, delta;
DROP TABLE filters;
RENAME TABLE new_filters TO filters;

So now, I am upgrading from 6.22 to 7.4 and System Update 7007 is causing the upgrade to terminate with the following:

system module
Update #7007

Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-access content' for key 1: INSERT INTO {role_permission} (rid, permission) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1), (:db_insert_placeholder_2, :db_insert_placeholder_3), (:db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9), (:db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15), (:db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19), (:db_insert_placeholder_20, :db_insert_placeholder_21), (:db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25), (:db_insert_placeholder_26, :db_insert_placeholder_27), (:db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31), (:db_insert_placeholder_32, :db_insert_placeholder_33), (:db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37), (:db_insert_placeholder_38, :db_insert_placeholder_39), (:db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43), (:db_insert_placeholder_44, :db_insert_placeholder_45), (:db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49), (:db_insert_placeholder_50, :db_insert_placeholder_51), (:db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55), (:db_insert_placeholder_56, :db_insert_placeholder_57), (:db_insert_placeholder_58, :db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61), (:db_insert_placeholder_62, :db_insert_placeholder_63), (:db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67), (:db_insert_placeholder_68, :db_insert_placeholder_69), (:db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73), (:db_insert_placeholder_74, :db_insert_placeholder_75), (:db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79), (:db_insert_placeholder_80, :db_insert_placeholder_81), (:db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85), (:db_insert_placeholder_86, :db_insert_placeholder_87), (:db_insert_placeholder_88, :db_insert_placeholder_89), (:db_insert_placeholder_90, :db_insert_placeholder_91), (:db_insert_placeholder_92, :db_insert_placeholder_93), (:db_insert_placeholder_94, :db_insert_placeholder_95), (:db_insert_placeholder_96, :db_insert_placeholder_97), (:db_insert_placeholder_98, :db_insert_placeholder_99), (:db_insert_placeholder_100, :db_insert_placeholder_101), (:db_insert_placeholder_102, :db_insert_placeholder_103), (:db_insert_placeholder_104, :db_insert_placeholder_105), (:db_insert_placeholder_106, :db_insert_placeholder_107), (:db_insert_placeholder_108, :db_insert_placeholder_109), (:db_insert_placeholder_110, :db_insert_placeholder_111), (:db_insert_placeholder_112, :db_insert_placeholder_113), (:db_insert_placeholder_114, :db_insert_placeholder_115), (:db_insert_placeholder_116, :db_insert_placeholder_117), (:db_insert_placeholder_118, :db_insert_placeholder_119), (:db_insert_placeholder_120, :db_insert_placeholder_121), (:db_insert_placeholder_122, :db_insert_placeholder_123), (:db_insert_placeholder_124, :db_insert_placeholder_125), (:db_insert_placeholder_126, :db_insert_placeholder_127), (:db_insert_placeholder_128, :db_insert_placeholder_129), (:db_insert_placeholder_130, :db_insert_placeholder_131), (:db_insert_placeholder_132, :db_insert_placeholder_133), (:db_insert_placeholder_134, :db_insert_placeholder_135), (:db_insert_placeholder_136, :db_insert_placeholder_137), (:db_insert_placeholder_138, :db_insert_placeholder_139), (:db_insert_placeholder_140, :db_insert_placeholder_141), (:db_insert_placeholder_142, :db_insert_placeholder_143), (:db_insert_placeholder_144, :db_insert_placeholder_145), (:db_insert_placeholder_146, :db_insert_placeholder_147), (:db_insert_placeholder_148, :db_insert_placeholder_149), (:db_insert_placeholder_150, :db_insert_placeholder_151), (:db_insert_placeholder_152, :db_insert_placeholder_153), (:db_insert_placeholder_154, :db_insert_placeholder_155), (:db_insert_placeholder_156, :db_insert_placeholder_157), (:db_insert_placeholder_158, :db_insert_placeholder_159), (:db_insert_placeholder_160, :db_insert_placeholder_161), (:db_insert_placeholder_162, :db_insert_placeholder_163), (:db_insert_placeholder_164, :db_insert_placeholder_165), (:db_insert_placeholder_166, :db_insert_placeholder_167), (:db_insert_placeholder_168, :db_insert_placeholder_169), (:db_insert_placeholder_170, :db_insert_placeholder_171), (:db_insert_placeholder_172, :db_insert_placeholder_173), (:db_insert_placeholder_174, :db_insert_placeholder_175), (:db_insert_placeholder_176, :db_insert_placeholder_177), (:db_insert_placeholder_178, :db_insert_placeholder_179), (:db_insert_placeholder_180, :db_insert_placeholder_181), (:db_insert_placeholder_182, :db_insert_placeholder_183), (:db_insert_placeholder_184, :db_insert_placeholder_185); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => access content [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => access content [:db_insert_placeholder_4] => 2 [:db_insert_placeholder_5] => access news feeds [:db_insert_placeholder_6] => 2 [:db_insert_placeholder_7] => administer news feeds [:db_insert_placeholder_8] => 2 [:db_insert_placeholder_9] => create events [:db_insert_placeholder_10] => 2 [:db_insert_placeholder_11] => edit own events [:db_insert_placeholder_12] => 2 [:db_insert_placeholder_13] => administer blocks [:db_insert_placeholder_14] => 2 [:db_insert_placeholder_15] => use PHP for block visibility [:db_insert_placeholder_16] => 2 [:db_insert_placeholder_17] => create blog entries [:db_insert_placeholder_18] => 2 [:db_insert_placeholder_19] => edit own blog entries [:db_insert_placeholder_20] => 2 [:db_insert_placeholder_21] => administer content with blog api [:db_insert_placeholder_22] => 2 [:db_insert_placeholder_23] => create book pages [:db_insert_placeholder_24] => 2 [:db_insert_placeholder_25] => create new books [:db_insert_placeholder_26] => 2 [:db_insert_placeholder_27] => edit book pages [:db_insert_placeholder_28] => 2 [:db_insert_placeholder_29] => edit own book pages [:db_insert_placeholder_30] => 2 [:db_insert_placeholder_31] => outline posts in books [:db_insert_placeholder_32] => 2 [:db_insert_placeholder_33] => see printer-friendly version [:db_insert_placeholder_34] => 2 [:db_insert_placeholder_35] => access comments [:db_insert_placeholder_36] => 2 [:db_insert_placeholder_37] => administer comments [:db_insert_placeholder_38] => 2 [:db_insert_placeholder_39] => post comments [:db_insert_placeholder_40] => 2 [:db_insert_placeholder_41] => post comments without approval [:db_insert_placeholder_42] => 2 [:db_insert_placeholder_43] => access site-wide contact form [:db_insert_placeholder_44] => 2 [:db_insert_placeholder_45] => access fckeditor [:db_insert_placeholder_46] => 2 [:db_insert_placeholder_47] => administer fckeditor [:db_insert_placeholder_48] => 2 [:db_insert_placeholder_49] => allow fckeditor file uploads [:db_insert_placeholder_50] => 2 [:db_insert_placeholder_51] => administer filters [:db_insert_placeholder_52] => 2 [:db_insert_placeholder_53] => administer forums [:db_insert_placeholder_54] => 2 [:db_insert_placeholder_55] => create forum topics [:db_insert_placeholder_56] => 2 [:db_insert_placeholder_57] => edit own forum content [:db_insert_placeholder_58] => 2 [:db_insert_placeholder_59] => access freelinking list [:db_insert_placeholder_60] => 2 [:db_insert_placeholder_61] => administer freelinking [:db_insert_placeholder_62] => 2 [:db_insert_placeholder_63] => create images [:db_insert_placeholder_64] => 2 [:db_insert_placeholder_65] => edit images [:db_insert_placeholder_66] => 2 [:db_insert_placeholder_67] => edit own images [:db_insert_placeholder_68] => 2 [:db_insert_placeholder_69] => view original images [:db_insert_placeholder_70] => 2 [:db_insert_placeholder_71] => administer images [:db_insert_placeholder_72] => 2 [:db_insert_placeholder_73] => import images [:db_insert_placeholder_74] => 2 [:db_insert_placeholder_75] => administer menu [:db_insert_placeholder_76] => 2 [:db_insert_placeholder_77] => access content [:db_insert_placeholder_78] => 2 [:db_insert_placeholder_79] => administer content types [:db_insert_placeholder_80] => 2 [:db_insert_placeholder_81] => administer nodes [:db_insert_placeholder_82] => 2 [:db_insert_placeholder_83] => create page content [:db_insert_placeholder_84] => 2 [:db_insert_placeholder_85] => create story content [:db_insert_placeholder_86] => 2 [:db_insert_placeholder_87] => edit own page content [:db_insert_placeholder_88] => 2 [:db_insert_placeholder_89] => edit own story content [:db_insert_placeholder_90] => 2 [:db_insert_placeholder_91] => edit any page content [:db_insert_placeholder_92] => 2 [:db_insert_placeholder_93] => edit any story content [:db_insert_placeholder_94] => 2 [:db_insert_placeholder_95] => revert revisions [:db_insert_placeholder_96] => 2 [:db_insert_placeholder_97] => view revisions [:db_insert_placeholder_98] => 2 [:db_insert_placeholder_99] => administer advanced pane settings [:db_insert_placeholder_100] => 2 [:db_insert_placeholder_101] => administer pane access [:db_insert_placeholder_102] => 2 [:db_insert_placeholder_103] => administer pane visibility [:db_insert_placeholder_104] => 2 [:db_insert_placeholder_105] => use panels caching features [:db_insert_placeholder_106] => 2 [:db_insert_placeholder_107] => view all panes [:db_insert_placeholder_108] => 2 [:db_insert_placeholder_109] => view pane admin links [:db_insert_placeholder_110] => 2 [:db_insert_placeholder_111] => use panels exporter [:db_insert_placeholder_112] => 2 [:db_insert_placeholder_113] => administer mini panels [:db_insert_placeholder_114] => 2 [:db_insert_placeholder_115] => create mini panels [:db_insert_placeholder_116] => 2 [:db_insert_placeholder_117] => administer panel-nodes [:db_insert_placeholder_118] => 2 [:db_insert_placeholder_119] => create panel-nodes [:db_insert_placeholder_120] => 2 [:db_insert_placeholder_121] => edit own panel-nodes [:db_insert_placeholder_122] => 2 [:db_insert_placeholder_123] => access all panel-pages [:db_insert_placeholder_124] => 2 [:db_insert_placeholder_125] => create panel-pages [:db_insert_placeholder_126] => 2 [:db_insert_placeholder_127] => administer panel views [:db_insert_placeholder_128] => 2 [:db_insert_placeholder_129] => administer url aliases [:db_insert_placeholder_130] => 2 [:db_insert_placeholder_131] => create url aliases [:db_insert_placeholder_132] => 2 [:db_insert_placeholder_133] => administer pathauto [:db_insert_placeholder_134] => 2 [:db_insert_placeholder_135] => notify of path changes [:db_insert_placeholder_136] => 2 [:db_insert_placeholder_137] => cancel own vote [:db_insert_placeholder_138] => 2 [:db_insert_placeholder_139] => create poll content [:db_insert_placeholder_140] => 2 [:db_insert_placeholder_141] => inspect all votes [:db_insert_placeholder_142] => 2 [:db_insert_placeholder_143] => vote on polls [:db_insert_placeholder_144] => 2 [:db_insert_placeholder_145] => administer search [:db_insert_placeholder_146] => 2 [:db_insert_placeholder_147] => search content [:db_insert_placeholder_148] => 2 [:db_insert_placeholder_149] => use advanced search [:db_insert_placeholder_150] => 2 [:db_insert_placeholder_151] => administer all signups [:db_insert_placeholder_152] => 2 [:db_insert_placeholder_153] => administer signups for own content [:db_insert_placeholder_154] => 2 [:db_insert_placeholder_155] => sign up for content [:db_insert_placeholder_156] => 2 [:db_insert_placeholder_157] => view all signups [:db_insert_placeholder_158] => 2 [:db_insert_placeholder_159] => access statistics [:db_insert_placeholder_160] => 2 [:db_insert_placeholder_161] => view post access counter [:db_insert_placeholder_162] => 2 [:db_insert_placeholder_163] => access administration pages [:db_insert_placeholder_164] => 2 [:db_insert_placeholder_165] => administer site configuration [:db_insert_placeholder_166] => 2 [:db_insert_placeholder_167] => select different theme [:db_insert_placeholder_168] => 2 [:db_insert_placeholder_169] => administer taxonomy [:db_insert_placeholder_170] => 2 [:db_insert_placeholder_171] => upload files [:db_insert_placeholder_172] => 2 [:db_insert_placeholder_173] => view uploaded files [:db_insert_placeholder_174] => 2 [:db_insert_placeholder_175] => access user profiles [:db_insert_placeholder_176] => 2 [:db_insert_placeholder_177] => administer permissions [:db_insert_placeholder_178] => 2 [:db_insert_placeholder_179] => administer users [:db_insert_placeholder_180] => 2 [:db_insert_placeholder_181] => change own username [:db_insert_placeholder_182] => 2 [:db_insert_placeholder_183] => access all views [:db_insert_placeholder_184] => 2 [:db_insert_placeholder_185] => administer views ) in system_update_7007() (line 1892 of /srv/www/htdocs/drupal-7.4/modules/system/system.install).

Hm, it's hard to say because I run that site quite long. I just checked another site which I recently moved from Drupal 5 to Drupal 6.22 and it contains correct unique key in the filters table.

So it probably happened during minor updates within Drupal 6 releases or (what I still think) it was due to my fault as I sometimes do updates without offline mode or simply "do not follow READMEs" :)

Texis

I'll try to update a live site from 5 to 7 in the next weeks (of course, I'll work on a copy first). I'll updated with details in case I find anything.

OK .. I have been having trouble updating a site from D5 to D7. The update from D5 to D6 went relatively smooth. I can't recall if there were errors or not not during the upgrade, but for sure no FATAL errors.
First I updated all my D5 modules to the latest published versions including D5 core to D5.23.

Next, I completed the updated from D5.23 to D6.22. Like I said the upgrade completed with no FATAL errors. I should have paid close attentions to other error messages - maybe I can retest that workflow again to capture any other errors like those mentioned above by catch http://drupal.org/node/1211796#comment-4705562.

Now, going to my D7.4 update, that is when I got a fatal error that I have reported here #1220602: Call to undefined function _update_7000_field_read_fields() during Forum update 7003 Call to undefined function _update_7000_field_read_fields() during forum update

But in addition that error on the Forum module, I have several other errors that are similar to those repeorted here above. Here is a list of the errors I got.

filter module
Update #7003

    Failed: DatabaseSchemaObjectDoesNotExistException: Cannot rename <em class="placeholder">filters</em> to <em class="placeholder">d6_upgrade_filter</em>: table <em class="placeholder">filters</em> doesn't exist. in DatabaseSchema_mysql->renameTable() (line 299 of C:\Users\Mahmoud\Sites\peoriaparent5to6\includes\database\mysql\schema.inc).

system module
Update #7007

    Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-access content' for key 'PRIMARY': INSERT INTO {role_permission} (rid, permission) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1), (:db_insert_placeholder_2, :db_insert_placeholder_3), (:db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9), (:db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15), (:db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19), (:db_insert_placeholder_20, :db_insert_placeholder_21), (:db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25), (:db_insert_placeholder_26, :db_insert_placeholder_27), (:db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31), (:db_insert_placeholder_32, :db_insert_placeholder_33), (:db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37), (:db_insert_placeholder_38, :db_insert_placeholder_39), (:db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43), (:db_insert_placeholder_44, :db_insert_placeholder_45), (:db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49), (:db_insert_placeholder_50, :db_insert_placeholder_51), (:db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55), (:db_insert_placeholder_56, :db_insert_placeholder_57), (:db_insert_placeholder_58, :db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61), (:db_insert_placeholder_62, :db_insert_placeholder_63), (:db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67), (:db_insert_placeholder_68, :db_insert_placeholder_69), (:db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73), (:db_insert_placeholder_74, :db_insert_placeholder_75), (:db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79), (:db_insert_placeholder_80, :db_insert_placeholder_81), (:db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85), (:db_insert_placeholder_86, :db_insert_placeholder_87), (:db_insert_placeholder_88, :db_insert_placeholder_89), (:db_insert_placeholder_90, :db_insert_placeholder_91), (:db_insert_placeholder_92, :db_insert_placeholder_93), (:db_insert_placeholder_94, :db_insert_placeholder_95), (:db_insert_placeholder_96, :db_insert_placeholder_97), (:db_insert_placeholder_98, :db_insert_placeholder_99), (:db_insert_placeholder_100, :db_insert_placeholder_101), (:db_insert_placeholder_102, :db_insert_placeholder_103), (:db_insert_placeholder_104, :db_insert_placeholder_105), (:db_insert_placeholder_106, :db_insert_placeholder_107), (:db_insert_placeholder_108, :db_insert_placeholder_109), (:db_insert_placeholder_110, :db_insert_placeholder_111), (:db_insert_placeholder_112, :db_insert_placeholder_113), (:db_insert_placeholder_114, :db_insert_placeholder_115), (:db_insert_placeholder_116, :db_insert_placeholder_117), (:db_insert_placeholder_118, :db_insert_placeholder_119), (:db_insert_placeholder_120, :db_insert_placeholder_121), (:db_insert_placeholder_122, :db_insert_placeholder_123), (:db_insert_placeholder_124, :db_insert_placeholder_125), (:db_insert_placeholder_126, :db_insert_placeholder_127), (:db_insert_placeholder_128, :db_insert_placeholder_129), (:db_insert_placeholder_130, :db_insert_placeholder_131), (:db_insert_placeholder_132, :db_insert_placeholder_133), (:db_insert_placeholder_134, :db_insert_placeholder_135), (:db_insert_placeholder_136, :db_insert_placeholder_137), (:db_insert_placeholder_138, :db_insert_placeholder_139), (:db_insert_placeholder_140, :db_insert_placeholder_141), (:db_insert_placeholder_142, :db_insert_placeholder_143), (:db_insert_placeholder_144, :db_insert_placeholder_145), (:db_insert_placeholder_146, :db_insert_placeholder_147), (:db_insert_placeholder_148, :db_insert_placeholder_149), (:db_insert_placeholder_150, :db_insert_placeholder_151), (:db_insert_placeholder_152, :db_insert_placeholder_153), (:db_insert_placeholder_154, :db_insert_placeholder_155), (:db_insert_placeholder_156, :db_insert_placeholder_157), (:db_insert_placeholder_158, :db_insert_placeholder_159), (:db_insert_placeholder_160, :db_insert_placeholder_161), (:db_insert_placeholder_162, :db_insert_placeholder_163), (:db_insert_placeholder_164, :db_insert_placeholder_165), (:db_insert_placeholder_166, :db_insert_placeholder_167), (:db_insert_placeholder_168, :db_insert_placeholder_169), (:db_insert_placeholder_170, :db_insert_placeholder_171), (:db_insert_placeholder_172, :db_insert_placeholder_173), (:db_insert_placeholder_174, :db_insert_placeholder_175), (:db_insert_placeholder_176, :db_insert_placeholder_177), (:db_insert_placeholder_178, :db_insert_placeholder_179), (:db_insert_placeholder_180, :db_insert_placeholder_181), (:db_insert_placeholder_182, :db_insert_placeholder_183), (:db_insert_placeholder_184, :db_insert_placeholder_185), (:db_insert_placeholder_186, :db_insert_placeholder_187), (:db_insert_placeholder_188, :db_insert_placeholder_189), (:db_insert_placeholder_190, :db_insert_placeholder_191), (:db_insert_placeholder_192, :db_insert_placeholder_193), (:db_insert_placeholder_194, :db_insert_placeholder_195), (:db_insert_placeholder_196, :db_insert_placeholder_197), (:db_insert_placeholder_198, :db_insert_placeholder_199), (:db_insert_placeholder_200, :db_insert_placeholder_201), (:db_insert_placeholder_202, :db_insert_placeholder_203); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => access content [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => access content [:db_insert_placeholder_4] => 2 [:db_insert_placeholder_5] => access news feeds [:db_insert_placeholder_6] => 2 [:db_insert_placeholder_7] => create blog entries [:db_insert_placeholder_8] => 2 [:db_insert_placeholder_9] => edit own blog entries [:db_insert_placeholder_10] => 2 [:db_insert_placeholder_11] => access comments [:db_insert_placeholder_12] => 2 [:db_insert_placeholder_13] => post comments [:db_insert_placeholder_14] => 2 [:db_insert_placeholder_15] => post comments without approval [:db_insert_placeholder_16] => 2 [:db_insert_placeholder_17] => access site-wide contact form [:db_insert_placeholder_18] => 2 [:db_insert_placeholder_19] => create forum topics [:db_insert_placeholder_20] => 2 [:db_insert_placeholder_21] => edit own forum content [:db_insert_placeholder_22] => 2 [:db_insert_placeholder_23] => create images [:db_insert_placeholder_24] => 2 [:db_insert_placeholder_25] => edit own images [:db_insert_placeholder_26] => 2 [:db_insert_placeholder_27] => delete own images [:db_insert_placeholder_28] => 2 [:db_insert_placeholder_29] => rate content [:db_insert_placeholder_30] => 2 [:db_insert_placeholder_31] => access content [:db_insert_placeholder_32] => 2 [:db_insert_placeholder_33] => create bulletin_board_entry content [:db_insert_placeholder_34] => 2 [:db_insert_placeholder_35] => create pp_group_page content [:db_insert_placeholder_36] => 2 [:db_insert_placeholder_37] => create ppcalevent content [:db_insert_placeholder_38] => 2 [:db_insert_placeholder_39] => edit own bulletin_board_entry content [:db_insert_placeholder_40] => 2 [:db_insert_placeholder_41] => edit own pp_group_page content [:db_insert_placeholder_42] => 2 [:db_insert_placeholder_43] => edit own ppcalevent content [:db_insert_placeholder_44] => 2 [:db_insert_placeholder_45] => create poll content [:db_insert_placeholder_46] => 2 [:db_insert_placeholder_47] => vote on polls [:db_insert_placeholder_48] => 2 [:db_insert_placeholder_49] => search content [:db_insert_placeholder_50] => 2 [:db_insert_placeholder_51] => subscribe to newsletters [:db_insert_placeholder_52] => 2 [:db_insert_placeholder_53] => access news feeds [:db_insert_placeholder_54] => 2 [:db_insert_placeholder_55] => create blog entries [:db_insert_placeholder_56] => 2 [:db_insert_placeholder_57] => edit own blog entries [:db_insert_placeholder_58] => 2 [:db_insert_placeholder_59] => access comments [:db_insert_placeholder_60] => 2 [:db_insert_placeholder_61] => post comments [:db_insert_placeholder_62] => 2 [:db_insert_placeholder_63] => post comments without approval [:db_insert_placeholder_64] => 2 [:db_insert_placeholder_65] => access site-wide contact form [:db_insert_placeholder_66] => 2 [:db_insert_placeholder_67] => create forum topics [:db_insert_placeholder_68] => 2 [:db_insert_placeholder_69] => edit own forum content [:db_insert_placeholder_70] => 2 [:db_insert_placeholder_71] => create images [:db_insert_placeholder_72] => 2 [:db_insert_placeholder_73] => edit own images [:db_insert_placeholder_74] => 2 [:db_insert_placeholder_75] => delete own images [:db_insert_placeholder_76] => 2 [:db_insert_placeholder_77] => rate content [:db_insert_placeholder_78] => 2 [:db_insert_placeholder_79] => access content [:db_insert_placeholder_80] => 2 [:db_insert_placeholder_81] => create bulletin_board_entry content [:db_insert_placeholder_82] => 2 [:db_insert_placeholder_83] => create pp_group_page content [:db_insert_placeholder_84] => 2 [:db_insert_placeholder_85] => create ppcalevent content [:db_insert_placeholder_86] => 2 [:db_insert_placeholder_87] => edit own bulletin_board_entry content [:db_insert_placeholder_88] => 2 [:db_insert_placeholder_89] => edit own pp_group_page content [:db_insert_placeholder_90] => 2 [:db_insert_placeholder_91] => edit own ppcalevent content [:db_insert_placeholder_92] => 2 [:db_insert_placeholder_93] => create poll content [:db_insert_placeholder_94] => 2 [:db_insert_placeholder_95] => vote on polls [:db_insert_placeholder_96] => 2 [:db_insert_placeholder_97] => search content [:db_insert_placeholder_98] => 2 [:db_insert_placeholder_99] => subscribe to newsletters [:db_insert_placeholder_100] => 3 [:db_insert_placeholder_101] => access news feeds [:db_insert_placeholder_102] => 3 [:db_insert_placeholder_103] => create blog entries [:db_insert_placeholder_104] => 3 [:db_insert_placeholder_105] => edit own blog entries [:db_insert_placeholder_106] => 3 [:db_insert_placeholder_107] => access comments [:db_insert_placeholder_108] => 3 [:db_insert_placeholder_109] => administer comments [:db_insert_placeholder_110] => 3 [:db_insert_placeholder_111] => post comments [:db_insert_placeholder_112] => 3 [:db_insert_placeholder_113] => post comments without approval [:db_insert_placeholder_114] => 3 [:db_insert_placeholder_115] => access site-wide contact form [:db_insert_placeholder_116] => 3 [:db_insert_placeholder_117] => administer forums [:db_insert_placeholder_118] => 3 [:db_insert_placeholder_119] => create forum topics [:db_insert_placeholder_120] => 3 [:db_insert_placeholder_121] => edit own forum content [:db_insert_placeholder_122] => 3 [:db_insert_placeholder_123] => create images [:db_insert_placeholder_124] => 3 [:db_insert_placeholder_125] => edit own images [:db_insert_placeholder_126] => 3 [:db_insert_placeholder_127] => delete own images [:db_insert_placeholder_128] => 3 [:db_insert_placeholder_129] => rate content [:db_insert_placeholder_130] => 3 [:db_insert_placeholder_131] => access content [:db_insert_placeholder_132] => 3 [:db_insert_placeholder_133] => create bulletin_board_entry content [:db_insert_placeholder_134] => 3 [:db_insert_placeholder_135] => create busidirectory content [:db_insert_placeholder_136] => 3 [:db_insert_placeholder_137] => create page content [:db_insert_placeholder_138] => 3 [:db_insert_placeholder_139] => create pp_group_page content [:db_insert_placeholder_140] => 3 [:db_insert_placeholder_141] => create ppcalevent content [:db_insert_placeholder_142] => 3 [:db_insert_placeholder_143] => create story content [:db_insert_placeholder_144] => 3 [:db_insert_placeholder_145] => edit any bulletin_board_entry content [:db_insert_placeholder_146] => 3 [:db_insert_placeholder_147] => edit any busidirectory content [:db_insert_placeholder_148] => 3 [:db_insert_placeholder_149] => edit own bulletin_board_entry content [:db_insert_placeholder_150] => 3 [:db_insert_placeholder_151] => edit own busidirectory content [:db_insert_placeholder_152] => 3 [:db_insert_placeholder_153] => edit own page content [:db_insert_placeholder_154] => 3 [:db_insert_placeholder_155] => edit own pp_group_page content [:db_insert_placeholder_156] => 3 [:db_insert_placeholder_157] => edit own ppcalevent content [:db_insert_placeholder_158] => 3 [:db_insert_placeholder_159] => edit own story content [:db_insert_placeholder_160] => 3 [:db_insert_placeholder_161] => edit any page content [:db_insert_placeholder_162] => 3 [:db_insert_placeholder_163] => edit any pp_group_page content [:db_insert_placeholder_164] => 3 [:db_insert_placeholder_165] => edit any ppcalevent content [:db_insert_placeholder_166] => 3 [:db_insert_placeholder_167] => edit any story content [:db_insert_placeholder_168] => 3 [:db_insert_placeholder_169] => administer organic groups [:db_insert_placeholder_170] => 3 [:db_insert_placeholder_171] => cancel own vote [:db_insert_placeholder_172] => 3 [:db_insert_placeholder_173] => create poll content [:db_insert_placeholder_174] => 3 [:db_insert_placeholder_175] => inspect all votes [:db_insert_placeholder_176] => 3 [:db_insert_placeholder_177] => vote on polls [:db_insert_placeholder_178] => 3 [:db_insert_placeholder_179] => administer search [:db_insert_placeholder_180] => 3 [:db_insert_placeholder_181] => search content [:db_insert_placeholder_182] => 3 [:db_insert_placeholder_183] => use advanced search [:db_insert_placeholder_184] => 3 [:db_insert_placeholder_185] => administer newsletters [:db_insert_placeholder_186] => 3 [:db_insert_placeholder_187] => create simplenews content [:db_insert_placeholder_188] => 3 [:db_insert_placeholder_189] => edit any simplenews content [:db_insert_placeholder_190] => 3 [:db_insert_placeholder_191] => edit own simplenews content [:db_insert_placeholder_192] => 3 [:db_insert_placeholder_193] => send newsletter [:db_insert_placeholder_194] => 3 [:db_insert_placeholder_195] => subscribe to newsletters [:db_insert_placeholder_196] => 3 [:db_insert_placeholder_197] => view links in block [:db_insert_placeholder_198] => 3 [:db_insert_placeholder_199] => access statistics [:db_insert_placeholder_200] => 3 [:db_insert_placeholder_201] => access administration pages [:db_insert_placeholder_202] => 3 [:db_insert_placeholder_203] => access user profiles ) in system_update_7007() (line 1892 of C:\Users\Mahmoud\Sites\peoriaparent5to6\modules\system\system.install).

contact module
Update #7002

    Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'module' in 'where clause': SELECT 1 AS expression FROM {role_permission} role_permission WHERE ( (rid = :db_condition_placeholder_0) AND (permission = :db_condition_placeholder_1) AND (module = :db_condition_placeholder_2) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => access user contact forms [:db_condition_placeholder_2] => contact ) in contact_update_7002() (line 127 of C:\Users\Mahmoud\Sites\peoriaparent5to6\modules\contact\contact.install).

og module
Update #7000

    Failed: DrupalUpdateException: You must enable Organic groups module to perform an upgrade from Drupal 6. in og_update_7000() (line 205 of C:\Users\Mahmoud\Sites\peoriaparent5to6\sites\all\modules\og-7.x-1.0\og\og.install).

I guess this confirms that the same scenario generates similar fatal errors. Any thoughts on this ?

I would be willing to restart the whole update process from D5 to D6 if needed to capture specific issues related to the D5 to D6 update that causes the fatal error from D6 to D7 update. It is clear, however, that the database is getting corrupt.

I am in the process of repeating the update from D5 to D6.
Here is the first of the errors

UPDATE: The errors that I am posting are not showing on Drupal site ???

I dumped all the errors in this txt file.

http://www.peoriaparent.com/files/error_log.txt

Drupal asks to run update again with the following messsage

date module cannot be updated until after Views has been updated. Please return to update.php and run the remaining updates.
Some updates are still pending. Please return to update.php and run the remaining updates.
Updates for CCK-related modules are not run until the modules are enabled on the administer modules page. When you enable them, you'll need to return to update.php and run the remaining updates.

Nothing serious there.

And finally, here is a log of what was updated. I apologize for the long information dump.

The following queries were executed
system module
Update #6000

    ALTER TABLE {boxes} CHANGE COLUMN bid bid int NOT NULL
    REPLACE INTO {sequences} VALUES ('{boxes}_bid', 25)

Update #6001

    ALTER TABLE {term_node} ADD `vid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {term_node} DROP PRIMARY KEY
    ALTER TABLE {term_node} ADD PRIMARY KEY (vid, tid, nid)
    ALTER TABLE {term_node} ADD INDEX vid (vid)

Update #6002

    ALTER TABLE {variable} DROP PRIMARY KEY
    ALTER TABLE {variable} CHANGE `name` `name` VARCHAR(128) NOT NULL DEFAULT ''
    ALTER TABLE {variable} ADD PRIMARY KEY (name)

Update #6003

    ALTER TABLE {comments} ADD INDEX status (status)

Update #6004

    No queries

Update #6005

    ALTER TABLE {url_alias} ADD language varchar(12) NOT NULL default ''
    ALTER TABLE {url_alias} DROP INDEX dst
    ALTER TABLE {url_alias} ADD UNIQUE dst_language (dst, language)

Update #6006

    ALTER TABLE {node_counter} DROP INDEX daycount
    ALTER TABLE {node_counter} DROP INDEX totalcount
    ALTER TABLE {node_counter} DROP INDEX timestamp

Update #6007

    UPDATE {watchdog} SET severity = 5 WHERE severity = 0
    UPDATE {watchdog} SET severity = 4 WHERE severity = 1
    UPDATE {watchdog} SET severity = 3 WHERE severity = 2

Update #6008

    UPDATE {system} SET owner = description
    ALTER TABLE {system} DROP description

Update #6009

    UPDATE {system} SET status = 1 WHERE name = 'php' AND type = 'module'
    UPDATE {filters} SET delta = 0, module = 'php' WHERE module = 'filter' AND delta = 1
    UPDATE {filters} SET delta = 1 WHERE module = 'filter' AND delta = 2
    UPDATE {filters} SET delta = 2 WHERE module = 'filter' AND delta = 3

Update #6010

    ALTER TABLE {watchdog} ADD `variables` LONGTEXT DEFAULT NULL
    UPDATE {watchdog} SET variables = '%s' (N;)
    ALTER TABLE {watchdog} CHANGE `variables` `variables` LONGTEXT NOT NULL

Update #6011

    ALTER TABLE {node} ADD language varchar(12) NOT NULL default ''

Update #6012

    No queries

Update #6013

    Cache rebuilt.

Update #6014

    variable_set('install_task')

Update #6015

    CREATE TABLE {cache_form} ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ 

Update #6016

    ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid)
    ALTER TABLE {blocks} ADD bid int NOT NULL AUTO_INCREMENT PRIMARY KEY
    ALTER TABLE {filters} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY
    ALTER TABLE {flood} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY
    ALTER TABLE {permission} ADD pid int NOT NULL AUTO_INCREMENT PRIMARY KEY
    ALTER TABLE {term_relation} ADD trid int NOT NULL AUTO_INCREMENT PRIMARY KEY
    ALTER TABLE {term_synonym} ADD tsid int NOT NULL AUTO_INCREMENT PRIMARY KEY

Update #6017

    variable_set(user_mail_register_admin_created_subject)
    variable_del(user_mail_admin_subject)
    variable_set(user_mail_register_admin_created_body)
    variable_del(user_mail_admin_body)
    variable_set(user_mail_register_pending_approval_subject)
    variable_del(user_mail_approval_subject)
    variable_set(user_mail_register_pending_approval_body)
    variable_del(user_mail_approval_body)
    variable_set(user_mail_register_no_approval_required_subject)
    variable_del(user_mail_welcome_subject)
    variable_set(user_mail_register_no_approval_required_body)
    variable_del(user_mail_welcome_body)
    variable_set(user_mail_password_reset_subject)
    variable_del(user_mail_pass_subject)
    variable_set(user_mail_password_reset_body)
    variable_del(user_mail_pass_body)

Update #6018

    HTML corrector filter added to the 'Filtered HTML' input format.
    HTML corrector filter added to the 'Full HTML' input format.

Update #6019

    ALTER TABLE {aggregator_feed} DROP KEY link
    ALTER TABLE {aggregator_feed} ADD UNIQUE KEY url (url)
    ALTER TABLE {boxes} CHANGE `format` `format` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {comments} CHANGE `format` `format` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {comments} DROP INDEX lid
    ALTER TABLE {comments} ADD INDEX nid (nid)
    ALTER TABLE {cache} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {cache_filter} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {cache_page} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {cache_form} CHANGE `serialized` `serialized` SMALLINT NOT NULL DEFAULT 0
    UPDATE {users} SET uid = 457 WHERE uid = 0
    ALTER TABLE {users} DROP PRIMARY KEY
    ALTER TABLE {users} CHANGE `uid` `uid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (uid)
    UPDATE {users} SET uid = 0 WHERE uid = 457
    ALTER TABLE {boxes} DROP PRIMARY KEY
    ALTER TABLE {boxes} CHANGE `bid` `bid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (bid)
    ALTER TABLE {files} DROP PRIMARY KEY
    ALTER TABLE {files} CHANGE `fid` `fid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (fid)
    ALTER TABLE {node} DROP PRIMARY KEY
    ALTER TABLE {node} CHANGE `nid` `nid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (nid)
    ALTER TABLE {node_revisions} DROP PRIMARY KEY
    ALTER TABLE {node_revisions} CHANGE `vid` `vid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (vid)

Update #6020

    CREATE TABLE {menu_router} ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    CREATE TABLE {menu_links} ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128)) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #6021

    ALTER TABLE {menu} ADD `converted` TINYINT unsigned NOT NULL DEFAULT 0
    CREATE TABLE {menu_custom} ( `menu_name` VARCHAR(32) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    UPDATE {menu_custom} SET menu_name = 'primary-links', description = 'Primary links are often used at the theme layer to show the major sections of a site. A typical representation for primary links would be tabs along the top.' WHERE menu_name = 'menu-primary-links'
    UPDATE {menu_links} SET menu_name = 'primary-links' WHERE menu_name = 'menu-primary-links'
    UPDATE {blocks} SET delta = 'primary-links' WHERE module = 'menu' AND delta = '2'
    UPDATE {blocks_roles} SET delta = 'primary-links' WHERE module = 'menu' AND delta = '2'
    Relocated 1000 existing items to the new menu system.
    DROP TABLE {menu}

Update #6022

    ALTER TABLE {files} DROP INDEX nid
    ALTER TABLE {files} CHANGE `nid` `uid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {files} ADD `status` INT NOT NULL DEFAULT 0
    ALTER TABLE {files} ADD `timestamp` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {files} ADD INDEX uid (uid)
    ALTER TABLE {files} ADD INDEX status (status)
    ALTER TABLE {files} ADD INDEX timestamp (timestamp)
    ALTER TABLE {file_revisions} DROP PRIMARY KEY
    ALTER TABLE {file_revisions} DROP INDEX vid
    ALTER TABLE {file_revisions} RENAME TO {upload}
    ALTER TABLE {upload} ADD `nid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {upload} ADD INDEX nid (nid)
    ALTER TABLE {upload} ADD PRIMARY KEY (vid, fid)
    ALTER TABLE {upload} ADD INDEX fid (fid)
    UPDATE {files} SET status = 1

Update #6023

    ALTER TABLE {node_revisions} DROP INDEX nid
    ALTER TABLE {node_revisions} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {node_revisions} ADD INDEX nid (nid)

Update #6024

    ALTER TABLE {node} ADD `tnid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {node} ADD `translate` INT NOT NULL DEFAULT 0
    ALTER TABLE {node} ADD INDEX tnid (tnid)
    ALTER TABLE {node} ADD INDEX translate (translate)

Update #6025

    ALTER TABLE {node} DROP INDEX node_title_type
    ALTER TABLE {node} CHANGE `title` `title` VARCHAR(255) NOT NULL DEFAULT ''
    ALTER TABLE {node} ADD INDEX node_title_type (title, type(4))
    ALTER TABLE {node_revisions} CHANGE `title` `title` VARCHAR(255) NOT NULL DEFAULT ''

Update #6026

    No queries

Update #6027

    ALTER TABLE {blocks} ADD `cache` TINYINT NOT NULL DEFAULT 1

Update #6028

    No queries

Update #6029

    'dblog' module enabled.

Update #6030

    CREATE TABLE {actions} ( `aid` VARCHAR(255) NOT NULL DEFAULT '0', `type` VARCHAR(32) NOT NULL DEFAULT '', `callback` VARCHAR(255) NOT NULL DEFAULT '', `parameters` LONGTEXT NOT NULL, `description` VARCHAR(255) NOT NULL DEFAULT '0', PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    CREATE TABLE {actions_aid} ( `aid` INT unsigned NOT NULL auto_increment, PRIMARY KEY (aid) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #6031

    No queries

Update #6032

    ALTER TABLE {profile_fields} DROP KEY name
    ALTER TABLE {profile_fields} CHANGE `name` `name` VARCHAR(128) NOT NULL DEFAULT ''
    ALTER TABLE {profile_fields} ADD UNIQUE KEY name (name)

Update #6033

    ALTER TABLE {node_comment_statistics} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0

Update #6034

    No queries

Update #6035

    ALTER TABLE {system} DROP INDEX weight
    ALTER TABLE {system} ADD INDEX modules (type(12), status, weight, filename)
    ALTER TABLE {system} ADD INDEX bootstrap (type(12), status, bootstrap, weight, filename)

Update #6036

    ALTER TABLE {search_dataset} ADD `reindex` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {search_index} DROP INDEX from_sid_type
    ALTER TABLE {search_index} DROP fromsid
    ALTER TABLE {search_index} DROP fromtype
    ALTER TABLE {search_dataset} DROP INDEX sid_type
    CREATE TABLE {search_node_links} ( `sid` INT unsigned NOT NULL DEFAULT 0, `type` VARCHAR(16) NOT NULL DEFAULT '', `nid` INT unsigned NOT NULL DEFAULT 0, `caption` LONGTEXT DEFAULT NULL, PRIMARY KEY (sid, type, nid), INDEX nid (nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY word_sid_type (word, sid, type)
    ALTER IGNORE TABLE {search_dataset} ADD UNIQUE KEY sid_type (sid, type)
    UPDATE {search_dataset} SET reindex = 1

Update #6037

    ALTER TABLE {blocks} CHANGE `region` `region` VARCHAR(64) NOT NULL DEFAULT ''
    UPDATE {blocks} SET region = '' WHERE status = 0

Update #6038

    UPDATE {profile_fields} SET category = 'Account settings' WHERE LOWER(category) = 'account'

Update #6039

    UPDATE {permission} SET perm = 'access news feeds, edit own blog, access comments, post comments, post comments without approval, access site-wide contact form, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create pp_group_page content, create ppcalevent content, edit own bulletin_board_entry content, edit own pp_group_page content, edit own ppcalevent content, create poll content, vote on polls, search content, subscribe to newsletters' WHERE rid = 2
    UPDATE {permission} SET perm = 'access news feeds, edit own blog, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer forums, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create busidirectory content, create page content, create pp_group_page content, create ppcalevent content, create story content, edit any bulletin_board_entry content, edit any busidirectory content, edit own bulletin_board_entry content, edit own busidirectory content, edit own page content, edit own pp_group_page content, edit own ppcalevent content, edit own story content, edit any page content, edit any pp_group_page content, edit any ppcalevent content, edit any story content, administer organic groups, cancel own vote, create poll content, inspect all votes, vote on polls, administer search, search content, use advanced search, administer newsletters, create newsletter, edit any newsletter, edit own newsletter, send newsletter, subscribe to newsletters, view links in block, access statistics, access administration pages, access user profiles' WHERE rid = 3

Update #6040

    ALTER TABLE {upload} ADD `weight` TINYINT NOT NULL DEFAULT 0

Update #6041

    UPDATE {vocabulary} SET required = 0 WHERE vid = 1
    UPDATE {system} SET weight = 1 WHERE name = 'forum'

Update #6042

    No queries

Update #6043

    ALTER TABLE {flood} ADD INDEX allow (event, hostname, timestamp)
    ALTER TABLE {history} ADD INDEX nid (nid)
    ALTER TABLE {blocks} CHANGE `theme` `theme` VARCHAR(64) NOT NULL DEFAULT '', ADD UNIQUE KEY tmd (theme, module, delta), ADD INDEX list (theme, status, region, weight, module)
    ALTER TABLE {blocks_roles} ADD INDEX rid (rid)
    ALTER TABLE {filters} DROP INDEX weight
    ALTER TABLE {filters} ADD UNIQUE KEY fmd (format, module, delta)
    ALTER TABLE {filters} ADD INDEX list (format, weight, module, delta)
    ALTER TABLE {node} DROP INDEX status
    ALTER TABLE {node} DROP KEY nid_vid
    ALTER TABLE {users} ADD INDEX mail (mail)
    ALTER TABLE {users_roles} ADD INDEX rid (rid)
    ALTER TABLE {aggregator_category_feed} DROP PRIMARY KEY
    ALTER TABLE {aggregator_category_feed} ADD PRIMARY KEY (cid, fid)
    ALTER TABLE {aggregator_category_feed} ADD INDEX fid (fid)
    ALTER TABLE {aggregator_category_item} DROP PRIMARY KEY
    ALTER TABLE {aggregator_category_item} ADD PRIMARY KEY (cid, iid)
    ALTER TABLE {aggregator_category_item} ADD INDEX iid (iid)
    ALTER TABLE {contact} ADD INDEX list (weight, category)
    ALTER TABLE {locales_target} ADD PRIMARY KEY (language, lid, plural)
    ALTER TABLE {poll_votes} DROP INDEX nid
    ALTER TABLE {poll_votes} ADD PRIMARY KEY (nid, uid, hostname)
    ALTER TABLE {profile_values} DROP INDEX uid
    ALTER TABLE {profile_values} DROP INDEX fid
    ALTER TABLE {profile_values} CHANGE `fid` `fid` INT unsigned NOT NULL DEFAULT 0, ADD INDEX fid (fid)
    ALTER TABLE {profile_values} CHANGE `uid` `uid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {profile_values} ADD PRIMARY KEY (uid, fid)
    ALTER TABLE {accesslog} ADD INDEX uid (uid)
    ALTER TABLE {term_data} DROP INDEX vid
    ALTER TABLE {term_data} ADD INDEX vid_name (vid, name)
    ALTER TABLE {term_data} ADD INDEX taxonomy_tree (vid, weight, name)
    ALTER TABLE {term_node} DROP PRIMARY KEY
    ALTER TABLE {term_node} DROP INDEX tid
    ALTER TABLE {term_node} ADD PRIMARY KEY (tid, vid)
    ALTER TABLE {term_relation} DROP INDEX tid1
    ALTER TABLE {term_relation} ADD UNIQUE KEY tid1_tid2 (tid1, tid2)
    ALTER TABLE {term_synonym} DROP INDEX name
    ALTER TABLE {term_synonym} ADD INDEX name_tid (name, tid)
    ALTER TABLE {vocabulary} ADD INDEX list (weight, name)
    ALTER TABLE {vocabulary_node_types} DROP PRIMARY KEY
    ALTER TABLE {vocabulary_node_types} ADD PRIMARY KEY (type, vid)
    ALTER TABLE {vocabulary_node_types} ADD INDEX vid (vid)

Update #6044

    DELETE FROM {term_node} WHERE vid = 0

Update #6045

    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, post comments, post comments without approval, access site-wide contact form, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create pp_group_page content, create ppcalevent content, edit own bulletin_board_entry content, edit own pp_group_page content, edit own ppcalevent content, create poll content, vote on polls, search content, subscribe to newsletters' WHERE rid = 2
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer forums, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create busidirectory content, create page content, create pp_group_page content, create ppcalevent content, create story content, edit any bulletin_board_entry content, edit any busidirectory content, edit own bulletin_board_entry content, edit own busidirectory content, edit own page content, edit own pp_group_page content, edit own ppcalevent content, edit own story content, edit any page content, edit any pp_group_page content, edit any ppcalevent content, edit any story content, administer organic groups, cancel own vote, create poll content, inspect all votes, vote on polls, administer search, search content, use advanced search, administer newsletters, create newsletter, edit any newsletter, edit own newsletter, send newsletter, subscribe to newsletters, view links in block, access statistics, access administration pages, access user profiles' WHERE rid = 3

Update #6046

    No queries

Update #6047

    UPDATE {blocks} SET cache = -1 WHERE module = 'user' AND delta IN ('0', '1')
    UPDATE {blocks} SET cache = -1 WHERE module = 'system' AND delta = '0'

Update #6048

    ALTER TABLE {menu_router} CHANGE `load_functions` `load_functions` TEXT NOT NULL
    ALTER TABLE {menu_router} CHANGE `to_arg_functions` `to_arg_functions` TEXT NOT NULL

Update #6049

    ALTER TABLE {url_alias} DROP INDEX src
    ALTER TABLE {url_alias} ADD INDEX src_language (src, language)

Update #6050

    No queries

Update #6051

    ALTER TABLE {users} ADD `signature_format` SMALLINT NOT NULL DEFAULT 0

Update #6052

    ALTER TABLE {menu_router} ADD INDEX tab_root_weight_title (tab_root(64), weight, title)

Update #6053

    ALTER TABLE {system} ADD INDEX type_name (type(12), name)

Update #6054

    No queries

Update #6055

    ALTER TABLE {url_alias} DROP INDEX src_language
    ALTER TABLE {url_alias} DROP KEY dst_language
    ALTER TABLE {url_alias} ADD INDEX src_language_pid (src, language, pid)
    ALTER TABLE {url_alias} ADD UNIQUE KEY dst_language_pid (dst, language, pid)

comment module
Update #6001

    ALTER TABLE {comments} DROP score
    ALTER TABLE {comments} DROP users

Update #6002

    Global comment settings copied to all node types.

Update #6003

    ALTER TABLE {comments} ADD INDEX pid (pid)

date_api module
Update #6000

    Failed: date.module has updates, but cannot be updated until views.module is updated first.

forum module
Update #6000

    No queries

statistics module
Update #6000

    ALTER TABLE {accesslog} CHANGE `url` `url` TEXT DEFAULT NULL

date module
Update #6000

    Failed: Some updates are still pending.
    Please re-run the update script.

mollom module
Update #1

    ALTER TABLE {mollom} ADD `languages` VARCHAR(255) NOT NULL DEFAULT ''

Update #2

    CREATE TABLE {cache_mollom} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #3

    No queries

Update #4

    No queries

Update #6105

    CREATE TABLE {mollom_form} ( `form_id` VARCHAR(255) NOT NULL DEFAULT '', `mode` TINYINT NOT NULL DEFAULT 0, `enabled_fields` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (form_id) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #6106

    ALTER TABLE {mollom} ADD `entity` VARCHAR(32) NOT NULL DEFAULT ''
    ALTER TABLE {mollom} DROP PRIMARY KEY
    ALTER TABLE {mollom} ADD PRIMARY KEY (entity, did)
    UPDATE {mollom} SET entity = 'node' WHERE did LIKE 'node-%'
    UPDATE {mollom} SET did = SUBSTR(did, 6) WHERE entity = 'node'
    UPDATE {mollom} SET entity = 'comment' WHERE did LIKE 'comment-%'
    UPDATE {mollom} SET did = SUBSTR(did, 9) WHERE entity = 'comment'
    ALTER TABLE {mollom} CHANGE `did` `did` VARCHAR(32) NOT NULL DEFAULT ''

Update #6107

    Link to Mollom's privacy policy on forms protected via textual analysis has been disabled.

Update #6108

    UPDATE {permission} SET perm = REPLACE(perm, 'post with no checking', 'bypass mollom protection')

Update #6109

    No queries

Update #6110

    No queries

Update #6111

    UPDATE {mollom_form} SET enabled_fields = '%s' WHERE mode = %d

Update #6112

    ALTER TABLE {mollom} ADD `changed` INT NOT NULL DEFAULT 0

Update #6113

    ALTER TABLE {mollom_form} ADD `checks` TEXT DEFAULT NULL
    UPDATE {mollom_form} SET checks = '%s'

Update #6114

    ALTER TABLE {mollom} CHANGE `quality` `quality` FLOAT DEFAULT NULL
    ALTER TABLE {mollom} ADD `spam` TINYINT DEFAULT NULL
    UPDATE {mollom} SET spam = 2 WHERE quality < 0.5
    UPDATE {mollom} SET spam = 3 WHERE quality = 0.5
    UPDATE {mollom} SET spam = 1 WHERE quality > 0.5

Update #6115

    ALTER TABLE {mollom} ADD `form_id` VARCHAR(255) NOT NULL DEFAULT ''
    UPDATE {mollom} SET form_id = 'user_register' WHERE entity = 'user'
    UPDATE {mollom} SET form_id = 'contact_mail_page' WHERE entity = 'session'
    UPDATE {mollom} SET form_id = CONCAT('webform_client_form_', did) WHERE entity = 'webform'
    UPDATE {mollom} SET form_id = 'comment_form' WHERE entity = 'comment'

Update #6116

    ALTER TABLE {mollom} DROP PRIMARY KEY
    ALTER TABLE {mollom} CHANGE `did` `id` VARCHAR(32) NOT NULL DEFAULT ''
    ALTER TABLE {mollom} ADD PRIMARY KEY (entity, id)
    ALTER TABLE {mollom} DROP INDEX session
    ALTER TABLE {mollom} CHANGE `session` `session_id` VARCHAR(255) NOT NULL DEFAULT ''
    ALTER TABLE {mollom} ADD INDEX session_id (session_id)

Update #6117

    ALTER TABLE {mollom_form} ADD `discard` TINYINT NOT NULL DEFAULT 1

Update #6118

    No queries

Update #6119

    ALTER TABLE {mollom} ADD `profanity` FLOAT DEFAULT NULL

Update #6120

    ALTER TABLE {mollom_form} ADD `strictness` VARCHAR(8) NOT NULL DEFAULT 'normal'

Update #6121

    ALTER TABLE {mollom_form} CHANGE `strictness` `strictness` VARCHAR(8) NOT NULL DEFAULT 'normal'
    UPDATE {mollom_form} SET strictness = 'normal' WHERE strictness = 'medium'

webform module
Update #6001

    ALTER TABLE {webform_submissions} DROP PRIMARY KEY
    ALTER TABLE {webform_submissions} DROP KEY sid_nid
    ALTER TABLE {webform_submissions} CHANGE `sid` `sid` INT NOT NULL auto_increment, ADD PRIMARY KEY (sid)
    ALTER TABLE {webform_submissions} ADD UNIQUE KEY sid_nid (sid, nid)

Update #6200

    ALTER TABLE {webform_component} CHANGE `name` `name` VARCHAR(255) DEFAULT 'NULL'

Update #6201

    No queries

Update #6202

    No queries

Update #6203

    No queries

Update #6204

    UPDATE {files} SET status = 1 WHERE filepath LIKE 'files/webform/%'

Update #6205

    ALTER TABLE {webform} DROP PRIMARY KEY
    ALTER TABLE {webform} CHANGE `nid` `nid` INT unsigned NOT NULL, ADD PRIMARY KEY (nid)
    ALTER TABLE {webform} CHANGE `confirmation` `confirmation` TEXT NOT NULL
    ALTER TABLE {webform} CHANGE `submit_limit` `submit_limit` TINYINT NOT NULL DEFAULT -1
    ALTER TABLE {webform} CHANGE `submit_interval` `submit_interval` INT NOT NULL DEFAULT -1
    ALTER TABLE {webform} CHANGE `additional_validate` `additional_validate` TEXT NOT NULL
    ALTER TABLE {webform} CHANGE `additional_submit` `additional_submit` TEXT NOT NULL
    ALTER TABLE {webform_component} CHANGE `name` `name` VARCHAR(255) DEFAULT NULL
    ALTER TABLE {webform_component} CHANGE `value` `value` TEXT NOT NULL
    ALTER TABLE {webform_component} CHANGE `extra` `extra` TEXT NOT NULL
    ALTER TABLE {webform_component} CHANGE `mandatory` `mandatory` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {webform_component} CHANGE `weight` `weight` SMALLINT NOT NULL DEFAULT 0
    ALTER TABLE {webform_submissions} DROP KEY sid_nid
    ALTER TABLE {webform_submissions} CHANGE `sid` `sid` INT unsigned NOT NULL
    ALTER TABLE {webform_submissions} DROP PRIMARY KEY
    ALTER TABLE {webform_submissions} CHANGE `sid` `sid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (sid), ADD UNIQUE KEY sid_nid (sid, nid)
    ALTER TABLE {webform_submitted_data} DROP PRIMARY KEY
    ALTER TABLE {webform_submitted_data} DROP INDEX nid
    ALTER TABLE {webform_submitted_data} DROP INDEX sid_nid
    ALTER TABLE {webform_submitted_data} CHANGE `no` `no` TINYINT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {webform_submitted_data} CHANGE `data` `data` MEDIUMTEXT NOT NULL
    ALTER TABLE {webform_submitted_data} ADD PRIMARY KEY (nid, sid, cid, no)
    ALTER TABLE {webform_submitted_data} ADD INDEX nid (nid)
    ALTER TABLE {webform_submitted_data} ADD INDEX sid_nid (sid, nid)

Update #6301

    ALTER TABLE {webform} ADD `confirmation_format` TINYINT NOT NULL DEFAULT 0

Update #6302

    CREATE TABLE {webform_emails} ( `nid` INT unsigned NOT NULL DEFAULT 0, `eid` SMALLINT unsigned NOT NULL DEFAULT 0, `email` TEXT DEFAULT NULL, `subject` VARCHAR(255) DEFAULT NULL, `from_name` VARCHAR(255) DEFAULT NULL, `from_address` VARCHAR(255) DEFAULT NULL, `template` TEXT DEFAULT NULL, PRIMARY KEY (nid, eid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    ALTER TABLE {webform} DROP email
    ALTER TABLE {webform} DROP email_from_name
    ALTER TABLE {webform} DROP email_from_address
    ALTER TABLE {webform} DROP email_subject

Update #6303

    ALTER TABLE {webform} ADD `submit_notice` TINYINT NOT NULL DEFAULT 0
    UPDATE {webform} SET submit_notice = 1 WHERE submit_notice = 0

Update #6304

    UPDATE {node_type} SET module = 'node', custom = 1, modified = 1, locked = 0 WHERE type = 'webform'

Update #6305

    UPDATE {permission} SET perm = 'access comments, access site-wide contact form, access content, search content' WHERE rid = 1
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, post comments, post comments without approval, access site-wide contact form, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create pp_group_page content, create ppcalevent content, edit own bulletin_board_entry content, edit own pp_group_page content, edit own ppcalevent content, create poll content, vote on polls, search content, subscribe to newsletters' WHERE rid = 2
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer forums, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create busidirectory content, create page content, create pp_group_page content, create ppcalevent content, create story content, edit any bulletin_board_entry content, edit any busidirectory content, edit own bulletin_board_entry content, edit own busidirectory content, edit own page content, edit own pp_group_page content, edit own ppcalevent content, edit own story content, edit any page content, edit any pp_group_page content, edit any ppcalevent content, edit any story content, administer organic groups, cancel own vote, create poll content, inspect all votes, vote on polls, administer search, search content, use advanced search, administer newsletters, create newsletter, edit any newsletter, edit own newsletter, send newsletter, subscribe to newsletters, view links in block, access statistics, access administration pages, access user profiles' WHERE rid = 3

Update #6306

    ALTER TABLE {webform} ADD `allow_draft` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {webform_submissions} ADD `is_draft` TINYINT NOT NULL DEFAULT 0

Update #6307

    Updated file components to use numeric file IDs in the submitted values.

Update #6308

    ALTER TABLE {webform_emails} ADD `excluded_components` TEXT DEFAULT NULL
    UPDATE {webform_emails} SET excluded_components = '%s' ()
    ALTER TABLE {webform_emails} CHANGE `excluded_components` `excluded_components` TEXT NOT NULL
    ALTER TABLE {webform_component} DROP email

Update #6309

    UPDATE {permission} SET perm = 'access comments, access site-wide contact form, access content, search content' WHERE rid = 1
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, post comments, post comments without approval, access site-wide contact form, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create pp_group_page content, create ppcalevent content, edit own bulletin_board_entry content, edit own pp_group_page content, edit own ppcalevent content, create poll content, vote on polls, search content, subscribe to newsletters' WHERE rid = 2
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer forums, create forum topics, edit own forum topics, create images, edit own images, rate content, access content, create bulletin_board_entry content, create busidirectory content, create page content, create pp_group_page content, create ppcalevent content, create story content, edit any bulletin_board_entry content, edit any busidirectory content, edit own bulletin_board_entry content, edit own busidirectory content, edit own page content, edit own pp_group_page content, edit own ppcalevent content, edit own story content, edit any page content, edit any pp_group_page content, edit any ppcalevent content, edit any story content, administer organic groups, cancel own vote, create poll content, inspect all votes, vote on polls, administer search, search content, use advanced search, administer newsletters, create newsletter, edit any newsletter, edit own newsletter, send newsletter, subscribe to newsletters, view links in block, access statistics, access administration pages, access user profiles' WHERE rid = 3

Update #6310

    ALTER TABLE {webform} ADD `redirect_url` VARCHAR(255) DEFAULT NULL

Update #6311

    ALTER TABLE {webform_submitted_data} DROP PRIMARY KEY
    ALTER TABLE {webform_submitted_data} CHANGE `no` `no` VARCHAR(128) NOT NULL DEFAULT '0'
    ALTER TABLE {webform_submitted_data} ADD PRIMARY KEY (nid, sid, cid, no)
    UPDATE {webform_submitted_data} SET no = 'month' WHERE no = '0' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'date')
    UPDATE {webform_submitted_data} SET no = 'day' WHERE no = '1' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'date')
    UPDATE {webform_submitted_data} SET no = 'year' WHERE no = '2' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'date')
    UPDATE {webform_submitted_data} SET no = 'hour' WHERE no = '0' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'time')
    UPDATE {webform_submitted_data} SET no = 'minute' WHERE no = '1' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'time')
    UPDATE {webform_submitted_data} SET no = 'ampm' WHERE no = '2' AND (nid, cid) IN (SELECT nid, cid FROM {webform_component} WHERE type = 'time')

Update #6312

    No queries

Update #6313

    No queries

Update #6314

    Updated date and time components to use ISO 8601 formatted strings in the submitted values.

Update #6315

    Removed Webform-specific daylight savings handling, now provided by Date API module if available.

Update #6316

    Removed the webform_debug variable which is no longer used.

Update #6317

    DELETE FROM {webform_emails} WHERE nid NOT IN (SELECT nid FROM {node})

Update #6318

    ALTER TABLE {webform} CHANGE `confirmation_format` `confirmation_format` TINYINT NOT NULL DEFAULT 0

Update #6319

    ALTER TABLE {webform_emails} ADD `html` TINYINT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {webform_emails} ADD `attachments` TINYINT unsigned NOT NULL DEFAULT 0

Update #6320

    ALTER TABLE {webform} CHANGE `submit_notice` `submit_notice` TINYINT NOT NULL DEFAULT 1

Update #6321

    ALTER TABLE {webform} ADD `block` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {webform} CHANGE `redirect_url` `redirect_url` VARCHAR(255) DEFAULT '<confirmation>'

Update #6322

    ALTER TABLE {webform} CHANGE `additional_validate` `additional_validate` TEXT DEFAULT NULL
    ALTER TABLE {webform} CHANGE `additional_submit` `additional_submit` TEXT DEFAULT NULL

Update #6323

    ALTER TABLE {webform} ADD `status` TINYINT NOT NULL DEFAULT 1

Update #6324

    ALTER TABLE {webform} ADD `auto_save` TINYINT NOT NULL DEFAULT 0

Update #6325

    No queries

Update #6326

    ALTER TABLE {webform_submissions} ADD INDEX nid_uid_sid (nid, uid, sid)

Update #6327

    No queries

content module
Update #6000

    ALTER TABLE {node_field} ADD `module` VARCHAR(127) NOT NULL DEFAULT ''
    ALTER TABLE {node_field} ADD `db_columns` MEDIUMTEXT DEFAULT NULL
    UPDATE {node_field} SET db_columns = '%s' ()
    ALTER TABLE {node_field} CHANGE `db_columns` `db_columns` MEDIUMTEXT NOT NULL
    ALTER TABLE {node_field} ADD `active` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {node_field_instance} ADD `widget_module` VARCHAR(127) NOT NULL DEFAULT ''
    ALTER TABLE {node_field_instance} ADD `widget_active` TINYINT NOT NULL DEFAULT 0
    DROP TABLE {cache_content}
    CREATE TABLE {cache_content} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    DELETE FROM {cache}

Update #6001

    ALTER TABLE {node_field} RENAME TO {content_node_field}
    ALTER TABLE {node_field_instance} RENAME TO {content_node_field_instance}

Update #6002

    No queries

Update #6003

    No queries

Update #6004

    No queries

Update #6005

    ALTER TABLE {content_node_field} ADD `locked` TINYINT NOT NULL DEFAULT 0

Update #6006

    ALTER TABLE {content_node_field} CHANGE `locked` `locked` TINYINT NOT NULL DEFAULT 0

Update #6007

    No queries

Update #6008

    No queries

Update #6009

    No queries

Update #6010

    No queries

fieldgroup module
Update #6000

    ALTER TABLE {node_group} RENAME TO {content_group}
    ALTER TABLE {node_group_fields} RENAME TO {content_group_fields}

Update #6001

    UPDATE {system} SET weight = 9 WHERE name = 'fieldgroup'

Update #6002

    No queries

Update #6003

    ALTER TABLE {content_group} CHANGE `weight` `weight` INT NOT NULL DEFAULT 0

Update #6004

    ALTER TABLE {content_group} ADD `group_type` VARCHAR(32) NOT NULL DEFAULT 'standard'
    DELETE FROM {cache_content} WHERE cid='fieldgroup_data'

Update #6005

    No queries

Update #6006

    No queries

Update #6007

    DELETE FROM {content_group_fields} WHERE (field_name, type_name) NOT IN (SELECT field_name, type_name FROM {content_node_field_instance})

nodereference module
Update #6000

    Failed: nodereference.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

number module
Update #6000

    Failed: number.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

optionwidgets module
Update #6000

    Failed: optionwidgets.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

text module
Update #6000

    UPDATE {content_node_field_instance} SET widget_module = 'text', widget_type = 'text_textarea' WHERE field_name = 'field_busiaddress2' AND type_name = 'busidirectory'
    UPDATE {content_node_field_instance} SET widget_module = 'text', widget_type = 'text_textarea' WHERE field_name = 'field_garage_sale_address' AND type_name = 'bulletin_board_entry'

Update #6001

    ALTER TABLE {content_type_bulletin_board_entry} CHANGE `field_garage_sale_address_value` `field_garage_sale_address_value` LONGTEXT DEFAULT NULL
    ALTER TABLE {content_type_bulletin_board_entry} ALTER COLUMN field_garage_sale_address_value DROP DEFAULT
    UPDATE {content_type_bulletin_board_entry} SET field_garage_sale_address_value = NULL WHERE field_garage_sale_address_value = ''
    ALTER TABLE {content_type_bulletin_board_entry} CHANGE `field_garage_sale_address_format` `field_garage_sale_address_format` INT unsigned DEFAULT NULL
    ALTER TABLE {content_type_bulletin_board_entry} ALTER COLUMN field_garage_sale_address_format DROP DEFAULT
    UPDATE {content_type_bulletin_board_entry} SET field_garage_sale_address_format = NULL WHERE field_garage_sale_address_format = 0
    ALTER TABLE {content_type_busidirectory} CHANGE `field_busiaddress2_value` `field_busiaddress2_value` VARCHAR(100) DEFAULT NULL
    ALTER TABLE {content_type_busidirectory} ALTER COLUMN field_busiaddress2_value DROP DEFAULT
    UPDATE {content_type_busidirectory} SET field_busiaddress2_value = NULL WHERE field_busiaddress2_value = ''

Update #6002

    No queries

Update #6003

    ALTER TABLE {content_type_bulletin_board_entry} CHANGE `field_garage_sale_address_value` `field_garage_sale_address_value` LONGTEXT DEFAULT NULL
    ALTER TABLE {content_type_bulletin_board_entry} ALTER COLUMN field_garage_sale_address_value DROP DEFAULT
    UPDATE {content_type_bulletin_board_entry} SET field_garage_sale_address_value = NULL WHERE field_garage_sale_address_value = ''
    ALTER TABLE {content_type_bulletin_board_entry} CHANGE `field_garage_sale_address_format` `field_garage_sale_address_format` INT unsigned DEFAULT NULL
    ALTER TABLE {content_type_bulletin_board_entry} ALTER COLUMN field_garage_sale_address_format DROP DEFAULT
    UPDATE {content_type_bulletin_board_entry} SET field_garage_sale_address_format = NULL WHERE field_garage_sale_address_format = 0
    ALTER TABLE {content_type_busidirectory} CHANGE `field_busiaddress2_value` `field_busiaddress2_value` VARCHAR(100) DEFAULT NULL
    ALTER TABLE {content_type_busidirectory} ALTER COLUMN field_busiaddress2_value DROP DEFAULT
    UPDATE {content_type_busidirectory} SET field_busiaddress2_value = NULL WHERE field_busiaddress2_value = ''

userreference module
Update #6000

    Failed: userreference.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

link module
Update #6000

    No queries

Update #6001

    ALTER TABLE {content_type_busidirectory} CHANGE `field_webstie_url` `field_webstie_url` VARCHAR(2048) DEFAULT NULL
    UPDATE {content_type_busidirectory} SET field_webstie_url = NULL WHERE field_webstie_url = '' OR field_webstie_url = 'N;'
    ALTER TABLE {content_type_busidirectory} CHANGE `field_webstie_title` `field_webstie_title` VARCHAR(255) DEFAULT NULL
    UPDATE {content_type_busidirectory} SET field_webstie_title = NULL WHERE field_webstie_title = '' OR field_webstie_title = 'N;'
    ALTER TABLE {content_type_busidirectory} CHANGE `field_webstie_attributes` `field_webstie_attributes` MEDIUMTEXT DEFAULT NULL
    UPDATE {content_type_busidirectory} SET field_webstie_attributes = NULL WHERE field_webstie_attributes = '' OR field_webstie_attributes = 'N;'
    ALTER TABLE {content_type_ppcalevent} CHANGE `field_ppcal_eventlink_url` `field_ppcal_eventlink_url` VARCHAR(2048) DEFAULT NULL
    UPDATE {content_type_ppcalevent} SET field_ppcal_eventlink_url = NULL WHERE field_ppcal_eventlink_url = '' OR field_ppcal_eventlink_url = 'N;'
    ALTER TABLE {content_type_ppcalevent} CHANGE `field_ppcal_eventlink_title` `field_ppcal_eventlink_title` VARCHAR(255) DEFAULT NULL
    UPDATE {content_type_ppcalevent} SET field_ppcal_eventlink_title = NULL WHERE field_ppcal_eventlink_title = '' OR field_ppcal_eventlink_title = 'N;'
    ALTER TABLE {content_type_ppcalevent} CHANGE `field_ppcal_eventlink_attributes` `field_ppcal_eventlink_attributes` MEDIUMTEXT DEFAULT NULL
    UPDATE {content_type_ppcalevent} SET field_ppcal_eventlink_attributes = NULL WHERE field_ppcal_eventlink_attributes = '' OR field_ppcal_eventlink_attributes = 'N;'

Update #6002

    UPDATE {content_type_busidirectory} SET field_webstie_attributes = NULL WHERE field_webstie_attributes = '%s'
    UPDATE {content_type_ppcalevent} SET field_ppcal_eventlink_attributes = NULL WHERE field_ppcal_eventlink_attributes = '%s'

phone module
Update #6200

    No queries

views module
Update #6000

    DROP TABLE {cache_views}
    CREATE TABLE {views_view} ( `vid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(32) NOT NULL DEFAULT '', `description` VARCHAR(255) DEFAULT '', `tag` VARCHAR(255) DEFAULT '', `view_php` BLOB DEFAULT NULL, `base_table` VARCHAR(32) NOT NULL DEFAULT '', `is_cacheable` TINYINT DEFAULT 0, PRIMARY KEY (vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    CREATE TABLE {views_display} ( `vid` INT unsigned NOT NULL DEFAULT 0, `id` VARCHAR(64) NOT NULL DEFAULT '', `display_title` VARCHAR(64) NOT NULL DEFAULT '', `display_plugin` VARCHAR(64) NOT NULL DEFAULT '', `position` INT DEFAULT 0, `display_options` BLOB DEFAULT NULL, INDEX vid (vid, position) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    CREATE TABLE {cache_views} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    CREATE TABLE {views_object_cache} ( `sid` VARCHAR(64) DEFAULT NULL, `name` VARCHAR(32) DEFAULT NULL, `obj` VARCHAR(32) DEFAULT NULL, `updated` INT unsigned NOT NULL DEFAULT 0, `data` BLOB DEFAULT NULL, INDEX sid_obj_name (sid, obj, name), INDEX updated (updated) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #6001

    No queries

Update #6003

    ALTER TABLE {views_view} ADD UNIQUE KEY name (name)

Update #6004

    ALTER TABLE {views_object_cache} DROP data
    ALTER TABLE {views_object_cache} ADD `data` LONGTEXT DEFAULT NULL

Update #6005

    ALTER TABLE {views_view} CHANGE `base_table` `base_table` VARCHAR(64) NOT NULL DEFAULT ''

Update #6006

    CREATE TABLE {cache_views_data} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 1, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET utf8 */

Update #6007

    No queries

Update #6008

    ALTER TABLE {views_display} ADD PRIMARY KEY (vid, id)

Update #6009

    ALTER TABLE {views_display} CHANGE `display_options` `display_options` LONGTEXT DEFAULT NULL

image module
Update #6100

    ALTER TABLE {image} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {image} CHANGE `fid` `fid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {image} DROP PRIMARY KEY
    ALTER TABLE {image} ADD PRIMARY KEY (nid, image_size)
    ALTER TABLE {image} DROP INDEX image_fid
    ALTER TABLE {image} ADD INDEX fid (fid)
    If you see a message of the form "Failed: ALTER TABLE {image} DROP PRIMARY KEY" or "DROP INDEX image_fid" here it is harmless.

Update #6101

    No queries

Update #6102

    No queries

Update #6103

    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, post comments, post comments without approval, access site-wide contact form, create forum topics, edit own forum topics, create images, edit own images, delete own images, rate content, access content, create bulletin_board_entry content, create pp_group_page content, create ppcalevent content, edit own bulletin_board_entry content, edit own pp_group_page content, edit own ppcalevent content, create poll content, vote on polls, search content, subscribe to newsletters' WHERE rid = 2
    UPDATE {permission} SET perm = 'access news feeds, create blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access site-wide contact form, administer forums, create forum topics, edit own forum topics, create images, edit own images, delete own images, rate content, access content, create bulletin_board_entry content, create busidirectory content, create page content, create pp_group_page content, create ppcalevent content, create story content, edit any bulletin_board_entry content, edit any busidirectory content, edit own bulletin_board_entry content, edit own busidirectory content, edit own page content, edit own pp_group_page content, edit own ppcalevent content, edit own story content, edit any page content, edit any pp_group_page content, edit any ppcalevent content, edit any story content, administer organic groups, cancel own vote, create poll content, inspect all votes, vote on polls, administer search, search content, use advanced search, administer newsletters, create newsletter, edit any newsletter, edit own newsletter, send newsletter, subscribe to newsletters, view links in block, access statistics, access administration pages, access user profiles' WHERE rid = 3

Update #6104

    ALTER TABLE {image} ALTER COLUMN image_size SET DEFAULT ''

image_attach module
Update #6100

    ALTER TABLE {image_attach} CHANGE `nid` `nid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {image_attach} CHANGE `iid` `iid` INT unsigned NOT NULL DEFAULT 0
    ALTER TABLE {image_attach} DROP PRIMARY KEY
    ALTER TABLE {image_attach} ADD PRIMARY KEY (nid)
    ALTER TABLE {image_attach} DROP INDEX iid
    ALTER TABLE {image_attach} ADD INDEX iid (iid)
    If you see a message of the form "Failed: ALTER TABLE {image_attach} DROP PRIMARY KEY" or "DROP INDEX iid" here it is harmless.

Update #6101

    DELETE FROM {blocks} WHERE module = 'image_attach' AND delta = '0'

Update #6102

    ALTER TABLE {image_attach} DROP PRIMARY KEY
    ALTER TABLE {image_attach} ADD PRIMARY KEY (nid, iid)
    ALTER TABLE {image_attach} ADD `weight` INT NOT NULL DEFAULT 0

Update #6103

    DELETE FROM {image_attach} WHERE iid = 0

image_gallery module
Update #6100

    No queries

Update #6101

    No queries

calendar module
Update #6000

    No queries

Update #6001

    DELETE FROM {views_display} WHERE display_plugin = 'ical'

Update #6002

    Updated calendar displays to use new handlers.

og module
Update #5703

    No queries

Update #6000

    No queries

Update #6001

    UPDATE {blocks} SET module = 'og_views', delta = '1' WHERE module = 'og' AND delta = '5'

Update #6002

    ALTER TABLE {og} CHANGE `selective` `og_selective` INT NOT NULL DEFAULT 0
    ALTER TABLE {og} CHANGE `register` `og_register` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {og} CHANGE `theme` `og_theme` VARCHAR(255) DEFAULT NULL
    ALTER TABLE {og} CHANGE `directory` `og_directory` TINYINT NOT NULL DEFAULT 0
    ALTER TABLE {og} CHANGE `description` `og_description` VARCHAR(255) DEFAULT NULL
    ALTER TABLE {og} CHANGE `language` `og_language` VARCHAR(12) NOT NULL DEFAULT ''
    ALTER TABLE {og} CHANGE `private` `og_private` TINYINT NOT NULL DEFAULT 0

Update #6203

    No queries

og_access module
Update #6201

    CREATE TABLE {og_access_post} ( `nid` INT NOT NULL, `og_public` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    INSERT INTO {og_access_post} (nid, og_public) SELECT DISTINCT(nid), (SELECT oga_sub.is_public FROM {og_ancestry} oga_sub WHERE oga_sub.nid = oga.nid LIMIT 1) FROM {og_ancestry} oga
    ALTER TABLE {og_ancestry} DROP is_public
    CREATE TABLE {og_ancestry_new} ( `nid` INT NOT NULL, `group_nid` INT NOT NULL ) /*!40100 DEFAULT CHARACTER SET utf8 */
    INSERT INTO {og_ancestry_new} SELECT DISTINCT * FROM {og_ancestry}
    DROP TABLE {og_ancestry}
    ALTER TABLE {og_ancestry_new} RENAME TO {og_ancestry}
    ALTER TABLE {og_ancestry} ADD PRIMARY KEY (nid, group_nid)

I will rerun the update again based on the message and report on what I find.

Did final update.php (D5 to D6) Here is update log.

The following queries were executed
date module
Update #6005

    Field field_time formats were converted to custom formats.
    The old format type short for field field_time was converted to the new format type field_time_short.
    The old format type medium for field field_time was converted to the new format type field_time_medium.
    The old format type long for field field_time was converted to the new format type long.
    The old format type default for field field_time was converted to the new format type field_time_default.
    The display settings for field field_time in content type ppcalevent were updated.
    Field field_garage_sale_date formats were converted to custom formats.
    The old format type short for field field_garage_sale_date was converted to the new format type field_garage_sale_date_short.
    The old format type medium for field field_garage_sale_date was converted to the new format type field_garage_sale_date_medium.
    The old format type long for field field_garage_sale_date was converted to the new format type field_garage_sale_date_long.
    The old format type default for field field_garage_sale_date was converted to the new format type field_garage_sale_date_short.
    The display settings for field field_garage_sale_date in content type bulletin_board_entry were updated.

nodereference module
Update #6000

    Failed: nodereference.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

number module
Update #6000

    Failed: number.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

optionwidgets module
Update #6000

    Failed: optionwidgets.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

userreference module
Update #6000

    Failed: userreference.module has updates and is available in the modules folder but is not enabled.
    If and when it is enabled, you will need to re-run the update script. You will continue to see this message until the module is enabled and updates are run.

Nothing alarming here ?

I attempted to do a D7 update and now all I get is a white screen as soon as I type in update.php.

Some updated information. I still couldn't get the new upgrade from D5 to D6 to actually upgrade to D7 as shown above due to a white screen.

I looked at your comment about the role and permission table in the original attempt workflow. The partially updated D7 database tables for roles had duplicate roles with new PID. I have three roles on my site, but the table showed 5. Rows 4 and 5 were duplicates of 1 and 2. So I deleted rows 4 and 5 and reran the update.php. This time, I did not get any FATAL errors ! I still have one error that I am listing below, but at the least the D7 site is now functioning.

filter module
Update #7003

    Failed: DatabaseSchemaObjectDoesNotExistException: Cannot rename <em class="placeholder">filters</em> to <em class="placeholder">d6_upgrade_filter</em>: table <em class="placeholder">filters</em> doesn't exist. in DatabaseSchema_mysql->renameTable() (line 299 of C:\Users\Mahmoud\Sites\peoriaparent5to6\includes\database\mysql\schema.inc).

Any thoughts ?

Regarding the filter table in the database. I checked the D7 database and the "filter" table DOES exist. So I am not sure where that error is coming from ?

@catch. Thanks for the notes. My initial attempt was an update from a fresh D6 database. My second attempt to redo the D6 to D7 failed due to a white screen error.
For the intial update, I did, however do what you suggested. I deleted the filer and d6_filters table from the D7 database. Copied the filters table from D6 into D7 database, then re ran the update.php script.
This time the error was gone, and the updated D7 {filter} table was created.

I am not sure about the success of this process. I still have one issue left.

1- Displaying the content of fields in my custom content, although the "manage fields" and display fields" in the custom content edit page shows that the fields do exist and are available. The only thing I see when I go to a custom node is the title field

Here is the sql dump for the D6 {filters} table in pdf and an image of the structure. Does the {filters} table affect how content is displayed ?

I really appreciate your help on this.

Here is how the {filters} table was converted to the {filter} table in D7.

Here is the D6 filters table sql dump text file

Marked #1084866: Update #7003 - Filter module - Failed as a duplicate of this.

@catch.

I wanted to let you know that I reran the update process all over again from D5 to D6 to D7. This time I has NO fatal errors at all. There were several errors that I can post here later if you are interested, but none were show stoppers.

I looked at my content, and as far as I can tell, the integrity of the data looks good. All stories, pages and custom content show fine ???? Very strange.

Anyway, the only problem is with a custom content that I had that had a custom DATE field is not showing in my calendar view. I am getting a SQL error when the view is displayed. I am not sure if this is realted to an improper update or something else.

I want to know what information you would like me to provide to help diagnose and close this current open issue?

Hi Guys,

the past two days I have been trying to upgrade from 5 to 7, getting similar issues like in this thread.
Am following the ReadMe to the point (after several failed attempts, I decided to try something new ;) )

Step 5.23->6.22 is ok, with no errors.
6.22->7.8 does not work at all.

Last attempt, is giving this error:

Warning: Cannot use a scalar value as an array in /www/.../docs/k1/modules/locale/locale.module on line 680
(the error seems to be PHP, not Drupal)

When continuing the upgrade, Drupal gives:
(RED) Notice: Undefined property: stdClass::$javascript in _locale_rebuild_js() (line 1893 of /www/.../docs/k1/includes/locale.inc).
(Yellow) Some user time zones have been emptied and need to be set to the correct values. Use the new time zone options to choose whether to remind users at login to set the correct time zone. The default time zone has been set to Europe/Paris. Check the date and time configuration page to configure it correctly.

I have backups of both the 5 SQL and the 6.22 tables. Can post if needed.

And. As I continued Upgrade, this time it actually worked. Beats me. Don't know how many times I have deleted, uploaded, restored database etc today and yesterday. Wish I knew what happend.

K

Update: When updating the modules (Views, antispam, Webform), the following error comes:

(RED) Notice: Undefined property: stdClass::$javascript in _locale_rebuild_js() (line 1893 of /www/katarinahjemmet/docs/k1/includes/locale.inc).

Then the status:

The following updates returned messages
webform module
Update #7314
Failed: DatabaseSchemaObjectExistsException: Table webform_last_download already exists. in DatabaseSchema->createTable() (line 652 of /www/katarinahjemmet/docs/k1/includes/database/schema.inc).

FIX: I just droped the table before re-running the update.

Hi,
As kairoer wrote on post #32, the problem seems having an issue around other modules than about upgrading from D5 (Views, antispam, Webform)

I face the same message when I try to create a new webform under D7:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'confirmation_format' cannot be null: INSERT INTO {webform} (nid, confirmation, confirmation_format, redirect_url, status, block, teaser, allow_draft, auto_save, submit_notice, submit_text, submit_limit, submit_interval) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12); Array ( [:db_insert_placeholder_0] => 21 [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => <confirmation> [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => -1 [:db_insert_placeholder_12] => -1 ) in drupal_write_record() (line 6868 of /xxx/includes/common.inc).

I had some problems when upgrading, but at the end I hadn't any error message (while update.php).

Also, another strange issue : I have multisites. But the problem with webform creation occurs only on one of my sites, and not on another one... I compared both MySql structure, and they are similar (empty).

Thanks if you have any idea...

After issues upgrading in drupal 6, just how stable and supported by additional module drupal 7 is. What are the disadvantages of not upgrading ?

Thank you

Cheers

Closing old, stale issues. Re-open if your problem persists.

I just ran an D5 to D6 to D7 upgrade and am having issues as described above. I really know nothing about MySQL so everyone that says they fixed their issue but didn't post step by step instructions, that's not very helpful.

I've attached a few screenshots to show my problems...

All help appreciated
David

This bug (again) cost me six hours of my weekend. The D5 heritage. Long story short:
- Start with D6 site
- Prepare for update (usual way: backup files and database)
- Upload D7 files but do not update yet.
- Go to (D6) database using PhpMyAdmin
- Find the 'Filters' row
- Empty this row (so /not/ delete it)
- Happy proceedings.

In the long run the Migrate module will solve this. I hope.

Throwing away your filters table is an extremely foolish thing to do but to each on their own. #36 has nothing to do with this issue , #37 did not include any error messages or anything to help with reproducing this.

It was the original filters-filter problem. Totally agree about the foolishness but I simply followed catch's advise in #20:
"You could also try truncating that [filters] table in a copy of your D6 database and running the upgrade without any data in it, to see if the upgrade successfully completes apart from this."

I also ran into this error "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry[error] '1-filter_autop' for key 'PRIMARY'" -- and used a ALTER IGNORE statement suggested in #2 above to fix it.

I ran this on my D6 database:

SELECT format, module, delta, COUNT(*) FROM filters GROUP BY format, module, delta HAVING COUNT(*) > 1;

and found that there was a duplicate entry in this result set. As recommended by https://www.drupal.org/node/333494 I then ran this:

ALTER IGNORE TABLE filters ADD UNIQUE INDEX(format, module, delta)

After which the database upgrade completed beautifully.