Problem with table 'xxx_phocacart_order_products'

[ScaleBXL]

Hi Jan,

I have a problem, here's the error message and I can't update de database:

Table 'xxxx_phocacart_order_products' has the wrong type or attributes for column 'default_price' with type DECIMAL(15,. (From file 6.1.0.sql.)

I can't change ordering the products,
and all the tabs in the products administration are broken (all the tabs are displaying in "General Options tab")
and I can't delete or create product attributs (only one solution : duplicate one product with attribute and modify them)

and all that problems since the Joomla update to 6.1.0

Any idea?

[Nidzo]

Same topic
https://phoca.cz/forum/viewtopic.php?t=67066

[ScaleBXL]

This hasn't resolved anything

[Nidzo]

Be patient.

[Jan]

Hi, when you run this:
ALTER TABLE `#__phocacart_order_products` MODIFY `default_price` DECIMAL(15, 4) NOT NULL DEFAULT '0';
(changing #__ to your own prefix), and the column as 15,4, you still get the error message?

Can you post a screenshot which error message it is?

Jan