PDA

View Full Version : Fresh OS install - HM not seeing my restored data



johnnycakes
10-10-2009, 12:56 PM
Hi,

I backed up my database.
I did a clean install of Windows 7.
I installed PostgreSQL.
I installed HM (latest beta) and activated it.
I restored my PostgreSQL database from the backup.
HM is running as Administrator.
HM sees the database in the database management screen.
I set the database as the default and launched HM.
HM doesn't seem to be able to see any of the data.
I can't select any player, because there are no players to select from.

I ran the hands count query in pgAdmin that I saw fozzy post in another thread, and it came back with about 1.2 million hands, which sounds right to me for this database.

Any ideas?

Thanks.

netsrak
10-10-2009, 02:03 PM
Did you click on the Change button in the reports or on the arrow besides?

johnnycakes
10-10-2009, 08:35 PM
yes, there are no names to select from. If I type in one letter (any letter) it says "0 players"

johnnycakes
10-10-2009, 08:36 PM
Also, I've got UAC at it's lowest Windows 7 level.

johnnycakes
10-10-2009, 09:23 PM
OK, I just played some hands. The HM imported them and displayed them in the reports. I was then able to select my name from the Player name menu/popup.
So, then I went over to pgAdmin and ran this:

select * from handhistories order by handhistory desc limit 100;

It displayed the hands I played AND the hands I played yesterday (before backing up the database). So, it is importing to the right database.
But when I tell HM to display the report for "This Month," I still only see those hands I just played. All the other hands still do not show up.

Why can't it retrieve the other hands?

fozzy71
10-10-2009, 09:48 PM
A problem with the backup/restore process would be my guess. When you created a new empty DB to restore to, was it UTF or ASCII?

Make sure you have beta 36

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

johnnycakes
10-10-2009, 11:11 PM
Looks like that was it.
I created a UTF db, restored, and it seems to be working fine.

Thanks!