PDA

View Full Version : The database is corrupted I believe



swiiftx
12-04-2009, 01:26 PM
Hello

Yesterday when I started Holdemmanager I saw something very strange, all my hands where gone and they were replaced by 250 completely nonsense hands(had around 30k hands before). So I checked my history and all the textfiles seem to be there as before, now I'm wondering, should I reinstall Hmanager or do something else? I have tried to create a new database and import the handhistory files but it doesn't change anything. Are the textfiles corrupted or something?

fozzy71
12-04-2009, 05:49 PM
Which Operating System, Firewall, and Anti-Virus are you using? What sites do you play?

Please update to the latest version - http://www.holdemmanager.net/hmupdate


*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, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754


Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the compatibility tab. Windows 7 you MUST set all the executables to always run as admin.

swiiftx
12-04-2009, 07:22 PM
Windows 7, using the inbuilt firewall and Avast Antivirus. It worked just fined before and then something happened, dunno what.
Anyway, I tried creating a new database and just ignore the old hand history, but now the new hands that I play won't import correctly, I'll try to reinstall it with revo and see what happens.

fozzy71
12-04-2009, 09:42 PM
Sticky: How do I reinstall PostgreSQL for a new Database? (http://forums.holdemmanager.com/showthread.php?t=20755)

This will require you to import all your \hmarchive hands. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.