PokerTracker

Hi,
I get this message when I try to rebuild cache: "Unable to rebuild cache. Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: invalid input syntax for integer: "" CONTEXT: PL/pgSQL function "update_cash_custom_cache_playerrange" line 12 at FOR over SELECT rows )".
This happened after I've downloaded and imported some stats. As suggested here https://www.pokertracker.com/forums/vie ... 58&t=57277, I have created and successfully rebuilt a new db.

Which stats did you download and import?

Fold to Preflop 4Bet after Squeeze - Fold to Cold 4Bet After 3Bet - Squeeze responses - 5Bet+ PF After 3Bet - 4Bet Preflop IP & OOP - Fold to PF5Bet after 4Bet - Call vs MP Open - Call vs EP Open - 4Bet Preflop After Steal - Fold to PF 4Bet After 3Bet BTN vs CO - 4Bet Preflop CO vs BTN - Fold to CBet Total - CBet Total. I imported "BB/100 stats for Holdem Hand Range Visualizer" too, I used it in HRV only, then I deleted it.

When you deleted that stat did you delete the columns that it uses as well or just the statistic itself?

Just the statistic itself after trying rebuild cache

Try going in and deleting its column - the columns are what actually matters for the cache. If you could help us narrow down the column that's causing the problem for you that would be a big help, as we've tested these stats before approving them and haven't seen these problems in our testing environments.

The columns used by that stat are built-in ones

Ah yes. To try narrowing it down further could you please try removing the columns and stats one at a time (you can always reimport them later - pick a stat, remove it, and then remove its columns) and rebuilding the cache between each? That should pinpoint the stat that's the problem and we'll be able to get it fixed then.

The prob is my db is enough big it will take so long to rebuild each time, 2h or more each try maybe

Try pulling half then half again if it isn't fixed - that will narrow it down pretty quickly.