Cant import turney

Any support related posts should go here.

Cant import turney

Postby Ypsi » Tue Mar 04, 2008 1:17 pm

Hello,


if i go to "database mountenance and options" in menu, i received the message "select error SQLSTATE = 42883. Error: function ltrim(integer) does not exists: Error while executing query". I have a Postgres 8.3 database.
The tab turney is empty.
I get the same message if i click to "show turnaments with no summaries loaded" button
Ypsi
 
Posts: 67
Joined: Wed Feb 13, 2008 5:38 am

Re: Cant import turney

Postby ptrack pat » Tue Mar 04, 2008 2:36 pm

This might be an issue with 8.3 that PT doesn't support.
How long ago did you install 8.3? Where you using another version of PostgreSQL (8.0 or 8.2) before this??
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Cant import turney

Postby Ypsi » Tue Mar 04, 2008 3:23 pm

i retested now.
its dont working only with 8.3
Ypsi
 
Posts: 67
Joined: Wed Feb 13, 2008 5:38 am

Re: Cant import turney

Postby ptrack pat » Tue Mar 04, 2008 3:49 pm

I don't understand what you mean. You mean you testing with with PostgreSQL 8.2??
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Cant import turney

Postby Ypsi » Tue Mar 04, 2008 4:04 pm

yes, with 8.2 its working, with 8.3 not
Ypsi
 
Posts: 67
Joined: Wed Feb 13, 2008 5:38 am

Re: Cant import turney

Postby ptrack pat » Tue Mar 04, 2008 4:16 pm

Can you do a backup of your 8.3 database and let me know the size of the .backup file and I can tell you how to get it to me so I can look into this problem.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Cant import turney

Postby Ypsi » Tue Mar 04, 2008 6:15 pm

Its any empty postgres 8.3 database, if am going to "database mountenance and options" i get this message.
Ypsi
 
Posts: 67
Joined: Wed Feb 13, 2008 5:38 am

Re: Cant import turney

Postby ptrack pat » Tue Mar 04, 2008 6:20 pm

If you import some tournament hands, do you get this error anymore?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Cant import turney

Postby Ypsi » Tue Mar 04, 2008 7:00 pm

i can import my hands, with 8.2 and 8.3.
if i upgraded to postgres 8.3, i cant see any imported tourney under "show tournaments with no summaries loaded" (i havent summaries to my tournaments)
I get this error message again and pokertracker dont responsed anymore
Ypsi
 
Posts: 67
Joined: Wed Feb 13, 2008 5:38 am

Re: Cant import turney

Postby ptrack pat » Tue Mar 04, 2008 8:15 pm

Why can't you import hands into 8.2 or 8.3??? You need to give some specific details so I have something to go on here. Are you getting errors? If so, what are they?

[quotebqw]if i upgraded to postgres 8.3, i cant see any imported tourney under "show tournaments with no summaries loaded" (i havent summaries to my tournaments)[/quotebqw]

You just said this was an empty database so I don't understand why you would expect something to be on this window in an empty database.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Next

Return to PTH Support

Who is online

Users browsing this forum: No registered users and 0 guests