Missing hands

[darkrem]

Hi, currently playing a session and it seems HEM is missing couple hands so far.

On the table manager Icon i see the correct number of hands and amount won but im missing about 50 hands in my graph and session tab

I have no filters on except today.

[darkrem]

I reimported all my hands with from the archive and the hands still doesnt appear. All duplicate.
I checked files and I do see hands in the hand history files that doesnt show up in HEM

Playing on stars with HEM 1.12.09

[Patvs]

clear filters (even though it appears no filters are selected)
and change the date filter from TODAY--> THIS MONTH

If that doesn't resolve it, reimport them into a NEW empty database: Options--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager

[darkrem]

I did reimport in a new database and i see the correct amount won and see all hands that were missing from my other database.

Does my database have a problem?

[Patvs]

Yes there likely is a corruption in the old database.
You can reindex the database in pgadminIII, but ideally just reimport everything into the new database.

[darkrem]

Was waiting on tablescanner to make the switch to HEM2, gonna do it now i guess