No stats showing up.

[sledghammer]

Vista, Stars, HM v. 1.09 Beta 20.

I found the correct database, and selected it as active. Still no stats showing up for anyone. Seems like a great piece of software. My SmartBuddy subscription just ran out, and I'm looking to replace it with something better. Any help would be appreciated.

[ZandryTST]

There is a little bug that I meant to fix in the latest version but I forgot, it seems that HM is not using the "pokersites" table any more so recent installs of HM do not work sometimes. If this is the problem you are having you can verify by opening Start > Program Files > postgresql > pgAdmin III, then in the list choose your server > databases > holdemmanager > schemas > public > tables > pokersites, right click and choose "Scripts > SELECT script", then in the window that opens choose "Query > Execute". If you do not see any results in the bottom then that means the table is empty, and that is the source of the problem here.

Here are instructions on how to fix it:

1) Run pgAdmin
2) Navigate to the pokersites table in the same way as described above
3) Right click and choose "select script"
4) In the top box, delete the provided query, and paste all the following text
5) "Query > Execute"


INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (0, 'Party','PP', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (1, 'Full Tilt','FT', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (2, 'Stars','PS', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (3, 'Prima', 'PRM', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (4, 'iPoker','IPK', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (5, 'Absolute','ABS', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (6, 'Crypto','CRY', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (7, 'Bodog','BDG', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (8, 'Ultimate Bet','UB', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (9, 'Ongame','ONG', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (10, 'Everest','EVS', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (11, 'Boss','BOS', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (12, 'Pacific','PAC', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (13, 'CakePoker','CKE', 0);
INSERT INTO pokersites(
site_id, sitename, abbreviation, minuteadjustment)
VALUES (14, 'Betfair','BTF', 0);


If this is not the problem you are having, please send me a message on AIM, MSN, or ICQ and I will look at it on teamviewer, this is always the easiest type of problem to fix
AIM: ZandryTST
MSN: zandry@tablescanturbo.com
ICQ: 571846001