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

Created on 2 February 2012, about 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 11 days 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