PDA

View Full Version : problem with database cannot import



Goldeneye
09-15-2011, 10:02 PM
hi,

after a couple of months of no problems since yday i can-t import in holdem manager any hands i got 900 hands to import and it says its 140000 errors and cannot import them, also during playing after sessions i noticed couple of biggest pots hands dont appear in holdem maanger, i tried manually to go in postgres aplicattion adn ran vacuum analyze on database than reindex until was done but its still the same.... :( btw i can-t runoptimization on the main database i use becouse i get an eror during optimization error: 57014: canceling statement due to user request, i tried optimization on another database i had but not used almost ever and the optimization works on that and also when i try import tthe same 900 hands i tried to immport in other database it work on this database.
what can i do now i dont wanna give up the whole database i have like millions of hands :(

Patvs
09-15-2011, 10:10 PM
Update to: http://www.holdemmanager.com/Downloads/HmUpdate_1.12.03.exe
Reimport your hands into a new database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager


AFTER you've imported all your hands: BACKUP your database: http://faq.holdemmanager.com/questions/72/Backup%26RestoreDatabase
So NEXT time, you can easily RESTORE the database, instead of having to reimport the hands.