cash_hand_player_statistics.flg_f_second needed

[kraada]

I can't see the image you posted. How large are your databases? You may need to alter the tables to remove those columns, update, and then recreate them. Since they aren't part of the database as PT4 expects it to be, it's not something our updater can necessarily handle.

Depending on how much work that is it might be easier for you to just create a new 4.11 database, reimport your data, then create your extra column as you need.

4.11 will have much better performance with custom stats that are cached -- they will be just as fast as built in stats.

[ommaha]

[ img ]

http://www.pic-upload.de/view-23258952/ ... e.jpg.html

thanks for fast reply.

which tables do you mean and how/where can i alter them?

reimporting the databases would take very long. we are talking about ~40GB. in addition hand export usually does not work well.
when i export 100k hands (export hand histories) and reimport them i usually get just ~70-80k.

[kraada]

Read the log file for the full error -- the HINT part should be particularly relevant.

As I said earlier there's only so much database hacking we can directly support, but hopefully when you see the HINT in full it will be exactly what you need.

[ommaha]

there is no hint part in the logfile. i try again to update the db´s which should fail. i hope there is something in the logfiles afterwards.

btw is there a possibility to downgrade for the moment? (atm hud is not working, so i cannot play)
where can i find old versions to download?

[BillGatesIII]

Yeah, had the same problem. You'll have to drop the functions first before you can upgrade the database. After upgrading you'll have to restore those functions.

[ommaha]

how/where can i drop them?

[ommaha]

i found http://dave.webdev.pgadmin.org/docs/1.6 ... ction.html

so, if i execute
DROP FUNCTION str_toact_f(cash_hand_summary);
in pgadmin the problem is solved?

[BillGatesIII]

Yep, something like that should work.

[kraada]

I'm pretty sure it should be given that it's in the error in the screenshot you posted, but either way once you've dropped the function upgrading should finish.

[ommaha]

thank you very much for immediate help! i tested with a small db and the upgrade worked out. i am now running the larger db´s and the first one is already finished. so, it seems to work well. thanks again very much