Jump to content

Incorrect prices displaying after upgrade


Recommended Posts

This is a known problem. It occurs because the upgrade process did not go through the CC6 beta series.


But I understood that CC601 fixed that problem.


One of the changes to the database is to CubeCart_currencies where the column symbol_decimal is changed to a VARCHAR(10) and now holds a default period, and a new column added named symbol_thousand, a VARCHAR(10), and holds a default comma. (The columns symbol_left and symbol_right are changed to TINYBLOB.)


But the CC6 upgrade somehow missed changing the database, the symbol_decimal column still has zero, which is taken literally, and not as a "logic switch" (to use for a CC5 hard-coded decimal or comma).

Link to comment
Share on other sites

If trying this manually, using phpMyAdmin for example, you need to first change the database table CubeCart_currency column type for 'symbol_decimal' from TINYINT(1) to VARCHAR(10). Then add the 'symbol_thousand' column as VARCHAR(10) as well.

Link to comment
Share on other sites

I'm on 6.0.0




Your store has already been upgraded. No further action is required.

Have now upgraded to 6.0.1, and the prices seem to be displaying properly now - thanks.


Except on the popular products sidebar. No prices at all.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...