PT2 to PT3 database, error on import

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

PT2 to PT3 database, error on import

Postby johnnyonedrink » Thu Jul 24, 2008 6:06 pm

old database is SQL, did manual import, found old database and hit import and:

Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: value "2089872920" is out of range for type smallint CONTEXT: COPY holdem_hand_summary, line 1, column id_limit: "2089872920" )


n/b, i downloaded the PT2 database in the trial version of PT3 i had previously a few months back. Since, i have uninstalled and reinstalled PT3. So, many are coming up as duplicates in the import, yet i still cant see them when i run a query. I.e. 'FTP since x July' - shows only new hands ive imported, none from my PT2 database.
johnnyonedrink
 
Posts: 3
Joined: Thu Jul 24, 2008 2:08 pm

Re: PT2 to PT3 database, error on import

Postby WhiteRider » Fri Jul 25, 2008 3:25 am

What version of PT3 are you using? Build 2 or Beta 15?

Those old hands you imported would have been played before July X, wouldn't they? So they wouldn't show up in that filter..
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PT2 to PT3 database, error on import

Postby johnnyonedrink » Fri Jul 25, 2008 3:34 am

fixed
johnnyonedrink
 
Posts: 3
Joined: Thu Jul 24, 2008 2:08 pm

Re: PT2 to PT3 database, error on import

Postby WhiteRider » Fri Jul 25, 2008 3:44 am

How? What did you do?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 22 guests

cron
highfalutin