Page 1 of 2
updating cache error ?
Posted:
Tue Feb 15, 2011 3:27 pm
by 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
Re: updating cache error ?
Posted:
Tue Feb 15, 2011 3:56 pm
by 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.
Re: updating cache error ?
Posted:
Sun Feb 20, 2011 8:52 am
by 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
Re: updating cache error ?
Posted:
Sun Feb 20, 2011 10:32 am
by kraada
PostgreSQL will ignore the errors and let you build the cache. Once your cache is up to date, the HUD should function properly.
Re: updating cache error ?
Posted:
Sun Feb 20, 2011 4:16 pm
by Rienk1980
ok, i placed zero_damaged_pages = on at the bottem of the page, and now i should do the housekeeping/updating cache again ?
Re: updating cache error ?
Posted:
Mon Feb 21, 2011 4:34 am
by WhiteRider
Yes - save the file and restart postgres first, though.
Re: updating cache error ?
Posted:
Mon Feb 21, 2011 11:23 am
by Rienk1980
WhiteRider wrote:and restart postgres first, though.
how ??
Re: updating cache error ?
Posted:
Mon Feb 21, 2011 11:27 am
by 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.
Re: updating cache error ?
Posted:
Mon Feb 21, 2011 5:19 pm
by 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
Re: updating cache error ?
Posted:
Mon Feb 21, 2011 6:49 pm
by kraada
You can see which version PT3 is using in the Database Management window in small text at the top right.