An error has occurred - Incorrect integer value: `wdbt8_eshop_products`.`product

Hi,
recently I updated Eshop to latest version (3.5.7) as well as to latest version of Joomla and now when I open any product and just click save, without changing anything, I get the following error:
 

Why am I seeing this error and how to fix it?
Kind regards

Hi there,

The problem maybe caused by a wrong thing when you update EShop. I have already helped you to resolved it via ticket system.

Sincerely, Giang

Hi Giang and thanks for helping but I have the same problem on another website.
This website already has latest eshop (and it is working fine) and joomla 3.10.
Yesterday I updated joomla to version 4 and it messed up eshop, it shows the same error as in my first post.
I reinstalled eshop hoping it will fix the problem but it didn't help.
Is joomla 4 somehow breaking eshop and can you tell me how to fix it?
Kind regards

Hello,

For some reasons, the data type of product_cart_mode field of #__eshop_products table is incorrect. You need to go to the database to change the data type of that field from tinyint(1) to varchar(20), then the problem will be resolved.

Sincerely, Giang

I did it! Thank you Giang
Kind regards

OK no problem at all!