Fix Illegal mix of collations Joomla + Virtuemart
Budget: $10 – $30 USD
Hello i need to fix this issue:
Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8mb3_unicode_ci,EXPLICIT) for operation 'ifnull'
It message appear each time when i try to see any product on the store.
Joomla version: 3.9.20
VirtueMart 3.8.4
Php version: 7.4.32
Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8mb3_unicode_ci,EXPLICIT) for operation 'ifnull'
It message appear each time when i try to see any product on the store.
Joomla version: 3.9.20
VirtueMart 3.8.4
Php version: 7.4.32