Hello,
I have created a new category (Product Category Form) who is published and shared in english (i use other languages like french or Chinese)
After i go to chinese "Product Category Form" and try to change (for this new category) the Category Name for chinese language (share is now unclicked) and i have this error
"Error
vmError: vmTable store updateObject You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1"
thanks for your help
System Information
VirtueMart 3.8.9 10560
PHP Built On Linux s22095112 3.10.0-1127.13.1.el7.x86_64 #1 SMP Tue Jun 23 15:46:38 UTC 2020 x86_64
Database Type mysql
Database Version 5.5.5-10.2.43-MariaDB
Database Collation utf8mb4_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.4.28
Web Server Apache
WebServer to PHP Interface fpm-fcgi
Joomla! Version Joomla! 3.10.6 Stable [ Daraja ] 12-February-2022 17:04 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:65.0) Gecko/20100101 Firefox/65.0 IceDragon/65.0.2
VirtueMart 3.8.9 10592 is the current latest test issue!!
VirtueMart 3.8.9 10560 is from November
THe problem is a general issue with table collation, some (chinese)characters and simleys are not recognized
You need to use utf8mb4
here a sample query
alter table #__mytable convert to character SET 'utf8' COLLATE 'utf8mb4_general_ci';
I think that you can modify all Joomla table collations using admin tools https://www.akeeba.com/products/admin-tools.html
Note that i'm not sure that it solve your problem.
PLEASE BACKUP ALL YOUR TABLES BEFORE CONVERT ALL TO mb4
Patrick, the new core has an update tool, which updates all virtuemart tables to UTF8mb4
and of course you should update to the last version https://dev.virtuemart.net/projects/virtuemart/files