Hi Drupal community,
I am not sure is the error happened when migrating to 8.6 or after, but in any case it is still happening with Drupal core 8.6.7 and 8.6.8.
The website encountered an unexpected error. Please try again later.</br></br><em class="placeholder">Drupal\Core\Entity\EntityStorageException</em>: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '383-0-0-en' for key 'PRIMARY': INSERT INTO {comment__comment_body} (entity_id, revision_id, bundle, delta, langcode, comment_body_value, comment_body_format) 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); ArrayThis is happening with all fields comment, both the default ones in forums, and the ones added has field.
In my test version, I have been able to delete the comments (but one where I had to delete the corresponding node for which this comment was a field, and for which I got the same error ), delete all the forum topics, but still no way to add a comment.
Do anyone has a similar problem or does it come from my database? I do my drush updatedb and drush cr…
I have tried to remove the fields and add them again for exemple. I ve seen some post were the SQL command itself was involved, but I do not feel safe to try to modify Drupal core itself... But could it be that entity_id and revision_id should not BOTH be here?
Any advice where to look at a solution? Anyone facing the same problem? ANyone NOT facing this problem with Drupal 8.6.7? I have been looking at some posts, but not exactly similar.
Many thanks in advance,
Best,
Perrine
