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

[ScaleBXL]

https://imgur.com/a/WqMqp5F


First one, the error message in database mainenance
Second, you will see in my product edition, the attribute are just below the editor, and same thing for all the other tabs
Third, Alter table MySQL returned an empty result

[Nidzo]

https://imgur.com/a/WqMqp5F


First one, the error message in database mainenance
Second, you will see in my product edition, the attribute are just below the editor, and same thing for all the other tabs
Third, Alter table MySQL returned an empty result

Solved - https://phoca.cz/forum/viewtopic.php?p=187179#p187179
Install 6.1.0Beta12 https://github.com/PhocaCz/PhocaCart/re ... Beta12.zip

[ScaleBXL]

Hi,

Thanks it resolve the database error, but I must always check in some phoca cart tables in Mantenance Global Check-in.

No effect in product edition, I can't create, delete attributes, and all the tabs are destructured
If I create a new product I have all the tabs, even those that shouldn't be displayed but I can't create, delete attributes

[Jan]

Hi, what do you mean with desctructured tabs?