@lucianwpwhite ,
Thanks for getting back to me.
The site was cloned back in August last year. The 2FA was only installed on the clone in April. The clone is our dev for the site, try to break things there before we do in prod.
I set the deletion flag and removed the plugin from both the prod site and the clone site. Re-installed it and set it back on the prod site – does not set up 2FA and retuns the user to the top of their profile page.
Thanks for getting back to me @mohammedeisa.
The issue is due to the big difference in MySQL versions. It would appear that the only way to get around it is to turn off the ‘strict’option on the db. Not the best solution for a whole load of reasons, but that is what it is unfortunately.