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.