SQLite exception "primary key must be unique" when sequences table erroneously contains more than one row

Created on 2 February 2012, over 13 years ago
Updated 6 March 2024, about 1 year ago

I'm updated Drupal 7.10 to 7.12 with SQLite database, and error message:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 PRIMARY KEY must be unique: UPDATE {sequences} SET value = GREATEST(value, :existing_id) + 1; Array ( [:existing_id] => 0 ) in db_next_id()

Update is not success.

๐Ÿ› Bug report
Status

Closed: outdated

Version

11.0 ๐Ÿ”ฅ

Component
Database updateย  โ†’

Last updated about 1 month ago

No maintainer
Created by

๐Ÿ‡ญ๐Ÿ‡บHungary nevergone Nyรญregyhรกza, Hungary, Europe

Live updates comments and jobs are added and updated live.
  • Needs reroll

    The patch will have to be re-rolled with new suggestions/changes described in the comments in the issue.

  • Needs issue summary update

    Issue summaries save everyone time if they are kept up-to-date. See Update issue summary task instructions.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024