Updating products is throwing error in Power Store

A new error is being thrown when updating cart products.

Update ps4_products set ProductStartDate = '18-12-02', ProductEndDate = '19-06-01', ProductUpdateDate = '2019-03-19 13:29:49' WHERE ProductID in ( select Distinct ProductID from ps4_productoptions where ps4_productoptions.OptionID in ('') AND ProductID in (select ProductID from ps4_productoptions where OptionID = 464)) OR ProductID = 483
Truncated incorrect DOUBLE value: ''

I have two small testers and it is not doing it to those two but other products are getting this message.

I think this may be related to updating from mysql to MariaDB which happened about the same time they are reporting errors.

I'll need FTP access and a url and steps to reproduce. I can't be sure of the cause without more active debugging.

OK

The first private message contained the cart admin. The second is the ftp log in.
Let me know if you want access to the database. A repair maybe?

What product should I update to get the error? I just need steps to reproduce... do I need to change anything or just go to the page and click update for a particular product?

They are all throwing it, except for two that are called test for $1.00.
Just select a product and click update. Don't even need to change anything.

I logged into cpanel and checked the database and it reported back OK. I didn't try the repair button.

Checking on it and some are not throwing error now, but I'll post in PM one that I found that still is.

Let me know if I can do anything to help.I did observe that if you make an edit in descriptions, that even though the error gets thrown, the edit sticks. I tested this on the 210 product.

What coalition is defined in phpMyAdmin for the ps4_products table and the ProductName column?

utf8_general_ci

in non-cart db for pages, it is latin1_swedish_ci