how to check wether db is in ASCII or UTF in HM1 +2 ?

[poporella]

how to check wether db is in ASCII or UTF in HM1 +2 ?


somehow since the last stars update not all games are being imported.

Almost half of my sngs are not being imported. no matter wether i use HM1 or HM2

[Patvs]

See screenshot. You can see the encoding in pgadminIII:

115131

[poporella]

ok dbs are in UTF so the problem must be something else.

[udbrky]

I would start with a reinstall of postgres. Use the same version you have now and the same data folder that exists, so you will not lose data.

Next, I would try a new windows user.

What is your antivirus and firewall? AVG has been causing issues like this lately.

Many of those free Norton, Mcaffee, Comodo, Zonealarm, Avira, Avast, AVG, 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: http://www.holdemmanager.com/downloads/Holdem_Manager_2_Beta.exe
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - http://hm2faq.holdemmanager.com/questions/1011/Software+Security+Problems+%28Firewall%29
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Microsoft Security Essentials - Microsoft Windows (http://www.microsoft.com/security_essentials/)

If you continue to have problems, please reproduce the problem and attach your log.txt file.

Please 7-Zip (http://www.7-zip.org) the file before attaching it, as sometimes text files can become corrupted as attachments.

XP:
c:\documents and settings\username\application data\HoldemManager

7/vista
c:\users\username\appdata\roaming\HoldemManager

Enable the option to see Hidden Files and Disable "Hide protected operating system files": http://hm2faq.holdemmanager.com/questions/832/How+are+Hidden+Files+Viewed+in+Windows%3F+ - It should look like this: http://rvgsoftware.fileburst.com/images/hidden.jpg


- Please see these steps to fix postgresql connection issues:

http://hm2faq.holdemmanager.com/questions/1001/Can+not+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

- Please make sure that you have allowed postgres and pg_ctl in your firewall and antivirus exceptions. They are in postgres\bin. See this guide for windows firewall:

http://hm2faq.holdemmanager.com/questions/1052/Windows+Firewall+%7B47%7D+Defender+Problems

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working.

Download the same version you are running from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows) - do not use 9.1 or 9.3. Uninstall yours.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

Install in the same location yours was installed in.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.


- If your windows user name has any unique 'cyrillic characters' you may need to create a new windows user with a single EN-US name without any special characters.
- Uninstall HM2 (and HM1 if it is installed)
- Create a new windows user in the Control Panel > User Accounts. Make sure it is an Administrator account and has no unique characters in the name (only characters from EN Alphabet)
- Reboot the PC
- Log in to the new windows user account

- Now Delete C:\ProgramData\XHEO INC\SharedLicenses\ Holdem Manager 2.lic (XP Users can find the file at C:\Documents and Settings\All Users\AppData\XHEO INC\SharedLicenses\ Holdem Manager 2.lic)*
- Reinstall HM2 - http://www.holdemmanager.com/downloads/Holdem_Manager_2_Setup.exe
- and try to register again.
- If that works, you can reboot, log in to your normal user, and test to make sure everything works before you delete the temporary user.

*You will need to show system and hidden files. See this tutorial for showing system and hidden files:

http://hm2faq.holdemmanager.com/questions/832/How+are+Hidden+Files+Viewed+in+Windows%3F+