Home › Support › Popular Widget › "Most Viewed" is NOT working. › Reply To: "Most Viewed" is NOT working.
June 6, 2012 at 10:26 am
#47682
sang
Participant
Hax —
I think the problem with Most Viewed posts not display is caused by a bad SQL query in the included.php file:
In the query around line #182 it says: “AND post_date >= ‘$time'”. If you echo $time to the screen, you’ll see that $time is being returned as the current time on the server, thus there are no search results that match the query. The result set will always be 0.
I believe you need to calculate the a different $time variable based on the “In the last days X days” setting from the widget and update the SQL query.
I hope this helps. I love the widget otherwise and hope that you can keep it going.
Cheers,
Sang