after update to 4.11 PT4 doesn't work

[Sattva]

Updated to 4.11.6 too. While rebuilding cash I've got this

screen.PNG (24.67 KiB) Viewed 2411 times

[WhiteRider]

so I hadn't updated since the initial 4.11 since I was able to get it working after some cache rebuilding. But I have some time this evening and decided to update to 4.11v6. downloaded update, installed, it said I needed to update cache after which I would need to do a full rebuild. I clicked ok. and I got this error:



"Error verifying cache table indexes on database: 2013_03_28_DB1

Error:
Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: operator does not exist: integer = text LINE 1: ...e WHERE id_player =$1 AND date_played_year_week in ($2) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: DELETE FROM cash_cache WHERE id_player = $1 AND date+played_year_week in ($2) CONTEXT: PL/pgSQL function "update_cash_cache_date" line 8 at SQL statement)

help?

Please open a Support Ticket and attach the full log file and we'll work with you to find out what is going on here.

As a test, if you create a new database and import a few hands, can you rebuild the cache of the new database?
If not, please make a Backup of just the default Optional Files and attach that to your ticket too so that we can experiment with your files.

[WhiteRider]

Updated to 4.11.6 when i try to rebuild cache i got this error

Please go to Database > Database Management and click Housekeeping > Revert PostgreSQL Tuning, then Housekeeping > Tune PostgreSQL to update to the latest settings. Try the cache rebuild again now - does that work?

(If not, try reverting tuning again then rebuild the cache.)

[WhiteRider]

Updated to 4.11.6 too. While rebuilding cash I've got this

screen.PNG

Go to Configure > Statistics and select $ > Player > Columns.
Type 'amt_won_no_sd_bb' into the search field - do you have a column with that name?

If not, that will need to be created since it must be being used in one of your stats; or you can re-import the Hud or Stat which uses it.

If you make a Backup of just the default Optional Files and attach it to a Support Ticket we'll be able to investigate for you.

[Sattva]

Updated to 4.11.6 too. While rebuilding cash I've got this

screen.PNG

Go to Configure > Statistics and select $ > Player > Columns.
Type 'amt_won_no_sd_bb' into the search field - do you have a column with that name?

If not, that will need to be created since it must be being used in one of your stats; or you can re-import the Hud or Stat which uses it.

If you make a Backup of just the default Optional Files and attach it to a Support Ticket we'll be able to investigate for you.

TY, the problem's solved now

[WhiteRider]

Great - thanks for confirming!

[WhiteRider]

so I hadn't updated since the initial 4.11 since I was able to get it working after some cache rebuilding. But I have some time this evening and decided to update to 4.11v6. downloaded update, installed, it said I needed to update cache after which I would need to do a full rebuild. I clicked ok. and I got this error:



"Error verifying cache table indexes on database: 2013_03_28_DB1

Error:
Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: operator does not exist: integer = text LINE 1: ...e WHERE id_player =$1 AND date_played_year_week in ($2) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: DELETE FROM cash_cache WHERE id_player = $1 AND date+played_year_week in ($2) CONTEXT: PL/pgSQL function "update_cash_cache_date" line 8 at SQL statement)

help?

Please open a Support Ticket and attach the full log file and we'll work with you to find out what is going on here.

As a test, if you create a new database and import a few hands, can you rebuild the cache of the new database?
If not, please make a Backup of just the default Optional Files and attach that to your ticket too so that we can experiment with your files.

I misread your post originally. Please go to Database > Database Management and click Rebuild Cache > Full Cache Rebuild and that should correct it.

[RTICTM]

Ok. Since i revert back to 11.3 my HUD is working and im importing hands just fine. (i dont know why, because it wasnt working before).

do you think its ok to upgrade to 11.6 ? I mean, i dont know if all stats on the HUD are showing the right numbers (i think it is), but i dont wanna upgrade and lose my ability to import hands OR use the HUD.

Is this really a stable version?

Thanks.

[kraada]

Everyone who was reporting problems who has upgraded to 4.11.6 is reporting them fixed. We are encouraging everyone to upgrade at this time.

[nereik]

you guys are awesome, how you have managed to fix all of this and still answered all our questions here is insane...
import, hud & cache rebuild working fine...
I do however keep on getting an error when I try to set my old db to default --> invalid database.