I've installed the new beta. I can view all helpful votes in the admin panel but none of them are marked in threads now. All new ratings are marked but old ones are not yet they show up in the admin panel.

So basically you're not seeing the old votes in threads now but you can see them in the admin log?

Yeah, when I do a search for rating history I can view everything through the admin side but nothing shows up in the posts now. Also the Helpful Posts Search link doesn't show anything anymore either.

Also the labels are not in order on the search page and do not really line up with the results.

http://diecastcrazy.com/community/helpfulanswers.php

Forum Title and Average Rating should be flip flopped.

Sounds like none of your votes got imported. When you did the upgrade did you see any lines about it updating posts?

I'll post an import script in a sec to get you fixed.

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

Sorry about that... Having an off night and referanced the wrong field.

Use this instead.

I also posted 1.6.1 beta which fixes the column issue you identified.

This will make translate is easy.