HOF - Most Popular Content not updating

Scott, i appreciate you offering to help on this situation and sorry it has taken me so long to reply to your post. OK, so in the hof.module I changed line 441 to $result = db_queryd($sql);

that resulted in the following message on /hof page

query: select n.nid,n.title,c.totalcount from node n left join node_counter c on n.nid=c.nid where n.status=1 and n.created>=1125984459 and c.totalcount>1 and title not like '%page not found%' order by c.totalcount desc, n.created desc limit 5
error:

query: select n.nid,n.title,c.totalcount from node n left join node_counter c on n.nid=c.nid where n.status=1 and n.created>=1123910859 and c.totalcount>1 and title not like '%page not found%' order by c.totalcount desc, n.created desc limit 5
error:

query: select n.nid,n.title,c.totalcount from node n left join node_counter c on n.nid=c.nid where n.status=1 and n.created>=1095053259 and c.totalcount>1 and title not like '%page not found%' order by c.totalcount desc, n.created desc limit 5
error:

query: select n.nid,n.title,c.totalcount from node n left join node_counter c on n.nid=c.nid where n.status=1 and n.created>=0 and c.totalcount>1 and title not like '%page not found%' order by c.totalcount desc, n.created desc limit 5
error:

I hope I did what you asked correctly.

Thanks!

ok, so I really didnt get anywhere the HOF module and was hoping that the new module release would fix the issues that I have had. However, no such luck.

From phpmyadmin I have ran the following query.

SELECT n.nid, n.title, c.totalcount FROM node n left join node_counter c on n.nid=c.nid where n.status=1 and n.moderate=0 and n.created>=0 and c.totalcount>1 and title not like '%page not found%' order by c.totalcount desc, n.created desc limit 5

This is what returned:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)
SQL query:
SELECT n.nid, n.title, c.totalcount
FROM node n
LEFT JOIN node_counter c ON n.nid = c.nid
WHERE n.status =1
AND n.moderate =0
AND n.created >=0
AND c.totalcount >1
AND title NOT LIKE '%page not found%'
ORDER BY c.totalcount DESC , n.created DESC
LIMIT 5

Any help or suggestions would be greatly appreciated!

- Keto