Update 7003 - Cannot define PRIMARY KEY constraint on nullable column in table metatag - with MS SQL Server [#2011310]

Running the database update scripts I get the following error. The site is running on mssql 2008 R2, unfortunately.

Update #7003
Failed: PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'metatag'.: ALTER TABLE [{metatag}] ADD CONSTRAINT {metatag}_pkey_technical PRIMARY KEY CLUSTERED (__pk); Array ( ) in db_drop_primary_key() (line 2901 of C:\Users\Administrator\Documents\GitHub\chowtaifook\includes\database\database.inc).

Comments

Comment #1

greggles

he/him

English

Denver, Colorado, USA

CreditAttribution: greggles commented 19 June 2013 at 20:27

Title:

Error on Update #7003

» Update 7003 - Cannot define PRIMARY KEY constraint on nullable column in table metatag - with MS SQL Server

Updating title to better match the issue.

Comment #2

Uncle_Code_Monkey CreditAttribution: Uncle_Code_Monkey commented 12 December 2013 at 21:16

Issue summary:	View changes
Related issues:		+#2136849: Cannot define PRIMARY KEY constraint on nullable column

Comment #3

Uncle_Code_Monkey CreditAttribution: Uncle_Code_Monkey commented 12 December 2013 at 21:21

The SqlSrv Drupal driver does not create the __pk field correctly and a patch is currently required to correct the issue. Unfortunately, the patch must be in place before "update.php" is run, so rolling back your database is the best solution (you did perform a backup before running update.php, right?). If you do not have the option of restoring from a backup, you can read through the comments of how to manually correct your database after applying the patch.