Problems with removing Hero after import of hands from other player

[kossa_mu]

I imported hands from a player and he shows up as hero so that I dont have all the stats on him.

I know how to remove him from the hero list, but after a while he shows up again. Without me importing any new hands from that player.

I have been using this from another post and have done that a few times, but he still shows up.


"
Navigate to Start Menu > All Programs > PostgreSQL ## > pgAdmin III

Open the Database in PGAdmin (default password is: postgrespass) and

Open SQL window

Then select * from players where optimizationstatus != 0

This will show all the players marked as hero's.

1) Note the ID of the player that you want to un-make as a hero

2) Update players set optimizationstatus = 0 where player_id = {player_id of player}

So for example, "update players set optimizationstatus = 0 where player_id = 1232"

Once that is done launch HM2 and that player won't be a hero and other players moved against that player will not count towards vs hero stats. No need to reimport DB or anything after that."

[Patvs]

Check all your handhistory folders (auto import folders):
-are there any handhistory files stuck in one of the folders
-is there a folder added as an auto import folder, where you have saved a lot of old handhistories from this player

This player will only come back as a 'hero', if a handhistory file where he is the hero is accidentally imported again.