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.
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
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
Quote from: Milbo on October 22, 2024, 16:34:28 PMUse 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
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....
Quote from: bobdxb on October 22, 2024, 16:41:12 PMDeprecated: 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
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
tks, solved