How do I override imported ranks?

[Jonathon123]

When I upgraded from vBulletin to Invision Community a series of old ranks came with user profiles. It means I have two series of ranks running, when I just want the existing ranks in Invision to remain. I spoke to support who said there's no official way of removing old ranks from people's profiles, but there could be a way running a query on the database. Can anyone assist? Forum here: http://unofficialmills.co.uk/forums/index.php?/topic/13582-radio-1s-big-weekend-2019-middlesbrough/&page=3&tab=comments#comment-465658

[bfarber]

A user's rank is determined at runtime, so all you have to do is delete the old ranks you don't wish to use in the AdminCP and the user's rank will be determined against the ranks that you leave in place. We don't cache the user's rank.

Having said that, if this is the member title (like under your name it says "New Member") then this may have been cached and based upon the user's old rank. To reset this you would need to run a database query.

1. Make a backup of your database. If anything goes wrong you would need this to fix the problem.
2. Run this query in phpmyadmin, or ask your host to run it for you if necessary:

   UPDATE core_members SET member_title=NULL

Be aware that this will reset any one's custom member title that they legitimately set.