error import

Hold'em or Poker Tracker Hold'em related posts go here

error import

Postby Holliwood » Thu Jan 21, 2010 5:20 am

Hello,

since today i get an error by importing party hands. Here the log:

PT Version: 2.17.04g
Error Date: 01/21/2010 10:15
Database Error: 7
Error Text: SQLSTATE = XX001
ERROR: invalid page header in block 290 of relation "player_winnings_idx_02";
Error while executing the query

No changes made to database.

INSERT INTO player_winnings ( date_played, game_level_id, site_id, player_id, session_id, opponent_id, won_from, times_beat, real_player_id, real_opp_id ) VALUES ( {ts '2010-01-21 00:00:00'}, 2, 3, 91130, 1002367, 95156, 2.0000, 1, 91130, 95156 )
DataObject: d_gr_player_winnings_new
Syntax In Error: INSERT INTO player_winnings ( date_played, game_level_id, site_id, player_id, session_id, opponent_id, won_from, times_beat, real_player_id, real_opp_id ) VALUES ( {ts '2010-01-21 00:00:00'}, 2, 3, 91130, 1002367, 95156, 2.0000, 1, 91130, 95156 )

I tried to vacuum/analyze the databse, but it doesnt work too.

I hope you can help :)
Holliwood
 
Posts: 1
Joined: Thu Jan 21, 2010 4:44 am

Re: error import

Postby ptrack pat » Thu Jan 21, 2010 7:49 am

You can try reindexing as detailed here
http://www.pokertracker3.com/forums/arc ... ex+pgadmin

You can just reindex the PLAYER_WINNINGS table as that is the one causing the error.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PokerTracker Holdem

Who is online

Users browsing this forum: No registered users and 12 guests

cron
highfalutin