Hi guys,

Iīm stuck here...

after upgrade to 1.5.6a (from 1.5.4) I have noticed a problem which I cannot solve.

When trying to update a product or add one, I recieve this message:

WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

after looking to my logs, it seems that there is some problem with products_price in database and incorrect decimal value:

[21-Dec-2019 21:11:05 UTC] Request URI: /admin/product.php?cPath=62&pID=1198&action=update_product, IP address: xxx
#1 trigger_error() called at [/home/xxx/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/xxxx/public_html/admin/includes/functions/database.php:51]
#5 zen_db_perform() called at [/home/xxxx/public_html/admin/includes/modules/update_product.php:83]
#6 require(/home/xxxx/public_html/admin/includes/modules/update_product.php) called at [/home/xxxx/public_html/admin/product.php:34]
--> PHP Fatal error: 1366:Incorrect decimal value: '53,9167' for column 'products_price' at row 1 :: update products set products_quantity = '12', products_type = '1', products_model = 'code', products_price = '53,9167', products_date_available = null, products_weight = '0', products_status = '1', products_virtual = '0', products_tax_class_id = '1', manufacturers_id = '0', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '1', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '53,9167', products_image = 'image.jpg', products_last_modified = now(), master_categories_id = '62' where products_id = 1198 ==> (as called by) /home/xxxx/public_html/admin/includes/functions/database.php on line 51 <== in /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php on line 171.

my other eshops based on 1.5.4 are fully functional on the same server,

I use PHP 7.2.25 and MySQL 5.6.45

Any idea, please, what went wrong here? I recieve this message on both e-shops I have upgraded to 1.5.6a (actually, one of them is already on 1.5.6c - I didnīt realized this problem before another upgrade)