Page 1 of 1

Cant get into my DB

PostPosted: Thu Jul 31, 2008 12:33 pm
by copoka
My cash DB can't be open.
Here is what I'm getting even after I reinstall PT3 completely


Image

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 1:54 pm
by WhiteRider
Try removing the filter you have set - click 'Clear'.
Does that help?

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 2:10 pm
by copoka
It did.

But it comes back when I try to use day filter.

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 2:19 pm
by WhiteRider
Have you tried any other dates?
Try a range of dates instead of a single date too.

Ah, just noticed in the pic you are running build 2.
Try Beta 15, see if that helps.
Download and install PT3.
Please read the Beta 15 release notes first.

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 3:03 pm
by copoka
I got myself Beta 15

Some date ranges do not get anything (blank data fields)
Some (between dates, but not all dates) would not populate players list (red error instead) with the rest info looking to be normal.

ooops, no ranges are working anymore

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 3:45 pm
by copoka
It does not import hands either

Here is an error

PokerStars: Unable to import hand (#19247984407). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 2711 of relation "holdem_hand_player_statistics" CONTEXT: COPY holdem_hand_player_statistics, line 1: "45911 1336 1336 0 1 3216 2008/07/31 17:18:46 9 t t 1 t 1 t f f t f 0 f 1 f f f t f 0 f 0 f f t t f 0..." )

Re: Cant get into my DB

PostPosted: Thu Jul 31, 2008 5:39 pm
by WhiteRider
Sounds like you have a database error.
Please look that error up in the Database / Postgres FAQ

Re: Cant get into my DB

PostPosted: Sat Aug 02, 2008 3:10 pm
by copoka
Thanks a lot for your help.

Everything works fine now.

highfalutin