PDA

View Full Version : importing is fine.stats are gone



marius
06-13-2009, 04:40 PM
Hi

yesterday I got an error message that some handhistories can`t be imported and today when I started HM he was not importing anything

I try to use purge hands option and I got this mesage:

http://img268.imageshack.us/img268/8058/250crop.jpg

now somehow it seems that is importing just fine, and the table it apear on the tablemanager, but the stats does not apear anywhere on the table, i even try with table finder but still noething

have to mention that this is happening on all the poker sites I am playng


later:

now I see something that don`t know if this is right but anyway: http://img200.imageshack.us/img200/9044/2crop.jpg

morny
06-14-2009, 05:46 PM
Please see this FAQ http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

marius
06-15-2009, 08:39 AM
I even try fixing all the indexes with rebuild on the list, and still not showing the stats on the table:confused:on any sites, and on every holdem hand is importing I got a duplicate hand to.

interesting think is that if I observe an omaha table on Fulltilt HM is somehow importing the hand but i got no duplicate hands like on holdem tables

morny
06-15-2009, 03:40 PM
Ok looks like its not repairable, Please export your hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database and all should be fine then

marius
06-15-2009, 03:46 PM
it`s easy to say:( but I have a big database 6mil hands+ and I`m not sure if is going to work, and even so, it will take very long time. so if you have any more ideeas pls let me know soon.

morny
06-15-2009, 03:49 PM
There not really much else you can do other than repair the indexes, maybe try running a full vacuum but that will probab;y take a while too and its not that likely to work but worth a shot in comparisson to the time it will take to export and reimport.