OC v 2.3.0.2 with MySQL8 - any issues likely?

So, have been running website on OC v 2.3.0.2 for several years. My host has just informed me that they are about to change MySQL version from 5.7 to 8.00

Is this likely to cause any issues ? Anything need to be changed. Simple terms please, I am not an expert!

Thanks in advance, guys.
Robin

You need to update your Installation, to make it work with PHP v.8.x:
https://github.com/condor2/Opencart_230x_PHP_8

Thanks, IP_CAM ,
The question is about MySQL v8.00 - are you saying that OC 2.3.0.2 needs to be upgraded to PHP 8 as well, to run with MySQL 8?

Robin

IP_CAM wrote: ↑

Fri Sep 08, 2023 6:15 pm

You need to update your Installation, to make it work with PHP v.8.x:
https://github.com/condor2/Opencart_230x_PHP_8

Read again, more carefully this time, as this is about MySQL not PHP

RobinD wrote: ↑

Fri Sep 08, 2023 6:44 pm

The question is about MySQL v8.00 - are you saying that OC 2.3.0.2 needs to be upgraded to PHP 8 as well, to run with MySQL 8?

It should be fine unless any of your extensions use deprecated MySQL features, which is relatively unlikely. How dates are handled is a bit different in some queries etc. but the fixes are generally not too hard if that is a problem.

paulfeakins wrote: ↑

Fri Sep 08, 2023 6:46 pm

RobinD wrote: ↑

Fri Sep 08, 2023 6:44 pm

The question is about MySQL v8.00 - are you saying that OC 2.3.0.2 needs to be upgraded to PHP 8 as well, to run with MySQL 8?

It should be fine unless any of your extensions use deprecated MySQL features, which is relatively unlikely. How dates are handled is a bit different in some queries etc. but the fixes are generally not too hard if that is a problem.

Many thanks Paul,

Regards
Robin