DOException: SQLSTATE[42000]: Syntax error or access violation

Update 7001 was added ages ago, what version were you using before the update?

As for the problem, can you try changing the db_drop_primary_key line to the following, see if it works?

  try {
    db_drop_primary_key($table_name);
  }
  catch (Exception $e) {
    drupal_set_message(t('Caught an exception: !msg', array('!msg' => $e->getMessage())));
    drupal_set_message(t('The update should have worked anyway.');
  }

Ack, sorry, try this:

  try {
    db_drop_primary_key($table_name);
  }
  catch (Exception $e) {
    drupal_set_message(t('Caught an exception: !msg', array('!msg' => $e->getMessage())));
    drupal_set_message(t('The update should have worked anyway.'));
  }

The full function would be:

function metatag_update_7001() {
  $table_name = 'metatag_config';
  $field_name = 'cid';
  $field_spec = array(
    'type' => 'serial',
    'unsigned' => TRUE,
    'not null' => TRUE,
    'description' => 'The primary identifier for a metatag configuration set.',
  );
  $keys = array('primary key' => array($field_name));

  // Before making any changes, drop the existing primary key.
  try {
    db_drop_primary_key($table_name);
  }
  catch (Exception $e) {
    drupal_set_message(t('Caught an exception: !msg', array('!msg' => $e->getMessage())));
    drupal_set_message(t('The update should have worked anyway.'));
  }

  // Rejig the field, and turn on the primary key again.
  db_change_field($table_name, $field_name, $field_name, $field_spec, $keys);
}

Sorry I wasn't clear - just replace metatag_update_7001 in metatag.install with the code from #5 :)

That error should only happen if the 'language' field doesn't exist in the main {metatag} table, which is added in metatag_update_7003.

Check the {metatag} table, see if it has a 'language' field.

Ok, I'm a little confused as to how this could happen. In comment #8 you said the rest of the updates went through ok, but the language field should have been added in update 7003.

BTW the code fix listed above was accidentally included in the beta7 that went out yesterday.

Confirm same error

The following updates returned messages
metatag module
Update #7001

Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined: ALTER TABLE {metatag_config} CHANGE `cid` `cid` INT unsigned NOT NULL auto_increment COMMENT 'The primary identifier for a metatag configuration set.', ADD PRIMARY KEY (`cid`); Array ( ) in db_change_field() (line 3017 of /includes/database/database.inc).

Website become unfunctional except administration pages.

I have the exact same problem after a d6 - d7 upgrade.
Tried the above patches: no solution
Tried the latest dev: same problem
At my wits end here. Can someone solve this please?

@Demontager and @LukM: could you both please let me know what version of Metatag you had installed before updating?

@phatmike10: We need to solve update 7001 first so that all of the other updates work too, then the language field will be added.

Can someone please test to if this resolves the problem? It adds a slightly hackish (database-specific) way to see if the primary key has been added already

This needs to be fixed.

Ran into the same problem as #16 while updating an old project from 7.x-1.0-alpha3 to 7.x-1.0-beta7 and solved it by removing following from the metatag_update_7001 function:

$keys = array('primary key' => array($field_name));

  // Before making any changes, drop the existing primary key.
  try {
    db_drop_primary_key($table_name);
  }
  catch (Exception $e) {
    drupal_set_message('Caught an exception: ', $e->getMessage());
  }

I suppose this a mySQL specific issue, where db_drop_primary_key() can't remove a primary key on auto_increment fields. For some reason it doesn't throw an exception.

@DamienMcKenna, the current version of Metatag is 7.x-1.0-alpha3

@Demontager: The last release of Metatags was 1.0-alpha3, the current release of Metatag is 1.0-beta7.

I did what was advised in #24 and I worked as a pure magic. Many thanks to vanderKraan

Lets see if this passes the testbot.

Fixed an unfinished comment.

That still doesn't work. Now I get a different error:

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

Since I don't have any metatags defined, I'm just going to completely uninstall and reinstall it, but it's pretty clear that first update was really badly hosed.

#24 was magic for me :) Thanks.

Does this work?

Need to take look at how Media handled a similar problem (https://drupal.org/node/2064305):

https://drupal.org/files/file_entity-fix_file_metadata_primary_key_schem...

Can anyone please let me know which file the 'metatag_update_7001' function is in so i can do #24 suggested fix?

thank you

*UPDATE* - metatag_update_7001 can be found in 'metatag.install'

Patch from #33 does not work, still getting error

SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined

Trying to update from 7.x-1.0-alpha3.

Here is a patch against latest dev (hint for the patch taken from #34).

As a note, I am just updating some old Drupal 7 site and situation here with metatag is that I wanna update from 7.x-1.0-alpha3 to 7.x-1.0-beta7. This patch applied to 7.x-1.0-beta7 solved upgade issue. I will test site after full upgrade little more and if I found some problems arround metatag will update here.
In the mean time here is c&p of upgrade process and metatag_config table before and after upgrade with this patch:

Before

mysql> explain metatag_config;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| cid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| instance | varchar(255)     | NO   | UNI |         |                |
| config   | longblob         | NO   |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+

After

$ drush updb
...
Performed update: metatag_update_7001                                                                                          [ok]
Performed update: metatag_update_7002                                                                                          [ok]
Performed update: metatag_update_7003                                                                                          [ok]
Performed update: metatag_update_7004                                                                                          [ok]
Performed update: metatag_update_7005                                                                                          [ok]
Performed update: metatag_update_7006                                                                                          [ok]
Performed update: metatag_update_7007                                                                                          [ok]
Performed update: metatag_update_7008                                                                                          [ok]
Performed update: metatag_update_7009                                                                                          [ok]
Performed update: metatag_update_7010                                                                                          [ok]
Performed update: metatag_update_7011                                                                                          [ok]
Performed update: metatag_update_7012                                                                                          [ok]
Performed update: metatag_update_7013                                                                                          [ok]
Performed update: metatag_update_7014                                                                                          [ok]
Removed 2 meta tag record(s) for the rules_config entity type, it does not support meta tags.                                  [status]
Purged 2773 empty meta tag record(s).                                                                                          [status]
No duplicate taxonomy_term records were found (this is a good thing).                                                          [status]
No duplicate user records were found (this is a good thing).                                                                   [status]
Fixed language values for 1 user records.                                                                                      [status]
No duplicate node records were found (this is a good thing).                                                                   [status]
Update 7011: 1 records to update.                                                                                              [status]
Update 7011: 1 records were updated.                                                                                           [status]
There were no other records to fix.                                                                                            [status]
Update 7013: No meta tag records need updating.                                                                                [status]
No corrupt records to fix, this is good news :-)                                                                               [status]
Finished performing updates.                                                                                                   [ok]

mysql> explain metatag_config;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| cid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| instance | varchar(255)     | NO   | UNI |         |                |
| config   | longblob         | NO   |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+

Everthing looks good I guess ;)

Closed a duplicate: #2163899: update error

I'm about to release beta8, if I can have some help testing this I'll be happy to commit it.

Tested on one of our old installs. The update seems to work fine with the patch.

Committed! Thanks for the help, everyone!

DamienMcKenna++