Hi folks.
If one day you have got broken Hall of fame (i.e. missed rows, "you are not finished any games" label over your results etc) then reasons are missed player's and player civilization's names and it is easy to fix
1) download SQLite shell for your OS from here http://www.sqlite.org/download.html
2) extract sqlite3.exe (from here and forward there will be Windows OS instructions) to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
3) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
4) Copy HallOfFameDatabase.db to save place (to allow to restore if something went wrong)
5) execute sqlite3.exe HallOfFameDatabase.db
6) execute update Victories set PlayerLeaderName='YOUR_NAME_HERE';
7) execute (copy/paste/execute all text in bold below as single query)
update Victories
set PlayerCivilizationName = substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),1,1)
|| lower(substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),2))
where PlayerCivilizationName='' or PlayerCivilizationName is null;
8) execute .exit
9) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
Also, if you have surplus entries in Hall of fame which you want to delete (e.g. you tried last turns multiple times and game remembered all attempts or you just want to remove some shameful records ) then do following
1) 1-5 steps from instruction above
2) execute .schema
3) you will see list of columns in table Victories. Now you should decide which ones allow to identify surplus rows, for example VictoryType, Score, PlayerTeamWon
4) execute select VictoryType, Score, PlayerTeamWon, rowid from Victories;
5) Notice rowid - it is hidden unique ID column. Find rows you want delete and remember its IDs (last number in row)
6) Execute delete from Victories where rowid in (List_of_IDs_to_remove);
for example delete from Victories where rowid in (1,2,3)
7) execute .exit
8) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
PS
There is my post about merging vanilla and G&L Hall of Fames http://forums.civfanatics.com/showthread.php?p=12014390
If one day you have got broken Hall of fame (i.e. missed rows, "you are not finished any games" label over your results etc) then reasons are missed player's and player civilization's names and it is easy to fix
1) download SQLite shell for your OS from here http://www.sqlite.org/download.html
2) extract sqlite3.exe (from here and forward there will be Windows OS instructions) to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
3) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
4) Copy HallOfFameDatabase.db to save place (to allow to restore if something went wrong)
5) execute sqlite3.exe HallOfFameDatabase.db
6) execute update Victories set PlayerLeaderName='YOUR_NAME_HERE';
7) execute (copy/paste/execute all text in bold below as single query)
update Victories
set PlayerCivilizationName = substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),1,1)
|| lower(substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),2))
where PlayerCivilizationName='' or PlayerCivilizationName is null;
8) execute .exit
9) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
Also, if you have surplus entries in Hall of fame which you want to delete (e.g. you tried last turns multiple times and game remembered all attempts or you just want to remove some shameful records ) then do following
1) 1-5 steps from instruction above
2) execute .schema
3) you will see list of columns in table Victories. Now you should decide which ones allow to identify surplus rows, for example VictoryType, Score, PlayerTeamWon
4) execute select VictoryType, Score, PlayerTeamWon, rowid from Victories;
5) Notice rowid - it is hidden unique ID column. Find rows you want delete and remember its IDs (last number in row)
6) Execute delete from Victories where rowid in (List_of_IDs_to_remove);
for example delete from Victories where rowid in (1,2,3)
7) execute .exit
8) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
PS
There is my post about merging vanilla and G&L Hall of Fames http://forums.civfanatics.com/showthread.php?p=12014390