Recently, we've been having a problem where multiple RANKSNAPs were marked as CURRENT, causing incorrect points and sitewide points to be displayed. Apparently, this was caused by MySQL 5.1's partitioning system. In some cases, a partitioned table won't update correctly. :(
I turned off partitioning, so it should work correctly now.