Hi there,
I have a custom type with a few fields and it all worked well until today... I reckoned it might be related to an update of AcyMailing I did, because actually that was the only change we've made recently. However, for other custom types it is still working without problems, so I'm somewhat stuck now...
The issue is, that when I'm saving after the creation of new content, I received the error "1062 Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `" ... and indeed the article ID of the original content article is not being transferred into the table with the extra data of the custom fields in this form. The article itself is however created in the content table.
I have save it again to ensure it's not a cache issue and tried everything I can, but always the SQL INSERT for the additional fields does not bring with it the ID of the original Joomla! article. Does anyone of you have an idea how to solve this issue!?!
Any help whatsoever would be much appreciated as this affects a live site...
Thanks,
Jo
Hi,
have you tried disabling AcyMailing? What is your seblod version (if it's not the latest please update)
Also check if order of system and content plugins is correct, seblod plugins need to come first.
For archiving purposes here the solution to the problem: The id column in the extra table needed AUTO INCREMENT ... didn't expect that as it's a foreign key only to be replicated ... but yeah, it solved the problem.