Jump to content

[Resolved] 6.1.7 no latest products


scythe000

Recommended Posts

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.

 

Link to comment
Share on other sites

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 by Dirty Butter
WRONG DIRECTIONS!!
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

@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 by Dirty Butter
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by scythe000
Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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?

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.

Guest
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...