vidmarc Posted March 22, 2015 Share Posted March 22, 2015 Since upgrading, the prices are displaying incorrectly. The decimal points are displaying as zeroes. Any suggestions? http://www.nucleusfilms.com/ Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted March 22, 2015 Share Posted March 22, 2015 Goto Currencies and set the decimal point and thousands mark for your country and any others you intend to provide. Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 22, 2015 Share Posted March 22, 2015 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). Quote Link to comment Share on other sites More sharing options...
vidmarc Posted March 22, 2015 Author Share Posted March 22, 2015 Have tried doing this but confused. Decimal symbol is listed as "0". Is this correct? I've tried to change it to a decimal point, but the change will not stay in place. Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 22, 2015 Share Posted March 22, 2015 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. Quote Link to comment Share on other sites More sharing options...
vidmarc Posted March 22, 2015 Author Share Posted March 22, 2015 I'm not competent enough to mess around with MySQL. Is it easy to do? Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 22, 2015 Share Posted March 22, 2015 Let's try this: assuming you are upgrading to CC601, run the setup. www.mystore.com/setup/index.php Quote Link to comment Share on other sites More sharing options...
vidmarc Posted March 22, 2015 Author Share Posted March 22, 2015 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. Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 22, 2015 Share Posted March 22, 2015 The "Best Sellers", just below the "Featured Product", yes, this box is not coded to show prices. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.