vmError: vmTable store updateObject error in your SQL when change Category Name

[extonjaez]

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

[GJC Web Design]

VirtueMart 3.8.9 10592 is the current latest test issue!!

VirtueMart 3.8.9 10560 is from November

[Studio 42]

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

[Milbo]

Patrick, the new core has an update tool, which updates all virtuemart tables to UTF8mb4

[Milbo]

and of course you should update to the last version https://dev.virtuemart.net/projects/virtuemart/files