Print Page - Error on Front End

Title: Error on Front End
Post by: ukfish1 on May 28, 2024, 11:03:08 AM

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

Title: Re: Error on Front End
Post by: ukfish1 on May 28, 2024, 11:20:48 AM

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

paul

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: ukfish1 on May 28, 2024, 11:03:08 AM