View Full Version : Number of hands in database
fizzypants
02-11-2011, 03:58 AM
Hello,
I followed the instructions in this thread:
http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+
to find out the number of hands in my database.
However, after Step 4, the screen I see is not the same as shown on this FAQ. It doesn't show any number and the box on top-left shows some other message. Can someone help? Here's the screenshot:
ImageShack® - Online Photo and Video Hosting (http://img600.imageshack.us/i/82714913.png/)
Thanks in advance.
The Minder
02-11-2011, 04:02 AM
Hello,
I followed the instructions in this thread:
http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+
to find out the number of hands in my database.
However, after Step 4, the screen I see is not the same as shown on this FAQ. It doesn't show any number and the box on top-left shows some other message. Can someone help? Here's the screenshot:
ImageShack® - Online Photo and Video Hosting (http://img600.imageshack.us/i/82714913.png/)
Thanks in advance.
From the looks of the data in that image, I think you just trashed your database... better do nothing till a support person gets here.
fizzypants
02-11-2011, 04:08 AM
From the looks of the data in that image, I think you just trashed your database... better do nothing till a support person gets here.
Jeez. Well, I have been trying all day to purchase Omaha Manager in addition with the Holdem Manager, and in the process, deactivated/activated my license several times until I figured out how to make HEM and Omaha Manager work together. I am afraid if that has caused my database to collapse?
But are you sure, because I see all my stats/reports/etc in HEM still?
netsrak
02-11-2011, 04:49 AM
Did you run the query from your screenshot?
I hope not as it would create a new empty database. You need to delete the commands in the editor window and enter "select count(*) from pokerhands"
But as you can still see all your data i don't think you have damaged your database.
fizzypants
02-11-2011, 05:09 AM
Did you run the query from your screenshot?
I hope not as it would create a new empty database. You need to delete the commands in the editor window and enter "select count(*) from pokerhands"
But as you can still see all your data i don't think you have damaged your database.
Databases>holdemmanager Tools>query tool
New window opens (as shown in my screenshot)
When I tried to close that window. It said "TEXT HAS CHANGED. DO YOU WANT TO SAVE THE CHANGES" I select No.
Try the same thing again, same result.
Not sure what's up :(
netsrak
02-11-2011, 12:55 PM
You need to overwrite the text and not to close the window.
If you have problems with this please have a look in the postgresql help or documentation.
fizzypants
02-11-2011, 02:47 PM
You need to overwrite the text and not to close the window.
If you have problems with this please have a look in the postgresql help or documentation.
What do you mean by "overwrite the text"? No idea :(
Patvs
02-12-2011, 03:08 AM
Delete whatever text is shown by default in the query window.
And only adding the hand count query, so it will look like:
http://faq.holdemmanager.com/images/how-many-hands-02.jpg
fizzypants
02-12-2011, 03:34 AM
I could only overwrite the text in the top-left box. I could not add any digits under "data output". Then I tried closing it and it asked me to save it, and a notepad file got saved to my desktop containing the same text which I wrote. Then I re-opened the Query in postgres, and the text has returned to the default one and whatever I wrote is not there.
Patvs
02-12-2011, 04:00 AM
Only change the text in the top left window.
And click F5 (refresh)
And the output (bottom window) should show the #hands count.
fizzypants
02-12-2011, 04:08 AM
Only change the text in the top left window.
And click F5 (refresh)
And the output (bottom window) should show the #hands count.
Thanks, that worked. But when I restart it, the original text comes back. Why is that?
Sarek
02-12-2011, 06:26 AM
you have to save querry - and load it when need
press Diskette button
fizzypants
02-12-2011, 06:35 AM
you have to save querry - and load it when need
press Diskette button
Saving query saves a notepad file "query.sql" on desktop thats all. Do I have to keep this file on my desktop and load it everytime I need to see the number of hands? Moreover, how do I load the query.sql notepad file?
Also, where is the Diskette button and what do I need it for?
Thanks :)
Patvs
02-13-2011, 01:50 AM
Just save the line:
Select Count(*) from pokerhands in a text file. And always change the default query (by copy pasting that line into the query window).
You're only going to run this query once a year anyways right? Not daily?
fizzypants
02-13-2011, 02:37 AM
Just save the line:
Select Count(*) from pokerhands in a text file. And always change the default query (by copy pasting that line into the query window).
You're only going to run this query once a year anyways right? Not daily?
Right lol. Thanks a lot :)
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.