Hi - I seem to have solved this issue. Well I lie - @joeyk seemed to have saved the issue for me by pointing me in the right direction to the required PR: Fix duplicate entry for key campaign_rotation by kuzmany · Pull Request #9639 · mautic/mautic · GitHub
Now I am not a technical person and was having a chat with @rcheesley and she was kind enough to take the time to explain how I go ahead and change the required files inside this PR.
So a HUGE shoutout and thank you to both @joeyk & @rcheesley. The Mautic community is an amazing place and I am privileged to be part of it and contribute where I can.
If anyone needs any direction or help please feel free to hit me up.