Error encountered while trying to retrieve graph definition.

Any support related posts should go here.

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Wed Sep 29, 2010 5:13 pm

I uninstalled psqlODBC (had v 08.04.0200) at the same time since that seemed reasonable. Now i'm left wondering tho, should i install psqlODBC 8.2 or 8.4 (psqlodbc-08_02_0500.zip or psqlodbc_08_04_0200.zip)?

They are here: http://www.postgresql.org/ftp/odbc/versions/msi/

Respectively, they are dated, 2007-09-25 09:25:01, and 2009-12-26 15:44:31.
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby WhiteRider » Thu Sep 30, 2010 3:33 am

As I understand it you need to use 8.2 for PT2.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Fri Oct 01, 2010 7:34 pm

Thanks for the help so far!

OK, after arduously dealing with reinstall bugs, i've got everything set up and my DB thankfully back in business.

All bugs are gone (graphing works, etc), except this same one still remains:

*********************************
PT Version: 2.17.04m
Error Date: 10/01/2010 15:35
Database Error: 7
Error Text: SQLSTATE = 22001
ERROR: value too long for type character varying(5);
Error while executing the query

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 123, 12785, 12785, {ts '2010-09-25 19:06:08'}, 17, 'XXVIII', 0, '4h', '4d', '8d', 'Ah', '6d', 84618.0000, 35734, {ts '2010-10-01 15:34:45'}, '305278298 620', 'two pair, aces and fours', 35734, 2, 8, 0, '50170141395' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 123, 12785, 12785, {ts '2010-09-25 19:06:08'}, 17, 'XXVIII', 0, '4h', '4d', '8d', 'Ah', '6d', 84618.0000, 35734, {ts '2010-10-01 15:34:45'}, '305278298 620', 'two pair, aces and fours', 35734, 2, 8, 0, '50170141395' )
*********************************
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby kraada » Sat Oct 02, 2010 8:45 am

Manually editing the hand history for a shorter level code (e.g. XXVII), should enable PTH to import these hands.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PTH Support

Who is online

Users browsing this forum: No registered users and 4 guests

cron