Can't update cache

[IzidorAQ]

I have made a new database and manually imported 1mio+ hands. Then vacuumed, analyzed and tried to update cache. Right at the start of the update process PT shows this error: "There were errors during the housekeeping process: Unable to execute query: CREATE TABLE holdem_cache (id_player integer NOT NULL, id_limit ...... bla bla bla (very long) ...... js2002_cnt_t_probebet_after_seeing_checkbehind_f_oop ineger, walks integer);; Reason: Fatal Error (ERROR: column "cnt_p_3bet_bb" specified more than once )

Edit: One more thing: I have updated to v3.11.3 beta before creating this database.

[WhiteRider]

That means that you have more than one custom stat column with the same name different only by case. Here it looks like "cnt_p_3bet_bb" and you probably also have "cnt_p_3bet_BB". You need to remove one of them - they will probably have the same definitions.

Tutorial: Custom Reports and Statistics