Database update

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Database update

Postby Barlin63 » Thu Nov 22, 2012 1:31 pm

Release notes for 4.05.6 says:

Special Notes
A database update will be required with this release, this mandatory update is required due to the changes made to select stats within the database. Please be aware that action may might take some time to complete, the length of time required is dependent on the size of your databases.

I installed the new program but did not see any notification about the Db Update nor any delay caused by a Db update. How can I check that the needed update indeed is performed?

BTW: I have all the updates installed when they were available.
Barlin63
 
Posts: 221
Joined: Sun Mar 25, 2012 5:44 pm

Re: Database update

Postby WhiteRider » Thu Nov 22, 2012 1:46 pm

That is not for 4.05.6, it is for earlier 4.05 versions.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Database update

Postby Barlin63 » Thu Nov 22, 2012 3:42 pm

Is it possible to roll back to version 4.05.5 because the last update is a bag full of problems?
Barlin63
 
Posts: 221
Joined: Sun Mar 25, 2012 5:44 pm

Re: Database update

Postby WhiteRider » Thu Nov 22, 2012 4:39 pm

You can get 4.05.5 here, but do please open a Support Ticket and report your problem first so that we can see what is going on. Other than the graph/report issue I haven't been able to report any other issues mentioned so far.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Database update

Postby Barlin63 » Thu Nov 22, 2012 7:03 pm

Ticket submitted with log file loaded with errors like:

2012/11/22 18:52:10.664 [00000]: [0000086C][PostgresConnection (Error)] Unable to execute query: SELECT (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')) as "tourney_date_start", (tourney_summary.id_tourney) as "id_tourney_summary", (tourney_results.val_finish) as "val_finish", (tourney_results.id_tourney) as "__gph__id_tourney", (tourney_results.date_start) as "__gph__tourney_date", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv" FROM tourney_hand_player_statistics, tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='barlin63' AND id_site='100')) AND (tourney_hand_player_statistics.id_tourney = tourney_results.id_tourney AND tourney_hand_player_statistics.id_player = tourney_results.id_player) AND ((tourney_hand_player_statistics.id_gametype = 1)) GROUP BY (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')), (tourney_summary.id_tourney), (tourney_results.val_finish), (tourney_results.id_tourney), (tourney_results.date_start) ORDER BY __gph__tourney_date asc, __gph__id_tourney asc; Reason: Fatal Error (ERROR: canceling statement due to user request )
2012/11/22 18:52:10.664 [00000]: [0000086C][Query] Query execution time: 21.83661497 ms
2012/11/22 18:52:10.664 [00000]: [0000086C][Query] Query canceled.

BTW I did not request to cancel a query.
Barlin63
 
Posts: 221
Joined: Sun Mar 25, 2012 5:44 pm

Re: Database update

Postby tarix » Fri Nov 23, 2012 3:54 am

We are working on a new beta to correct the issues with the tournament queries. In the meantime you can download the previous verion v4.05.5.
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 61 guests

cron