Strange Behavior

ciordia9 - February 20, 2007 - 21:42
Project:Weekly Archive by Node Type
Version:5.x-1.2
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

Archive Screen
http://slowfoodcharlotte.org/node/3

It produced 3 date ranges, and out of those ranges only 1 is valid. I'll be glad to feed you back any further details but I'm not sure what you'd need.

#1

tic2000 - April 15, 2007 - 19:54

I have the same problem. Even if the description says that the block show only weeks with post in it I get weeks that have no nodes.

#2

tic2000 - April 15, 2007 - 20:30

I found out why this happens.
It's an inconsistency in columns used in select queries. On line 26, when creating the week lists the "changed" column is used (storest the unix timestamps of the last change to a node) while the rest of the code uses the "created" column (which stores the time the node was first created).
Now depending on what is the result you want you change the "changed" in line 26 to "created" or you can change every instance of "created" to "changed".

#3

deville - February 11, 2008 - 19:32

tic2000 is correct (thank you), that fixes the error

 
 

Drupal is a registered trademark of Dries Buytaert.