dcmgraphics Posted November 4, 2014 Share Posted November 4, 2014 not sure why, but when I try to add a min. quantity to a product, it doesn't save. If I enter a nubmer 8, then save and go back to it, it's not there. I've tried on several diferent products, trying to add a new generica product, still no luck. I am runing the latest CC 5.2.14. Is there something else I need to check? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2014 Share Posted November 4, 2014 The minimum quantity column was added to the CubeCart_inventory table in CC526. If you upgraded at one point that went through CC526, such as from CC522 to CC5210, it may be the case that only the codebase was upgraded. Please use a database utility such as phpMyAdmin to look at the the structure of the CubeCart_inventory table. Let us know if there is a column named 'minimum_quantity'. If there is not, then your database structure needs to be double-checked to be at a complete CC5214 schema. If there is, then we can look at how the code is behaving. Quote Link to comment Share on other sites More sharing options...
dcmgraphics Posted November 4, 2014 Author Share Posted November 4, 2014 I just checked the database, and no there is not a column for 'minimum_quantity'. So how do I fix that? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2014 Share Posted November 4, 2014 There could be the easy way, or the hard way. In the database table, CubeCart_history, please list all the versions. There will be one record for each version for which the setup program has modified the database. The easy way is to remove sufficient records so that the history shows that the latest version is prior to CC526. Then run setup and have the setup procedure update the database to CC5214. The hard way (and it's not all that bad) is to manually execute the SQL statements in the /setup/db/upgrade/ folder using phpMyAdmin. Quote Link to comment Share on other sites More sharing options...
dcmgraphics Posted November 4, 2014 Author Share Posted November 4, 2014 Thanks, I really appreciate your help on this. 1 5.2.5 2 5.2.7 3 5.2.9 4 5.2.10 5 5.2.11 6 5.2.12 7 5.2.13 8 5.2.14 That sound scary to go back to 5.2.5, that isn't going to mess up anything else in my store? So you are essentially telling me to delete all but the 5.2.5 in the table. Then run set up, where do I get the setup folder? I always delete it after running an update. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2014 Share Posted November 4, 2014 To me, it looks like 5.2.6 is the only entry missing (there was nothing to upgrade in 5.2.8). So, using phpMyAdmin, execute these queries: ALTER TABLE `CubeCart_inventory` ADD `minimum_quantity` INT( 10) NOT NULL DEFAULT '0' ; UPDATE `CubeCart_email_content` SET `content_html` = REPLACE(`content_html`, '<!--{', '{'); UPDATE `CubeCart_email_content` SET `content_html` = REPLACE(`content_html`, '}-->', '}'); If your database has a prefix on the table names, be sure to use it. (If you ever need to get a setup folder, download the ZIP package from CubeCart.com.) Quote Link to comment Share on other sites More sharing options...
dcmgraphics Posted November 4, 2014 Author Share Posted November 4, 2014 Wow, that worked THANK YOU! But I got this result: ALTER TABLE `CubeCart_inventory` ADD `minimum_quantity` INT( 10) NOT NULL DEFAULT '0' ;# 81 rows affected. UPDATE `CubeCart_email_content` SET `content_html` = REPLACE(`content_html`, '<!--{', '{');# MySQL returned an empty result set (i.e. zero rows). UPDATE `CubeCart_email_content` SET `content_html` = REPLACE(`content_html`, '}-->', '}');# MySQL returned an empty result set (i.e. zero rows). So not sure what the 'email content' was suppose to fix, but doesn't appear it found anything to fix? Is that something I need to worry about? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2014 Share Posted November 4, 2014 That is interesting, but nothing to worry about. To satisfy our curiosity, however, in admin, Email Templates, click the USA flag for Cart: Order Confirmed. On the HTML Content tab, switch the editor to Source mode. Scroll halfway down. Do you see this: <!--{foreach from=$PRODUCTS item=product}--> or this: {foreach from=$PRODUCTS item=product} Quote Link to comment Share on other sites More sharing options...
dcmgraphics Posted November 4, 2014 Author Share Posted November 4, 2014 Second one: {foreach from=$PRODUCTS item=product} Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 4, 2014 Share Posted November 4, 2014 Excellent. You are up to speed! Quote Link to comment Share on other sites More sharing options...
dcmgraphics Posted November 4, 2014 Author Share Posted November 4, 2014 Thank you so much for you help! Quote Link to comment Share on other sites More sharing options...
DrSchnitzel Posted April 21, 2015 Share Posted April 21, 2015 I'm having the same problem as the OP on a fresh install of 6.0.2Just to advance the conversation, I've noticed that there is no minimum_quantity column in the CubeCart_inventory table.Thanks in advance! Quote Link to comment Share on other sites More sharing options...
bsmither Posted April 21, 2015 Share Posted April 21, 2015 Yup. The db install file does not have 'minimum_quantity' in the CREATE statement. 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.