v4.11.1 HUD proglem: "Unknown token encoutered"

[sawwee]

For me and several of my students HUD looks like this:

unknown_token.PNG

(205.21 KiB) Downloaded 8394 times

We didn't experience this problem in v4.11 and before.

Any solution?

[kraada]

Do those columns exist (cnt_hands_SB_30_100, cnt_pfr_SB_30_100, etc)?

[eejit]

Same problem for me after updating to 4.11.1 today. Everything worked fine on 4.11. Some or all custom stats appear to be broken.
Unknown token encountered:cnt_minr_SB etc
Non custom stats appear fine
Im also using Coffee Hud 2.1
I tried downloading the lite version same problem. Seems most of the errors are to do with the SB

[sawwee]

I think I know the reason. In v4.11.1 all the column names were lowered and it means that all the columns with capital letters in the name were changed so stats can't find their columns. :-(

Is it time to re-write a few hundreds column manually or there will be a solution in the next update?

[_dave_]

yeah this is pretty bad :( any stat / column using mixed case is broken?

[_dave_]

after conducting some tests, it would appear a clean install of PT4 4.11.1 with CoffeeHUD 2.0.1 premium is broken (due to lowercasing all the words as Saweee suggests, I concur). Not sure if it's possible to recover from such an update, I had to revert a player to 4.11 and clean install, so he's now without any of his custom reports and such but at least can play.

[StevenM]

This is "breaking news" to us, at the same time _dave_ posted this above we got an email from the Coffee HUD developer asking what he can do to help. We did some quick research, and this is what we discovered:

PostgreSQL by default converts columns, expressions, and variables to lowercase. This was causing naming collisions in the v4.11 release because some developers were using the same column names in PokerTracker 4 but using different capitalisations. PT 4.11 was the first time we ever cached custom columns in PT4, therefore we discovered that because we had to force all column naming to switch to lowercase to assume that these conflicts from different custom stat developers can be avoided. We started converting all columns to lowercase with the release of v4.11.1.

Unfortunately, while the columns are being converted, the statistic definitions referencing those columns are not being converted. We rushed to put out 4.11.1 in record time to address this issue and others related to PostgreSQL, it was an ASAP rush that had to get done. In the process we overlooked that detail - which is why this affects some custom stats but not all.

I'm happy to report that we will fix the issue and and release a new version with a fix ASAP (hopefully within the next 48 hours). Additionally we are contacting all of the major custom HUD developers to advise them how to perform naming standardisation in the future - but we should be able to fix this programmatically in the time being.

Sorry for the confusion Coffee HUD users, this is something we did not expect and did not test for because we were in such a rush to get out a patched release. On the bright side if you do not use extensive custom HUD that contain custom stats the odds are that the 4.11.1 update will help, not hurt you. I can also report that the developers of CoffeHUD are working with us right now, we both agree these changes will be positive in the long run - but in the short term we acknowledge that this is certainly an unfortunate headache that we are rushing to fix. Thanks for your patience and understanding...

[StevenM]

UPDATE:

Together with CoffeeHUD's developers we believe that we have fixed this issue for Coffee HUD. We have renamed the new version to: Tournament - CoffeeHUD v2.0.2

The file has been uploaded and CoffeeHUD users simply need to restart PT4 and it should download the new fixed version. Please let us know if there are continued issues for CoffeeHUD users.

[APerfect10]

With the owner of CoffeeHUD's permission, I have fixed CoffeeHUD. Please restart PokerTracker and the new CoffeeHUD v2.0.2 should download and install which will resolve the issue.

To everyone else experiencing this problem:

PostgreSQL converts all columns, variables, etc. to lowercase. Up until 4.11, we allowed column names to be upper, lower or mixed case. Unfortunately, this caused column collisions with the newly implemented custom cache.

Therefore with v4.11.1, we automatically convert all column names to lowercase (how PostgreSQL views it). Unfortunately, custom stats that reference the old mixed case columns are not being converted to lowercase and are instead pointing the old mixed cased names which are no longer valid resulting in the "Unknown token encountered' error.

We will be releasing a patch to resolve this issue. Until the new version is available with the fix, you can resolve the issue on your own by going into Configure -> Statistics. View Stats and filter for 'Show Custom Stats'. Scroll through the custom stats and any stat that is referencing a column with uppercase characters, change the uppercase characters to lowercase and save. (Repeat for all stats)

Best regards,

Derek

[zaebumba]

I've got PT 4.11.1 and CoffeeHUD 2.0.2 and still have this problem.