by 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' )
*********************************