Our current site https://www.rutlandcountygardenfurniture.co.uk/ is about 6 years old and built on an end of life Centos 6 OS and an old (5.6) version of PHP. This server is no longer PCI compliant (we take card details on the site) and we urgently need to transfer to a new server to address this.
The new server has Centos 7.9 and a Maria DB and what we are finding is there must be some coding issues that need resolving to make a migration work especially with regards to customer accounts and orders as, for example a new order doesn't generate a new order as it should and also, there's an issue when logging into existing account and finalizing the order - it doesn't acknowledge that you're already logged in and says there's an existing account already.
What we require is somebody go over the code (mostly the database functionality), as it is possible that there are functions which are compatible with MySQL but not MariaDB.