PT2 to PT3 database, error on import
Posted: Thu Jul 24, 2008 6:06 pmold 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.
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.
