Error on Front End

[ukfish1]

VM: 3.4.0
Joomla: 3.10.12

Hi

Ref: https://west5web-builder.co.uk/store/auto-b-detail

This has has been copied over to a new server but the product pages in Virteumert are not displaying correctly on the front end  such as at the above URL.

Error is:

1267  Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8mb3_unicode_ci,EXPLICIT) for operation 'ifnull'

The page should look like:

https://www.flightlinedecoys.co.uk/store/auto-b-detail

Thanks, Paul

[ukfish1]

Managed to sort this by downloading Akeeb Admin tools and using the Change Database Collation function

paul