scythe000 Posted May 1, 2017 Share Posted May 1, 2017 Hi, all! I can't seem to get my Latest Products to display anything, even though I have products with that flag on. Any ideas? Linux host, php 5.5 or 5.6 i think. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 1, 2017 Share Posted May 1, 2017 There are some skin changes in 6.1.7. What skin are you using? Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 1, 2017 Author Share Posted May 1, 2017 Hi, Dirty Butter! I'm using Kuroutu, but i noticed it was doing this on 6.1.4 as well, which i just upgraded from. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 1, 2017 Share Posted May 1, 2017 OK - the old v5 skins really require considerable editing for them to work on 6.1.7. There are huge differences in Foundation in the upgrade from 6.1.5. As I understand it, they are no longer supported by CC. Not sure why it didn't work on 6.1.4, but maybe it's time to bite the bullet and change to Foundation. Otherwise you may need to downgrade to 6.1.4 and try to get it fixed there. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 1, 2017 Author Share Posted May 1, 2017 Got it. ok, i'll play around with the new skins. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 1, 2017 Share Posted May 1, 2017 This looks like a good way to make cosmetic changes easily: https://www.cubecart.com/extensions/skins/custom-foundation-5-skin Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2017 Share Posted May 2, 2017 (edited) On 5/1/2017 at 5:02 PM, Dirty Butter said: OK - the old v5 skins really require considerable editing for them to work on 6.1.7. There are huge differences in Foundation in the upgrade from 6.1.5. As I understand it, they are no longer supported by CC. Not sure why it didn't work on 6.1.4, but maybe it's time to bite the bullet and change to Foundation. Otherwise you may need to downgrade to 6.1.4 and try to get it fixed there. I was wrong about v5 skins. @Al Brookbanks says they should still work with 6.1.7. It was old ShopDev skins that were expected to no longer work. Sorry about that! So we're back to square one - except your issue has been around since 6.1.4. Please provide your store url. DO please be sure that your Kurouto skin has the csrf line in your config.xml. THIS WAS BAD ADVICE - DO NOT ADD THE CSRF LINE TO V5 SKINS!! <creator>CubeCart Limited</creator> <homepage>http://www.cubecart.com</homepage> <mobile>false</mobile> <responsive>true</responsive> DO NOT ADD THIS TO V5 SKINS<csrf>true</csrf> </info> <layout> That's from Foundation, so I'm not sure what it looks like in the Kurouto skin config.xml. But you need to add <csrf>true</csrf>. Edited May 3, 2017 by Dirty Butter WRONG DIRECTIONS!! Quote Link to comment Share on other sites More sharing options...
keat Posted May 2, 2017 Share Posted May 2, 2017 I'm using Kurouto on a 6.1.7 site and have latest products displaying OK. Maybe your skin is missing something, or a wonky file edit. I don't think the Kurouto skin is updated during an update process, so any wonly edits will remain. Try to ftp your Kurouto skin off the server (so you have a copy), and then temporarily upload a clean version. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2017 Share Posted May 2, 2017 (edited) @keat - did you have to add the csrf tag to Kurouto config? I HAVE SINCE FOUND OUT YOU DO NOT ADD THE CSRF TAG TO V5 SKIN CONFIGS. Only the skin named foundation is changed on upgrade. I use a renamed copy of Foundation to preserve all my edits. Of course that means I have to add back into my version any edits in the upgraded Foundation when they do occur. Edited May 3, 2017 by Dirty Butter Quote Link to comment Share on other sites More sharing options...
keat Posted May 2, 2017 Share Posted May 2, 2017 I've done a small number of skin edits for a Semperfi mod, but other than that nothing. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 2, 2017 Author Share Posted May 2, 2017 I just renamed kuroutu to kuroutu.old, and uploaded a fresh version. Same issue. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2017 Share Posted May 2, 2017 If you haven't already, please create the error_log. Then post what shows up when you load the homepage. Be sure to hide your admin_XXX naming if it shows up in the notices and warnings. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 2, 2017 Author Share Posted May 2, 2017 I also tried switching to foundation, same issue. Error log attached error_log Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2017 Share Posted May 2, 2017 Can you rename your cubecart.class.php file and replace it with the stock one? Assuming that doesn't fix it, rename the whole class folder and replace it with the stock 6.1.7 one. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 2, 2017 Author Share Posted May 2, 2017 Tried both. no luck :-( I have another site on this same host, same version that seems to work fine. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 3, 2017 Share Posted May 3, 2017 Do you have access to any file compare software? I use BeyondCompare, but that's one of many. Not sure if there's a free trial anymore or not. Since you have two sites on the same host - maybe you would be able to spot the difference. If not, please give both url's. Maybe there's a difference in the Source Code that I could spot. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 WTH, just noticed cathhost category links aren't working. Can't see why. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 3, 2017 Share Posted May 3, 2017 I'm off the computer for the night. But I will work on this in the morning. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 Get some rest, bud. Thanks :-) Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 In admin, Store Settings, Features tab, verify that for "Number of 'Latest Products' to display' there is a numeric value (using only digits) greater than zero. The error in the log suggests that the database query is returning something true-like, but it is not an array, and cannot be used as an argument for the foreach() statement. The first place to test is the number of records to return from config. You can also enable CubeCart's debug mode and provide your IP address in the adjacent field (www.whatismyip.com). Then, when viewing the Latest Products, the debug section will show any queries that the database engine had a problem with. Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 (edited) The number of products is set to 5. I tried changing it to 3, nothing. Here's the SQL debug section attached. sql.txt [14] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [cubecart.class.php] Line: [97] \"SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND I.status = \'1\' AND I.latest = \'1\' ORDER BY I.date_added DESC, I.product_id DESC LIMIT 5\" - Unknown column \'I.date_added\' in \'order clause\'','1493782587'); -- (0.0002901554107666 sec) [ERROR - NOT CACHED] [15] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [cubecart.class.php] Line: [97] \"SELECT I.* FROM `CubeCart_inventory` AS I JOIN `CubeCart_category` AS C ON C.cat_id=I.cat_id AND C.`status`=1 AND I.status = \'1\' AND I.latest = \'1\' ORDER BY I.date_added DESC, I.product_id DESC LIMIT 5\" - Unknown column \'I.date_added\' in \'order clause\'','1493782587'); -- (0.0002901554107666 sec) [ERROR - CACHE WRITE] [16] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('[Warning] /public_html/tingyen/classes/cubecart.class.php:99 - Invalid argument supplied for foreach()','1493782587'); -- (0.00023818016052246 sec) [ERROR - NOT CACHED] [17] DELETE FROM `CubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; -- (0.00030612945556641 sec) [ERROR - NOT CACHED] Looks like these are the specific errors? Edited May 3, 2017 by scythe000 Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 Unknown column 'date_added'. It seems the upgrade process failed to modify the CubeCart_inventory table when the step to have added the 'date_added' column would have happened. The 'date_added' column was added to make a distinction between when an item was added vs 'last_modified' (which, in previous versions of CubeCart, 'last_modified' put an item in Latest Products when it certainly wasn't a latest product). Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 Aha! How do I fix it? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 3, 2017 Share Posted May 3, 2017 Using an external utility, view CubeCart_history table Note if any version has been skipped. The 'date_added' column is present in CC611 (which is as far back as my current situation allows to explore). Quote Link to comment Share on other sites More sharing options...
scythe000 Posted May 3, 2017 Author Share Posted May 3, 2017 Doesn't look like it: Edit Edit Copy Copy Delete Delete 26 5.2.2 1441214831 Edit Edit Copy Copy Delete Delete 27 5.2.3 1441214837 Edit Edit Copy Copy Delete Delete 28 5.2.4 1441214842 Edit Edit Copy Copy Delete Delete 29 5.2.5 1441214848 Edit Edit Copy Copy Delete Delete 30 5.2.6 1441214853 Edit Edit Copy Copy Delete Delete 31 5.2.9 1441214859 Edit Edit Copy Copy Delete Delete 32 5.2.13 1441214864 Edit Edit Copy Copy Delete Delete 33 5.2.14 1441214869 Edit Edit Copy Copy Delete Delete 34 5.2.16 1441214875 Edit Edit Copy Copy Delete Delete 35 6.0.0 1441234286 Edit Edit Copy Copy Delete Delete 36 6.0.2 1441234292 Edit Edit Copy Copy Delete Delete 37 6.0.3 1441234298 Edit Edit Copy Copy Delete Delete 38 6.0.5 1441234303 Edit Edit Copy Copy Delete Delete 39 6.0.6 1441234309 Edit Edit Copy Copy Delete Delete 40 6.0.7 1441644432 Edit Edit Copy Copy Delete Delete 41 6.0.8 1446006604 Edit Edit Copy Copy Delete Delete 42 6.0.9 1458257460 Edit Edit Copy Copy Delete Delete 43 6.0.11 1458257466 Edit Edit Copy Copy Delete Delete 44 6.0.12 1483741951 Edit Edit Copy Copy Delete Delete 45 6.1.0 1483741956 Edit Edit Copy Copy Delete Delete 46 6.1.2 1483741962 Edit Edit Copy Copy Delete Delete 47 6.1.3 1483742064 Edit Edit Copy Copy Delete Delete 48 6.1.4 1485196609 Edit Edit Copy Copy Delete Delete 49 6.1.5 1493675179 Edit Edit Copy Copy Delete Delete 50 6.1.6 1493675184 Edit Edit Copy Copy Delete Delete 51 6.1.7 1493675190 Looks like it went from 6.1.0 to 6.1.2? 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.