I installed the module, went to the administration page and created a new block.
When I tried to save it, I received this message:

Error message
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'related-0' for key 'PRIMARY': INSERT INTO {relevant_content_blocks_types} (id, type) 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); Array ( [:db_insert_placeholder_0] => related [:db_insert_placeholder_1] => article [:db_insert_placeholder_2] => related [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => related [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => related [:db_insert_placeholder_7] => 0 ) in relevant_content_save_block() (line 963 of /var/www/news/sites/all/modules/relevant_content/relevant_content.module).

The block was saved, but not the content types and the vocabularies I chose.
When I edited it and tried to re-save it, I received the same message.

Comments

knalstaaf’s picture

Priority: Normal » Major

Confirmation. In my case no blocks have been saved at all (applied on D7.9).

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'gerelat_toepassingen-0' for key 1: INSERT INTO {relevant_content_blocks_types} (id, type) 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), (:db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15); Array ( [:db_insert_placeholder_0] => gerelat_toepassingen [:db_insert_placeholder_1] => productcat [:db_insert_placeholder_2] => gerelat_toepassingen [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => gerelat_toepassingen [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => gerelat_toepassingen [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => gerelat_toepassingen [:db_insert_placeholder_9] => 0 [:db_insert_placeholder_10] => gerelat_toepassingen [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => gerelat_toepassingen [:db_insert_placeholder_13] => 0 [:db_insert_placeholder_14] => gerelat_toepassingen [:db_insert_placeholder_15] => 0 ) in relevant_content_save_block() (line 963 of /var/www/vhosts/domain.be/subdomains/preview/httpdocs/sites/all/modules/relevant_content/relevant_content.module).

knalstaaf’s picture

The Featured Content module helped me out for Drupal 7.

pacome’s picture

Same issue for me :

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '123-0' for key 'PRIMARY': INSERT INTO {relevant_content_blocks_types} (id, type) 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] => 123 [:db_insert_placeholder_1] => post [:db_insert_placeholder_2] => 123 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 123 [:db_insert_placeholder_5] => 0 ) in relevant_content_save_block() (line 963 of /**********relevant_content.module).

patty.fresonke’s picture

The block was saved, but not the content types and the vocabularies I chose.
When I edited it and tried to re-save it, I received the same message.

Same problem for me...anyone figure out any fixes??

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'related_content-0' for key 1: INSERT INTO {relevant_content_blocks_types} (id, type) 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), (:db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15); Array ( [:db_insert_placeholder_0] => related_content [:db_insert_placeholder_1] => article [:db_insert_placeholder_2] => related_content [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => related_content [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => related_content [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => related_content [:db_insert_placeholder_9] => 0 [:db_insert_placeholder_10] => related_content [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => related_content [:db_insert_placeholder_13] => 0 [:db_insert_placeholder_14] => related_content [:db_insert_placeholder_15] => 0 ) in relevant_content_save_block() (line 963 of /**********/relevant_content.module).

EDIT: Ran across this patch and it allowed me to save properly. Now to get it formatted! :)

nicholasthompson’s picture

Issue summary: View changes
Status: Active » Closed (duplicate)

As Patty pointed out, this is a duplicate of #1229032 and the referenced patch is committed now.