Integrity constraint violation: Duplicate entry

Created on 19 November 2014, about 10 years ago
Updated 6 August 2024, 5 months ago

Hi, Sergey!

I here again with some bug (or not bug) report. There's an error on my site:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '-U9kzH0lwsBDtiYBRIDmK_0jgow3JwIkwJavJHZMiaI' for key 'PRIMARY': INSERT INTO {popup_announcement} (sid, visit_number, is_visible, is_visible_permanent, timestamp_first_visit, timestamp_last_visit) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => -U9kzH0lwsBDtiYBRIDmK_0jgow3JwIkwJavJHZMiaI [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1416422695 [:db_insert_placeholder_5] => 1416422695 ) в функции Popup_announcement_visitor->create_visitor_info() (строка 456 в файле /sites/all/modules/popup_announcement/popup_announcement.module).

And there's screenshot of the module settings page in attachment.

What may it be?

🐛 Bug report
Status

Active

Version

1.3

Component

Code

Created by

🇷🇺Russia kaztur

Live updates comments and jobs are added and updated live.
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.

  • 🇵🇹Portugal jrochate

    When rejecting cookies, or not saving cookies, the SESSIONID is non existent. The SQL tries to save a new line using null value on the Sid column, and if there is already another non-cookie saved, the primary key error occurs.

Production build 0.71.5 2024