PDA

View Full Version : Error Message ...



verneer
10-15-2009, 07:03 PM
I got this error message as I was importing hands from my old computer to my new one and opened up the "Preflop Activity" section:

http://img397.imageshack.us/img397/3984/error1o.jpg

I've already re-indexed my new database twice (I'm running 8.4 with the newest HEM beta). What else should I do? All other section like "Positional Stats" and "Winnings Summary" seem to be working normally.

fozzy71
10-15-2009, 08:27 PM
You can try to fix that particular index:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168


If that doesnt work you will have to build a new db:

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

verneer
10-15-2009, 08:35 PM
Which index corresponds to my error?

fozzy71
10-15-2009, 08:50 PM
The one specified in quotations in your error message.

verneer
10-15-2009, 08:57 PM
I don't see that as one of the options. Here are my options:

http://img48.imageshack.us/img48/1835/errorindexes.jpg

fozzy71
10-15-2009, 09:07 PM
There is another thread with the same problem and same index. I am unsure what to suggest other than a new db and reimport.

verneer
10-15-2009, 09:19 PM
I made a new database, imported 200 of my most recent hands from PokerStars, and am getting the same error message.

Should I just start fixing indexes one by one?

fozzy71
10-16-2009, 03:36 AM
I would reinstall postgresql and import your archives.


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

verneer
10-16-2009, 08:03 AM
I did all that - deleted and re-installed PostgreSQL, updated to the latest beta, and when I logged in and imported my last 200 hands from Stars, I got the same message. Time and uninstall and re-install HEM?

verneer
10-16-2009, 08:08 AM
Un and re-installed HEM and problem seems to be fixed.

verneer
10-16-2009, 09:24 AM
One more note: If I remove the "$" Stat in the Preflop Activity selection, the problem comes back. Once I put it back in, it's gone. So it seems to be a HEM software error, not a PostgreSQL one.

netsrak
10-16-2009, 09:28 AM
Thanks, i'll forward it to the developer...

Rvg72
10-17-2009, 11:25 PM
One more note: If I remove the "$" Stat in the Preflop Activity selection, the problem comes back. Once I put it back in, it's gone. So it seems to be a HEM software error, not a PostgreSQL one.

Hi, you are correct - this is not a postgresql database error and is actually a Holdem Manager bug since without that column we skip one of the joins which happens to be needed in this report

Roy