Unable to rebuild cache

[goldengummy0]

I get the following error messasge: Unable to execute query: Fatal error; tables can have at most 1600 columns.

I think it's because I have too many huds installed right now, but I can't really delete any of them. How can I rebuild cache without removing any of my huds?

[Flag_Hippo]

If you do not want to remove any of that content your only option is to manually disable the cache for some custom columns to get below the limit for cached columns in PostgreSQL:

Guide: Database Caching

Disabling the cache will mean any statistics using them will have to be calculated on demand which may mean delays in the HUD. If you do not know how many custom columns you currently have click your Windows Start button then type the following:

pgadmin

and click on it when it appears. Double click on "PostgreSQL x.y" (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes). Next double click on "Databases -> YOUR_DATABASE_NAME -> Schemas -> Public -> Tables -> cash_custom_cache (and/or tourney custom cache for tournaments) and the number in brackets is the number of custom columns which should look like this.

Also please note that in some cases that number doesn't correlate directly to the number of cached columns which depends on the custom content you are using - you can see more about this in this thread and this thread.

[goldengummy0]

If you do not want to remove any of that content your only option is to manually disable the cache for some custom columns to get below the limit for cached columns in PostgreSQL:

Guide: Database Caching

Disabling the cache will mean any statistics using them will have to be calculated on demand which may mean delays in the HUD. If you do not know how many custom columns you currently have click your Windows Start button then type the following:

pgadmin

and click on it when it appears. Double click on "PostgreSQL x.y" (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes). Next double click on "Databases -> YOUR_DATABASE_NAME -> Schemas -> Public -> Tables -> cash_custom_cache (and/or tourney custom cache for tournaments) and the number in brackets is the number of custom columns which should look like this.

Also please note that in some cases that number doesn't correlate directly to the number of cached columns which depends on the custom content you are using - you can see more about this in this thread and this thread.

Thanks for your answer. So do I disable the cache of the columns by unclicking this?



The image doesn't load, I mean the cache square in the statistics window.

(Sorry I'm a fish with computers) But I don't see many new columns besides the ones that come with PT4 by default.

I've also just realized today none of my huds work on any site. Is it because of the same reason?

[Flag_Hippo]

That sounds like most of your custom content is protected which means that it cannot be viewed/edited in PokerTracker 4 so to get below 1,600 columns you will need to contact one or more of your premium providers and have some content disabled so that PokerTracker 4 doesn't load it. Once you are below 1,600 custom columns you should be able to rebuild the database cache and your HUD should start working again. You can also remove the check mark from the PokerTracker 4 option 'Configure -> Options -> Download Premium Content' then close/restart PokerTracker 4 but this will disable all premium content.