Upgrade from patched 1.3 to 1.4 worked fine. However, when upgrading another site from 1.2 to 1.4, I encountered another database error:

Update #7100
Failed: PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Error: The new name 'taxonomy_index_nid_df' is already in use as a OBJECT name and would cause a duplicate that is not permitted.: EXEC sp_rename :old, :new, :type; Array ( [:old] => dbo.taxonomy_index_tmp_nid_df [:new] => taxonomy_index_nid_df [:type] => OBJECT ) in db_rename_table() (line 2865 of E:\inetpubtest\wwwroot\jurorportal\includes\database\database.inc).

Drupal 7.54 on Windows, IIS 7.5, PHP 5.6, and MSSQL Server.

Comments

rdellis87 created an issue. See original summary.

rdellis87’s picture

rdellis87 commented
Issue summary: View changes
rdellis87’s picture

rdellis87 commented
Issue summary: View changes
rdellis87’s picture

rdellis87 commented

Subsequent database updates receive the following error:

entityreference module

Update #7100
Failed: PDOException: SQLSTATE[42S01]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]There is already an object named 'taxonomy_index_tmp_nid_df' in the database.: CREATE TABLE [taxonomy_index_tmp] ( [nid] int NOT NULL CONSTRAINT taxonomy_index_tmp_nid_df DEFAULT 0 CHECK ([nid] >= 0), [tid] int NOT NULL CONSTRAINT taxonomy_index_tmp_tid_df DEFAULT 0 CHECK ([tid] >= 0), [sticky] smallint CONSTRAINT taxonomy_index_tmp_sticky_df DEFAULT 0, [created] int NOT NULL CONSTRAINT taxonomy_index_tmp_created_df DEFAULT 0 ); Array ( ) in db_create_table() (line 2776 of \includes\database\database.inc).

rdellis87’s picture

rdellis87 commented
Status: Needs work » Fixed

Status: Fixed » Closed (fixed)

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