PDA

View Full Version : HM1 not importing + other issues



guidosuller
12-15-2013, 09:33 AM
Hello, today something weird occured. HM stopped working and as I reopened it, it prompted me to select a database, asked to update my license, etc. as if it was the first time after an installation, but it was not the case. I dont have my stats in the "reports" tab, and all config is gone. Some error msg about the config file corrupted i got but I dont remember it, apparently there's a new one created.

Well, what is more, I now cannot import any hands. I choose the folder where my Stars' hands are and when clicking OK it says "0 files found" and does not import anything. Tried to do it archive by archive, did not work.

Any ideas? I would like to get it as it was before this problem. I tried "system restore" so far, nothing happened.

I have the latest version. Thanks for advice.

guidosuller
12-15-2013, 09:37 AM
Found this in an SQLerrors.txt file created today:

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: RELEASE SAVEPOINT beforegame;

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: RELEASE SAVEPOINT beforegame;

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: RELEASE SAVEPOINT beforegame;

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: RELEASE SAVEPOINT beforegame;

The Error: ERROR: 57014: canceling statement due to user request

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: RELEASE SAVEPOINT beforegame;

The Error: ERROR: 57014: canceling statement due to user request

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;

fozzy71
12-15-2013, 11:14 AM
That looks like a corrupt database and/or damaged postgresql installation.

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate_Release_1.13.02_10Oct2013.exe

1. Note your database connection settings from the database management (server name: 127.0.0.1; port number: 5432; login name: postgres; password: postgrespass)
2. Close holdemmanager
3. Go to the folder config in the holdemmanager installation path
4. Rename the file holdemmanager.config to holdemmanager.config.corrupt or sth. like that.
5. Under Vista make sure that UAC is switched off or check the administrator settings for holdemmanager.exe, hmhud.exe and dbcontrolpanel.exe under properties->compatibility
6. Restart Holdemmanager
7. Holdemmanager reinstalls and displays some messages and warnings
7a. A new holdemmanager.config file is generated
8. Reconfigure your database connection
9. After successful start reconfigure your Auto-import settings
10. Table manager should start again.


If you continue to have problems, try the following -

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.

*Make sure you export/backup everything before deleting the old DB - http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips



If none of that helps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator


net user postgres /delete

4) reboot.
5) Install PostgreSQL 8.3.9 from this link - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

guidosuller
12-15-2013, 02:05 PM
Thanks, I'll keep this post in favs if not deleted sometime, I managed to solve the problem copying a whole HoldemManager folder I had as a backup and replacing it. Seems that the Holdemmanager.config file was the problem :P

fozzy71
12-16-2013, 09:27 AM
You are very welcome. Thank you for letting us know it solved your problems. I am glad it was the first thing I suggested and you didn't have to create another new database or reinstall postgresql.

Good luck at the tables. If you have any questions or problems do not hesitate to ask us.