Dear all,
I try to upgrade 6 to 7.
first part ok.
now there is 9 system module with pending update

7061 - Migrate upload.module data to the newly created file field.
7062 - Replace 'system_list' index with 'bootstrap' index on {system}.
7063 - Delete {menu_links} records for 'type' => MENU_CALLBACK which would not appear in a fresh install.
7064 - Remove block_callback field from {menu_router}.
7065 - Remove the default value for sid.
7066 - Migrate the 'file_directory_temp' variable.
7067 - Grant administrators permission to view the administration theme.
7068 - Update {url_alias}.language description.
7069 - Remove the obsolete 'site_offline' variable. @see update_fix_d7_requirements()

for the first I have an error so nothing update..

this is the error

DatabaseSchemaObjectExistsException: Table system_update_7061 already exists. in DatabaseSchema->createTable() (line 630 of /www/i/id/-/www/includes/database/schema.inc).

So I don t know how to solve this,
if anyone has an idea, I m open to try, and I wish someone has
I m stuck for now

Bruno

Comments

bfroehle’s picture

bfroehle commented

Why did the original update procedure stop at update 7061? That's where the error is. You'll probably need to roll your database all the way back to the 6.x version --- you did save a backup, right? --- and try again.

Might be related to #966210: DB Case Sensitivity: system_update_7061() fails on inserting files with same name but different case.

ricodol’s picture

ricodol commented

Indeed I have.
So all process again and the error is
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'public://images/africain.jpg' for key 'uri': INSERT INTO {file_managed} (fid, uid, filename, uri, filemime, filesize, status, timestamp) 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); Array ( [:db_insert_placeholder_0] => 230 [:db_insert_placeholder_1] => 3 [:db_insert_placeholder_2] => _original [:db_insert_placeholder_3] => public://images/africain.jpg [:db_insert_placeholder_4] => image/jpeg [:db_insert_placeholder_5] => 158286 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 0 ) in system_update_7061() (line 2836 of /www/i/id/ideespleinlesdoigts.com/www/modules/system/system.install).

and definitively related to case Sensivity
africain.JPG africain.jpg and others

so I removed duplicate entries from original table ( 6.20),
do the process again from original sql if not (error )
and update process finish without complain

so thks
Bruno

bfroehle’s picture

bfroehle commented
Status: Active » Closed (duplicate)

Glad to hear you got this working. Marking this as a duplicate of #966210: DB Case Sensitivity: system_update_7061() fails on inserting files with same name but different case.