Not showing Product Details in VM 4.2.6

[bobdxb]

Hi,
I am using VM 4.2.6, SP Page Builder 5.2.9, J4.4.9 and PHP 8.2.24

VM Shop was installed without errors initially. Only issue is when clicked on Product to view details, error warning page opens with error code 1267.
https://store.milmartrading.com/shop/

Thanks for help and guidelines how to resolve it.

[Milbo]

Enable the joomla debug, then we can see the dumptrace and the real error. Or,..

The error 1267 is
Illegal mix of collations error in MySql

Use in the Tools of vm the function to convert all tables to the new utf8mb4

[bobdxb]

Deprecated: Creation of dynamic property VmImage::$setRealImageSize is deprecated in /home/customer/www/store.milmartrading.com/public_html/administrator/components/com_virtuemart/helpers/mediahandler.php on line 104

[bobdxb]

Use in the Tools of vm the function to convert all tables to the new utf8mb4

I dont see TOOLS in VM, do I need to load from Virtuemart? Tks

[bobdxb]

changed all tables to utf8mb4_unicode_ci and still have warning

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

I have used following steps
1. Access phpMyAdmin:
- Go to your Site Tools > MySQL > phpMyAdmin.

2. Select the Database:
- Choose the database you want to manage from the drop-down menu on the left.

3. Change Collation:
- Click on the "Operations" tab in the top menu.
- At the bottom of the page, you will see the collation option. Select `utf8mb4_unicode_ci` from the drop-down menu and click on "Go".

Problem solved....

[Milbo]

Deprecated: Creation of dynamic property VmImage::$setRealImageSize is deprecated in /home/customer/www/store.milmartrading.com/public_html/administrator/components/com_virtuemart/helpers/mediahandler.php on line 104

Thank you that is fixed already.

The tools are part of vm and below the config. And the sets more than just the collation. it toook me a while to understand how todo it properly

[bobdxb]

Hi Jumbo,
Kindly explain steps to add regions and zipcode to country, I need to setup for Philippines. Currently I only see Philippines in my VM 4.18.
Tks

[bobdxb]

tks, solved