after update to 4.11 PT4 doesn't work

[TedHawkins]

I would be grateful if anyone could post a step by step process for updating Postgresql to v9.3. I tried but it does not appear to work ticket 152461

[mmarcr]

Ok. I think I would play by mobile phone, so I will still trying to repair this..........

Should I update firts to 4.11.2? Or I should try to restore again first?

And other thing... when I open my dabatase management I have 2 databases... the last one was created when I updated to 4.11.1 and one error appeared.

(sorry for my bad english )

Hi, I just decided to update to v.4.11.2 and now the HUD works, but doesnt appear any old hands with my oponents!!
When I try to select my default database as active, called "PokerTracker4 Database" (please see the picture) Appears an error saying: "Please select from the valid databases".

What I should do to save my old hands?

[TedHawkins]

Postgresql query: "[ERROR: function generate_subscripts(int2vector, integer) does not exist
LINE 8: FROM generate_subscripts(idx.indkey, 1) as k
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

********** Error **********

ERROR: function generate_subscripts(int2vector, integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Character: 223]

[casperwell]

I updated to v.4.11.2, HUD works as before but playing some desktops there are same problems, doesn't manage to update a hand.

[wikked76]

I would be grateful if anyone could post a step by step process for updating Postgresql to v9.3. I tried but it does not appear to work ticket 152461

https://www.pokertracker.com/guides/PT4 ... tgresql-93

[WhiteRider]

Ok. I think I would play by mobile phone, so I will still trying to repair this..........

Should I update firts to 4.11.2? Or I should try to restore again first?

And other thing... when I open my dabatase management I have 2 databases... the last one was created when I updated to 4.11.1 and one error appeared.

(sorry for my bad english )

Please update to v4.11.2 - a few more issues were fixed here.
If you can't connect to the restored database, or if it doesn't have all your data, then you can delete it from that window.

[WhiteRider]

I would be grateful if anyone could post a step by step process for updating Postgresql to v9.3. I tried but it does not appear to work ticket 152461

There are directions in this guide, but you may not need to upgrade and you should not attempt it unless you know what you are doing. What version of PostgreSQL were you using before?

[WhiteRider]

Ok. I think I would play by mobile phone, so I will still trying to repair this..........

Should I update firts to 4.11.2? Or I should try to restore again first?

And other thing... when I open my dabatase management I have 2 databases... the last one was created when I updated to 4.11.1 and one error appeared.

(sorry for my bad english )

Hi, I just decided to update to v.4.11.2 and now the HUD works, but doesnt appear any old hands with my oponents!!
When I try to select my default database as active, called "PokerTracker4 Database" (please see the picture) Appears an error saying: "Please select from the valid databases".

What I should do to save my old hands?

If you changed PostgreSQL versions and deleted your previous version of PostgreSQL then you will not be able to connect to the old database using the new version of PostgreSQL. In that case you will need to restore your backup before you can connect.
If you continue to have problems please open a Support Ticket and recap everything that you have done and what problems you now have - this thread is not the place for ongoing troubleshooting of a specific issue like this as we can't really keep track of individual config issues.

[WhiteRider]

Postgresql query: "[ERROR: function generate_subscripts(int2vector, integer) does not exist
LINE 8: FROM generate_subscripts(idx.indkey, 1) as k
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

********** Error **********

ERROR: function generate_subscripts(int2vector, integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Character: 223]

Have you made modifications to your database, or do you use custom stats which rely on modifications to a database?
I'm not familiar with that error, and it suggests a non standard database to me.
Can you create a new database and use that?

[WhiteRider]

I updated to v.4.11.2, HUD works as before but playing some desktops there are same problems, doesn't manage to update a hand.

I'm not sure exactly what you mean - could you try explaining the problem in a different way? If you already have an open ticket please reply there with any new information instead so that we have the history of your problem to hand when replying.