using sqlsrv, commit c01f8b0a7e52dbeed2dd72dcd1cf200ff0ef4176

attempting to update WISP stack with drupal 7.22 and 7.22-dev (commit 3f64ddc8866a99319cbab117f26015cc9834859a) both result in the PDOException:

The following updates returned messages

system module

Update #7078
Failed: PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]The object 'date_formats$formats' is dependent on column 'format_old'.: ALTER TABLE {date_formats} DROP COLUMN format_old; Array ( ) in db_change_field() (line 3017 of E:\Inetpub\cms-events-jpg\includes\database\database.inc).

Comments

Uncle_Code_Monkey’s picture

Uncle_Code_Monkey commented

This sounds like it may have to do with another bug, recently fixed:
SQL Server driver in #1830024: Cannot execute db_change_field() to convert nvarchar to varbinary

lyricnz provided a patch for it, which I have modified slightly and found that it fixed my similar issues quite nicely.

See my comment for my modified and tested patch.

You'll want to restore your database to what it was before you attempted the upgrade because the format_old field is now in an intermediate step during the db_change_field() method. Once you've restored your data and installed the patch, this particular problem should be fixed.

omegamonk’s picture

omegamonk commented
Status: Active » Fixed

The contrib patch for #1830024: Cannot execute db_change_field() to convert nvarchar to varbinary has been committed to the sqlsrv development release. I ran through the upgrade from 7.21 to 7.22 and did not experience this issue. Marking as fixed.

Status: Fixed » Closed (fixed)

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