Reply To: "Most Viewed" is NOT working.

HomeSupportPopular Widget"Most Viewed" is NOT working.Reply To: "Most Viewed" is NOT working.

#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