after update to 4.11 PT4 doesn't work

[Salats]

ticket - 152434
I have a database with around 2mil hands. It takes a long time to rebuild cache, please tell me if I have to do it so I can get this fixed ASAP.

[Salats]

Ok, so i installed 4.11.1, hoping it would fix some of the problems, now the hands import in a rate of 1 per 10 seconds and the hud isnt working giving me "the unknown token encountered" bullshit.

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.

You can resolve the issue on your own by going into Configure -> Statistics. View Stats and edit the custom stats which give the unexpected tokens - change the uppercase characters in the column names to lowercase and save.

OK, this worked, I will inform you if I get any further errors.

[kraada]

We're working towards and hoping to release 4.11.2 later today which we are hoping will resolve the slow import issue. We have (finally) been able to reproduce it and we are working on testing our fix now. Assuming everything goes well we will release it later today and hopefully that will fix things for everybody.

[casperwell]

Support Ticket #152442

HUD began to work well at 1 desktop, but already playing 5 desktops brakes on 5-10 hands, more desktops didn't decide to try

[zolih]

Hi!

I have tried to update the DB ,but my postgreSQL used 99% of my cpu constantly and the tempreature of the CPU went up to 96C, so I decided to abort the whole process.
Of course my DB messed up. I was able to search in my DB , but couldnt import. So I decided a system restore to a previous date. It was successfull ,my PT4 switched back to v4.10, but my DB got much much worse. Now I am unable to do anything in my PT4. I get the following error message in every tab(result,graphs,my reports...etc): Unable to execute query: SELECT FROM ..../sql commands/ .


DB update is out of question because postgresql uses all my CPU and tempreature is WAY high.

Rebuild cache didnt worked and got this message:

"Unable to rebuild cache.
Reason: Unable to prepare query: INSERT INTO cash_cache SELECT cash_hand_player_statistics.id_player, cash_hand_player_statistics.id_gametype, cash_hand_player_statistics.id_limit, cash_hand_summary.cnt_players, FROM
cash_hand_player_statistics
WHERE (cash_hand_player_statistics.id_player = $1)
; Reason: Fatal Error (ERROR: syntax error at or near "FROM" LINE 1: ...er_statistics.id_limit, cash_hand_summary.cnt_players, FROM ^ )"


What should I do?

Thanks!

PS:
As I see many of the users have some problem because of the update, there for I think, that when the pt4 prompts that there is an update, you really should to provide more information to us at the update screen about the length of the whole process, about the possible downside of doing this. And about the fact that no all the users have to update the DB.

[Darvini]

I changed the column names to lover cases and error messages are gone but HUD doesnt show any of those stats. Its just 0/0 on all cases. Reports show them normally.

[kraada]

zolih: We don't recommend downgrading. Please upgrade back to 4.11.1, and run Rebuild Cache from Database -> Database Management -> Housekeeping, and that will most likely help. If you get an error message, please send us a support ticket with the error so that we can tell you the proper next step to take.

Darvini: Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder. We'll need to see the log to figure out why the stats aren't showing data.

[ommaha]

is it possible to export table groups or at least popup groups with 4.11.1, to downgrade to 4.10.9 and to import them there?

ok. tested on another pc: it is not possible

thanks for your response to my ticket @whiterider
where can i set/remove cache flags?

nevermind. i made it back to 4.10.9 and i am so happy after suffering 4 days of torture. forget ticket 152164 please.
you can get the hud-profile back (after downgrading pt and the databases to 4.10.9 and) after closing pt by removing the Layouts.pt4 from user data folder -> data (save it in another folder, do not delete). then rename Layouts.1019.pt4.backup into Layouts.pt4

[TedHawkins]

Can anyone explain the complete process to dowmgrade both pt4 and the databases to the previous working version 4.10.9 plz?

[kraada]

We still do not recommend downgrading. Can you tell me what your issues are? Several issues were solved with 4.11.1 and I may be able to help get things working for you.