[nascartr]

Originally Posted by Ted S

The attached script will resync your vote tables using the individual stored votes. Simply upload it to your admincp folder and manually run the script.

This can be run multiple times if you ever have issues with your votes.

I got this database error when running the php file

Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT COUNT(postid) as totalrank,SUM(goodrank) as goodrank,postid
FROM helpfulanswer
GROUP BY postid;
MySQL Error : Unknown column 'goodrank' in 'field list'
Error Number : 1054
Request Date : Friday, March 20th 2009 @ 02:24:38 AM
Error Date : Friday, March 20th 2009 @ 02:24:38 AM
Script : http://diecastcrazy.com/community/admincp/ha_revote.php
Referrer :
IP Address : 98.26.219.187
Username : racersimage
Classname : vB_Database
MySQL Version : 5.0.77-community