My hosting provider is upgrading from MySQL 5.6 to 8 soon and I believe my (live) Prestashop 1.6.22 is not compatible with this.
I am not sure but cannot find any info on the Prestashop web site so have to assume this is the case since it is not the latest 1.7 Prestashop fork.
Please quote me for 1) checking the compatibility of the shop and all modules and 2) telling me what needs to be changed to become compatible and 3) editing any necessary code in the shop or modules so it is compatible.
If you think necessary possibly upgrade to the last 1.6 at the same time (1.6.24)
My provider will upgrade my server in 7 days without further warnings. I have the option of copying the DB to another MySQL v5.6 server for 4 weeks to facilitate migration and testing.
Thank you for your quote - feel free to ask any questions.
Please note: REPLIES IRRELEVANT TO THIS PROJECT - advertising etc. - WILL BE REPORTED TO PPH