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
Comment #1
knalstaaf commentedConfirmation. 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).Comment #2
knalstaaf commentedThe Featured Content module helped me out for Drupal 7.
Comment #3
pacome commentedSame 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).
Comment #4
patty.fresonke commentedSame 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! :)
Comment #5
nicholasthompsonAs Patty pointed out, this is a duplicate of #1229032 and the referenced patch is committed now.