Alias 2.0.5 Errors out when trying to create & replace a plugin with an alias.

[jerrodq2]

For context, this is with djangocms-alias 2.0.5, django 4.2, djangocms 4.1.9 & python 3.11, we are updating our project so I expect this issue to be fixed when we update to alias 3+ and django/djangocms 5+. But, so the issue is documented, there seems to be a bug with alias 2.0.5, when I select a plugin and select Create Alias, there's an option to "Replace Current Plugin". If I don't select that box, eveything works fine, if I do, it errors out, giving an IntegrityError and this type of message: (1062, "Duplicate entry '18442-en-225' for key 'cms_cmsplugin_placeholder_id_language_position_bad60ebe_uniq"')

When this happens, I noticed that the alias is created, but it's blank, the plugins themselves are not effected. We are using djangocms-alias out of the box, no changes or customizations, so we believe this is a bug in version 2.0.5

[fsbraun]

AFAIK this has been fixed in djangocms-alias 3.0; to help debug for 2.0.x, can you add a traceback for the IntegrityError?

[jerrodq2]

Sorry, forgot to upload my pictures of it. Here they are

[fsbraun]

@jerrodq2 I have tried to fix this in #308 . Can you give it a practice test by installing from the PR's branch?

[jerrodq2]

I was able to install from the PR branch & test. The error no longer appears, it does replace the plugin & successfully create the alias in a Draft state. However, I think it's worth noting that until you reload the page, the plugin still shows up in the plugin tree & gives this error if you try to edit/delete it, since the page doesn't automatically reload. Not the worst behavior, a slight inconvenience that can be worked around, not sure if that behavior is corrected in alias 3+

[fsbraun]

@jerrodq2 OK, one step ahead.

Can you check for JS errors in the browser console?

[jerrodq2]

Sorry for the delay, been busy. Here is the relevant console JS error and the Terminal output when I try to edit it.

[fsbraun]

Is there any error at the point in time when you create the alias (and the structure board is not updated)?

[jerrodq2]

I double checked, this error popped up when I did the replace. There's no major break on the page so it's easy to miss, like I said the alias itself is created and the plugin is swapped out, the plugin tree just isn't updated until the page reloads.