cant access vs player tab

[b0bb4n]

When i click vs player tab its just white and HM is working but nothing happens, i can click on another tab without any problems and HM dont freeze..

After awhile i get some pop up message.. Think its from net frame 2.0

EDIT: tried installing newest beta but same problem


EDIT 2: http://img813.imageshack.us/img813/8154/hm1.png (http://img813.imageshack.us/i/hm1.png/)

[netsrak]

This means that the statement you are trying runs to long.
What exactly are you trying to do?
Please try to specific more filters before you start the query.

[b0bb4n]

what?

vs players on the left, nothing happens when i click it... HM is just working and then that pops up

[netsrak]

Please enable Options -> Settings -> auto apply filter changes to all tabs.

Reports -> choose today, this month or something similar with a small amout of data.

Now try the vs. players tab again - does it work?

How many hands do you have in your database? FAQ - Hold'em Manager Poker Tracking Software :: Check Total Amount of Hands in Database (http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+)

Please check our performance tips: FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks (http://faq.holdemmanager.com/questions/373/Holdem+Manager+Performance+%26+Speed+Tweaks)

[b0bb4n]

Today only works after awhile

and checking for how many hands in database i get this


ERROR: relation "pokerhands" does not exist
LINE 1: Select Count(*) from pokerhands
^

********** Error **********

ERROR: relation "pokerhands" does not exist
SQL state: 42P01
Character: 22


and there is already something written in the query tool, no idea if its suppose to

[morny]

Try removing Winner Name, Winner cards and winner won from the hands view column FAQ - Hold'em Manager Poker Tracking Software :: Hands View Column Selection (http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection) save it and refresh.

If your using the newer version youll find it under Options > Settings > Hands View Column Selection

If that doesnt work there may be an issue with your database, can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database) and import a bunch of hands and see if the error persists

[b0bb4n]

Its strange.. it only seems to be a problem with one of my screen names.

only played on it this month on ongame and if switch to my old ongame nick its no problem to see vs players.

[netsrak]

Please try a reindex of your database via pgadminIII->maintenance.

[b0bb4n]

didnt seem to help

gonna see if theres a problem with a new database, it there is not i could just backup the one i use now and delete this and restore it?

or is it likely the same problem remains?


EDIT: its so strange, when i created a alias the vs players works with no problem, even if its the same hands from last month...

it only has problem with one screen name

[netsrak]

Odd, really looks like a database problem. I don't think a backup / restore will fix it. I would suggest to create a new empty database and reimport all hands/notes/summaries manually.

[b0bb4n]

Ok, so i export all the hands i have in my database and create a new and import them?

[netsrak]

yep