logo

Extra Block Types (EBT) - New Layout Builder experience❗

Extra Block Types (EBT) - styled, customizable block types: Slideshows, Tabs, Cards, Accordions and many others. Built-in settings for background, DOM Box, javascript plugins. Experience the future of layout building today.

Demo EBT modules Download EBT modules

❗Extra Paragraph Types (EPT) - New Paragraphs experience

Extra Paragraph Types (EPT) - analogical paragraph based set of modules.

Demo EPT modules Download EPT modules

Scroll

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

22/02/2025, by Anonymous (not verified)
Forums

When installing the blog 

blog 2.0 

at the final stage  Setup 1 produced the following error

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

I found the following solutions 

Regarding the creation of a node with duplicate entries in the list of responsible users, we receive the following PDOException:

PDOException: SQLSTATE [23000]: Integrity constraint violation: 1062 duplicate entry '7970-3-responsible' for key 'PRIMARY': INSERT INTO {} node_access (NID, realm, GID, grant_view, grant_update, grant_delete) 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), (: db_insert_placeholder_6,: db_insert_placeholder_7,: db_insert_placeholder_8,: db_insert_placeholder_9,: db_insert_placeholder_10,: db_insert_placeholder_11); Array # 012 (# 012 [: db_insert_placeholder_0] => 7970 # 012 [: db_insert_placeholder_1] => responsible # 012 [: db_insert_placeholder_2] => 3 # 012 [: db_insert_placeholder_3] => 0 # 012 [: db_insert_placeholder_4] => 1 # 012 [: db_insert_placeholder_5] => 0 # 012 [: db_insert_placeholder_6] => 7970 # 012 [: db_insert_placeholder_7] => responsible # 012 [: db_insert_placeholder_8] => 3 # 012 [: db_insert_placeholder_9] => 0 # 012 [: db_insert_placeholder_10] => 1 # 012 [: db_insert_placeholder_11] => 0 # 012 )

Another option would be to resolve this automatically. 
We leave this to the maintainers of this module.

 

EntityReference-duplicate-entries.patch 954 bytes Idle ACCEPTED: [[SimpleTest]]: [MySQL] 114 passes. More details | Re-test

 

but in neither case can I understand how to apply this, please help!!