updating cache error ?

[Rienk1980]

Hallo

after i imported 1 million hands i got this error



after i restarted pokertracker i got this error



when i want to play poker and get a HUD, there are no HUD/stats displayed at my opponents

i already deleted postsqrl and pokertracker and reinstalled/reimported hands to the newest pokertracker/postsqrl twice, still the same errors and bullshit
this never happend and its really annoying because i havent been able to play for 1 month because of this. ive been playing whit Pokertracker for over 2 years now.

Rienk

[kraada]

Please try doing a ReIndex in Database > Housekeeping.

If ReIndex in housekeeping doesn't help, you can try setting PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data.

[Rienk1980]

if postsqrl ignores the errors, will it solve the problem that im getting no HUD from other players because all the imported hands arent showing at the tablestats

[kraada]

PostgreSQL will ignore the errors and let you build the cache. Once your cache is up to date, the HUD should function properly.

[Rienk1980]

ok, i placed zero_damaged_pages = on at the bottem of the page, and now i should do the housekeeping/updating cache again ?

[WhiteRider]

Yes - save the file and restart postgres first, though.

[Rienk1980]

and restart postgres first, though.

how ??

[kraada]

Click Start (if you're on WIndows XP click Run), type services.msc and hit enter. Scroll down in the list to find PostgreSQL. Click on it, then you can click stop and start from the links you see on the left.

[Rienk1980]

when i scroll down i see postsqrl version 8.3 and 8.4, is that a problem

when i go to software i can only find 1 version

[kraada]

You can see which version PT3 is using in the Database Management window in small text at the top right.