Help! My DB is all messed up

[BGnight]

I recently installed a new anitvirus software and it must have been keeping HEM from reading my Postgres DB. My user account controls got reset to ON during this too. (I'm on Vista)

What I've done: I've disabled User Account Contol and rebooted. I've also unistalled my anitvirus software and disabled my firewall and I've uninstalled HEM, rebooted and reinstalled it.
So now my HEM has my HH's, BUT all the numbers are screwed up. I now have quadruple duplicates of every HH somehow and so all my stats are X'sed by 4. It shows that I've made 4x's as much as I have, etc....

I'm retarded when it comes to postgres, but i figure the problem lies in that.

[fabio]

I would suggest creating a new database and reimporting all hands

[BGnight]

I did this, but a bunch of HH's are missing. Not sure where to find them. i have teamviewer and skype. Would love to set up a session if that's possible.

[morny]

HM probably put them in the proceessed files folder, if you attach your holdemmanager.config file from C:\Program Files\RVG Software\Holdem Manager\Config folder and ill be able to see where HM sends them

[BGnight]

Is this what you were looking for?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<setting name="ConnectionString">SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=postgr espass</setting>
<setting name="CurrentDatabase">HoldemManager2</setting>
<setting name="CurrentReportFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentSessionFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentHandsFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentGraphsFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentVsPlayerFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentPreflopFilter">IsTourney,IsTourney,EqualTo,false,True
PokerGameType,PokerGameType,In,0~1~2,True
</setting>
<setting name="CurrentPlayerID">22738</setting>
<setting name="DateRangeReport">After,Sep 17, 2008 10:53:39</setting>
<setting name="DateRangeHands">AllHands</setting>
<setting name="DateRangeGraphs">ThisYear</setting>
<setting name="DateRangePreflop">AllHands</setting>
<setting name="DateRangeSession">AllHands</setting>
<setting name="DateRangevsPlayer">AllHands</setting>
<setting name="LastReport">Winnings Breakdown</setting>
<setting name="AutoImportFolderList">C:\Program Files\PokerStars\HandHistory,True,True,C:\HMArchiv e
C:\Program Files\Full Tilt Poker\HandHistory\BGnight,True,True,C:\processed_h ands
</setting>
<setting name="LastArchiveFolder">C:\processed_hands</setting>
<setting name="LastImportFolder">C:\Program Files\PokerStars\HandHistory\BGnight\</setting>
<setting name="LastImportFileFolder"></setting>
<setting name="MinimizeToSystemTray">False</setting>
<setting name="PlayerNumberFilter">2:2,10
3:2,10
4:2,10
5:2,10
6:2,10
7:2,10
8:2,10
9:2,10
10:2,10</setting>
<setting name="InsertStandardizedHandHistory">False</setting>
<setting name="ObservedHandHistorySettings">ALL,3,False,True,6,False,True,3,600,False,True,6,6 00,False,True</setting>
<setting name="AutoApplyFilterChangesToAllTabs">False</setting>
<setting name="AutoImportHelpShown">False</setting>
<setting name="AutoImportTimerDuration">5</setting>
<setting name="HUDDateFilter">365</setting>
<setting name="SessionTimeoutDuration">30</setting>
<setting name="HUDIncludeOtherLimits">True</setting>
<setting name="LaunchHUDWithAutoImport">True</setting>
<setting name="DisableHUDStatsWhenNoHero">False</setting>
<setting name="HeroPlayerIDs"></setting>
<setting name="GraphShowdownWinnings">False,Blue,1,Solid</setting>
<setting name="GraphWinnings">True,DarkGreen,2,Solid</setting>
<setting name="UseGraphicalCards">True</setting>
<setting name="GraphAllInEv">True,DarkGreen,1,Dash</setting>
<setting name="GraphNonShowdownWinnings">False,Red,1,Solid</setting>
<setting name="GraphRakeback">False,DarkBlue,1,Solid</setting>
<setting name="AutoRefreshCurrentTabDuration">0</setting>
<setting name="AutoCloseTableManager">True</setting>
<setting name="AutoRefreshReportsOnChange">True</setting>
<setting name="LogDatabaseCommands">False</setting>
<setting name="SolidGraph">False</setting>
<setting name="ShowWinningRowColors">True</setting>
<setting name="CheckForUpdates">True</setting>
<setting name="PlayerSummaryView">Cash,NL|PL|LIM,ALL,2,10,01/01/2000,01/01/2020,1000,0,100,False,Default Stats</setting>
<setting name="HoldemManagerPosition">Normal,0,0,1242,738</setting>
<setting name="HandsSectionFields">HandTimeStamp,StakesBlinds,HoleCards,PreflopPlayer Action,FlopCards,FlopPlayerAction,TurnCard,TurnPla yerAction,RiverCard,RiverPlayerAction,NetAmountWon ,NetBBsWon,EVDifference,PositionType,PreflopAction Faced,PreflopVPIPPFR,AllInStreet,EVEquity</setting>
<setting name="ReplayerSettings">3,True,True,True,True</setting>
<setting name="ReplayerSkinToUse">Default Skin</setting>
<setting name="MyDayStartsAt">0:00:00</setting>
<setting name="DailyCompiledStats">True</setting>
<setting name="PromptsShown"></setting>
</configuration>

[BGnight]

It seems to be missing hands from september on.
Almost all Pokerstars

wondering what this means: "After,Sep 17, 2008 10:53:39"

[morny]

Pokerstars changed thier HH format in sept so you need to use this version http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe then move the HH to a new folder (important otherwise HM will ignore them since it already seen there was errors previous to this) and reimport and it should pick them up