My recipe/formula area of our roster has many duplicate entries.

I was told this is due to a wrong version of Character Profiler being used, however the main question is, how I can delete all this info and restart?


Example:
http://www.wowhq.com/roster/addon.php?r ... filterbox=

Delete all chars that was upload with a character prophiler less than 1.5.4a

at DB table roster_players CPVersion < 1.5.4a and later clean db with the script from downloads http://wowroster.net/Downloads/details/id=28.html

Thanks for the quick reply, I will do this.

I looked at this more today and I have no idea on how to delete people who are lower than 1.5.4a.

I did look via PHPMyAdmin but while I can find tables and such, I don't know how to simple get rid of everything <1.5.4a.

I did run the cleanup script above as well, but it didn't really do anything that solved the problem.

Can anybody provide some more help?
Thanks.

I am having the same issues with my "Made By" area. I ran the clean.php as suggested and it seemed to clear up a few but did not clean up the majority. Why would an individuals version of CharacterProfiler matter?

My site is rather new with only four people loading information for their mains and alts at this time and I already have duplicates. Any help would be greatly appreciated.

Go to phpmyadmin > select roster DB > select SQL and put these text.

SELECT * FROM `roster_players` WHERE `CPversion` NOT LIKE '1.5.4a'

Then you can select all and delete manually

You can do it automatically but i prefer look what i delete.

Thanks Subxero, you fixed up my issues.

Honestly, I appreciate the help. Many would not...