Top Downloads/Author Bug Fixed

Knock on wood.  I think I have finally solved the problem that causes the Top Downloads and Top Authors not to reset!  The problem that I was seeing is that the job to perform this task would frequently timeout and would not complete itself.  It would always timeout on the wallpaper library.  I always assume that were was a problem with the database specifically on the table for the wallpaper library.  I recreated that table several times.  I tried differenent indexes.  I rewrote my code in several ways to try an optimize it but the problem persisted.

Well, I finally discovered that I had an old script running that was generating an xml file for newest wallpapers.  This script had a bug in it that would cause it to throw an error.  But the job would wait for 4 minutes before it would kill itself off.  So for 4 minutes this job had an open connection to the wallpaper library and most likely a lock on some of the records. Because this job didn't finish to run it was causing the other jobs to randomly timeout and cause me many headaches.

So with that said, I have corrected the problem and hope that was the cause of the Top Downloads and Top Authors not resetting itself properly.

And I would like to give a big thank you to Geoff for keeping on my butt and constantly sending me emails letting me know when the lists didn't update properly!  Thanks Geoff!