[ECP-8904] Reinstallation flow not working

[wannevancamp]

Describe the bug
After reinstalling the plugin not all destructive migrations are processed correctly.
The migration src/Migration/Migration1681716164AlterAdyenPayment.php will try to alter the table twice. This will result in the following error. The plugin installation can't be completed.

This occurs since plugin version3.11.0.

[2023-10-12T06:30:13.498646+00:00] app.ERROR: Migration: "Adyen\Shopware\Migration\Migration1681716164AlterAdyenPayment" failed: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'UQ_ADYEN_PAYMENT_PSPREFERENCE'" [] []

Versions
Shopware version: 6.5.1.1
Plugin version: 3.14.1

To Reproduce
Steps to reproduce the behavior:

1. Install plugin
2. Deinstall plugin
3. Install plugin again
4. Error is thrown

Expected behavior
Reinstall plugin without errors

[hossam-adyen]

Hi @wannevancamp, thanks for your valuable contribution, we were able to reproduce it, we add it into our backlog and once it got picked and fix, we will update the issue

[alessandroaussems]

@hossam-adyen Almost 7 months later... Any update on this?

[damian-pastorini]

Still an issue on 4.1.0 and SW 6.6.