blog mysql error
Permalink
Hello,
Whenever I try to Save or Publish a blog entry I receive the following error:
An unexpected error occurred.
mysql error: [1062: Duplicate entry '136-1-13-196' for key 'PRIMARY'] in EXECUTE("UPDATE CollectionAttributeValues SET avID=196 WHERE cID=136 and cvID=1 and akID=13")
This is shown using the Composer tool within Concrete5.
This is a new issue that just started this morning. It was working fine yesterday and I've made no setup changes.
Thank you for your assistance.
Stefan Vapaa
Whenever I try to Save or Publish a blog entry I receive the following error:
An unexpected error occurred.
mysql error: [1062: Duplicate entry '136-1-13-196' for key 'PRIMARY'] in EXECUTE("UPDATE CollectionAttributeValues SET avID=196 WHERE cID=136 and cvID=1 and akID=13")
This is shown using the Composer tool within Concrete5.
This is a new issue that just started this morning. It was working fine yesterday and I've made no setup changes.
Thank you for your assistance.
Stefan Vapaa
If so, write down the akID from the error message and check database table 'AttributeKeys'. In a default installation akID=13 shows 'height'. Height is a FILE attribute, not a COLLECTION attribute. That's a bit weird.
But first uncheck all attributes in composer and try to add a blog post.