Missing hands after import (Pokerstars).

**Boglord** · 01-07-2009, 09:44 PM

I also just reinstalled 1.07 and no hands are showing up even though it's successful in importing.

They show just fine on the HUD.

One other thing that's worth noting is that when I click on change player and choose my player it shows 123 hands while the sessions/reports tab show 79. I think those 123 are all the hands I had played so it has them in but just not showing?

No filters or anything are on, it's pure fresh install.

**Boglord** · 01-07-2009, 10:06 PM

Originally Posted by morny

Theres nothing in 1.06 that changed regarding importing, just create a new database and reimport those hands that wouldnt import, it will take about 2 minutes.

//EDIT those hands you sent imported fine so it looks like the database is corrupt so export all the hands from the old one http://www.holdemmanager.net/faq/afm...aspx?faqid=173 and create a new database and reimport them into the new one

I'll do it later tonight.

How long does it take to reimport 9 mil hands?

Also, they import fine and show fine when I look for player, like in the (), but not in sessions/reports. Doesn't that mean the DB is fine since there are no errors at import?

Anyway, I'll do the new DB later on.

**Al1** · 01-07-2009, 10:08 PM

Originally Posted by Boglord

I'll do it later tonight.

How long does it take to reimport 9 mil hands?

Also, they import fine and show fine when I look for player, like in the (), but not in sessions/reports. Doesn't that mean the DB is fine since there are no errors at import?

Anyway, I'll do the new DB later on.

Probably around 2 days depending on your computer.

**Boglord** · 01-07-2009, 10:31 PM

I still don't see how it can be the database when it works fine from the 1.06 vs pc and not the other, and also considering all the other facts.

But I'll give it a try.

**Boglord** · 01-08-2009, 12:17 AM

So, I've done a reinstall with the vs that I have on my main pc, which is 1.06.04 and it works fine. All the hands show up and import fine. It even shows the hands I played earlier (except the first couple of sessions, so just missing 20 hands).

I played over 50 hands with this version and all show up fine.

The one odd thing is that even though I installed the 1.06.04 vs (on top of an older version I had) it still shows 1.07. Although some of the 1.07 features aren't there.

**Boglord** · 01-08-2009, 04:10 PM

Originally Posted by Al1

Probably around 2 days depending on your computer.

How do I go about exporting hands from old DB into new one?

**Al1** · 01-08-2009, 07:30 PM

Originally Posted by Boglord

How do I go about exporting hands from old DB into new one?

http://www.holdemmanager.net/faq/afm...aspx?faqid=173

**Boglord** · 01-08-2009, 09:55 PM

Is there a way to make Postgres faster given that it's the only thing I run on that PC?

And apparently my DB screwed up now, it starts missing hands on my PC too :/

I guess I'll spend the next few days redoing it, but I'd like Postgres to be faster (atm it imports at a rate of 14-15 hands per sec).

**Boglord** · 01-08-2009, 10:39 PM

Originally Posted by Al1

http://www.holdemmanager.net/faq/afm...aspx?faqid=173

I'm doing the export right now but the window shows not responding (it did that as soon as I start the export). Is this normal or should I ctrl+alt+del and restart?

Also, can I do the import into the new DB while I'm doing the export from the other one?

**Boglord** · 01-08-2009, 11:36 PM

The export is done but it looks like it didn't get all the hands.

Somehow it only has 170 files and at import it says it will only take 38 minutes. Did I do something wrong? I followed the FAQ you linked. However the folder is 9 gigs and I also purged about 2 mil hands before exporting so I should have about 8 mil or so.