PDA

View Full Version : new database error



martin dtc
02-04-2012, 01:46 PM
my old DB was acting funny so I exported all my hands and imported them in a new DB
i restarted HEM and the popup with optimizing players came up and it ran for a while

but later i got this popup which said:
The following error occured: A timeout has occured. If you were establishing a connection, increase Timeout value in ConnectionString. If you were executing a command, increase the CommandTimeout value in ConnectionString or in your NpgsqlCommand object.

All these words are hocuspocus to me.
Everytime i open hem it first sais optimizing players, this goes on for a while and then i get this error. so i cant really use hem.

How do i fix this?

DogNamedBluff
02-05-2012, 01:23 PM
This is usually a firewall or windows update issue.

Which Operating System, Firewall, and Anti-Virus are you using?

Many of those free Norton, Mcaffee, Comodo, Zonealarm, etc, 'internet security' bundles will not work well with holdem manager.
Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:
1) Uninstall any 3rd party security software bundles.
2) Reboot your computer
3) Please install the latest version:https://www.holdemmanager.com/downloads/Holdem_Manager_2_Setup.exe
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM, HUDFuncs and SQL - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Microsoft Security Essentials - Free Antivirus for Windows (http://www.microsoft.com/security_essentials/)

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer 9 (even if you use a different web browser) and change your Windows Control Panel > Regional Settings Format to English (USA).

The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems

martin dtc
02-05-2012, 03:12 PM
i dont have any 3rd party security, just the regular windows one
but from the error i read, increase timeout value or commandtimeout value in connectionstring.. how do i do this?

udbrky
02-06-2012, 02:04 AM
Make sure that you add:

holdemmanager.exe
hmimport.exe
dbcontrolpanel.exe
hmhud.exe

postgres
pg_ctl

to your firewall exceptions.

The problem is that postgres keeps stopping.