update database error

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

update database error

Postby Crackdel29 » Wed Aug 28, 2024 4:36 am

I update PT4, and after pt4 ask for update database, and in every base there is the same error, i don't know how to fix:

Error updating database: mis manos
Error:
Error: Unable to execute query: Fatal Error; Reason: ERROR: column "some_time" does not exist LINE 6: ... SELECT (CAST (date_part('year', timezone('UTC', some_time)... ^

If i don't update database is not working PT4 in the poker tables.
Crackdel29
 
Posts: 5
Joined: Tue Mar 29, 2016 8:43 am

Re: update database error

Postby Flag_Hippo » Wed Aug 28, 2024 6:23 am

This issue only happens with very old PostgreSQL versions such as v8.4 which reached its end-of-life in 2014 and is below the minimum required version for PokerTracker 4. To fix the issue you will need to install and use a newer PostgreSQL version and then restore your database(s) - see this guide:

https://www.pokertracker.com/guides/PT4 ... postgresql
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am

Re: update database error

Postby Crackdel29 » Wed Aug 28, 2024 9:51 am

Flag_Hippo wrote:This issue only happens with very old PostgreSQL versions such as v8.4 which reached its end-of-life in 2014 and is below the minimum required version for PokerTracker 4. To fix the issue you will need to install and use a newer PostgreSQL version and then restore your database(s) - see this guide:

https://www.pokertracker.com/guides/PT4 ... postgresql


Ok , thank you i did the back up.
But is not finishing, after 2 hours conitnue like this:
https://gyazo.com/8e19ca9df88e48a217775c53cc119393

It's frozen always in this position, said that back up complete but if i click cancel nothing hapen if i click "x" also become frozen i need to close in task manager PT4, anyways if say that it's complete i can continue after close pt4 in task manager with next step?

tHANK YOU.
Crackdel29
 
Posts: 5
Joined: Tue Mar 29, 2016 8:43 am

Re: update database error

Postby Flag_Hippo » Wed Aug 28, 2024 1:37 pm

As long as the backup file has been created and saved on your computer then you should be OK to proceed.
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: dipandglide and 13 guests