PDA

View Full Version : Connection Error



chilwad8132
09-02-2009, 06:30 PM
When I try to open HEM, I get the following error:

DB Control Panel

Connection Error: FATAL:XX000: could no read block 0 of relation 1664/0/2677: Invalid argument

Npgsql.NpgsplException:
could not read block 0 of relation 1664/0/2677: Invalid argument
Severity:FATAL
...


I uninstalled and re-installed postgreSQL according to the sticky and that didn't help, also uninstalled mcaffee and turned windows firewall and defender off.

Please advise

fozzy71
09-02-2009, 09:36 PM
...

I uninstalled and re-installed postgreSQL according to the sticky and that didn't help, also uninstalled mcaffee and turned windows firewall and defender off.

Please advise

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.


Which sticky? or a FAQ? Did you try making a new DB first, in your old installation? Did you reinstall and use your same DB?


Chances are it is a problem with the DB and/or Postgresql itself. I am now leaning towards the former, assuming you used your existing DB in the new postgresql installation.


This would be my suggestion:

Before you uninstall SQL:

You want to make sure you backup your Processed/Archived hand histories.

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173



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 uninstalling SQL please follow these steps:

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

net user postgres /delete
4) reboot.
5) install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using postgresql 8.4 one-click installer. There is not a FAQ yet for 8.4, but the installer is very easy to use.

http://www.enterprisedb.com/products/pgdownload.do#windows