PDA

View Full Version : Erro 42P01 after formatting and reinstalling



mic
09-13-2013, 05:08 AM
Hi, yesterday i have formatted my pc backing up the hm1 database before. Today i have reinstalled hm1 (latest version) and restored the database, but everytime i try open hm1 i get a message saying it wants to "make some database changes to enable you to delete individual hands and/or sessions..."

If i select "Update database" i get this error message:

ERROR: 42P01: relation "playerhandscashkeycolumns" does not exist

if i select "ask again later i get this error message:

An error occurred while updating your DB (Tourney Number):
ERROR: 42P01: relation "playerhandstourneykeycolumns" does not exist
Please close down any progrmas accessing the database and relaunch Holdem Manager

I already tried the various soluitons for this problem i have found in this forum but i cant make it work.
I have reinstalled and created a new database and reimported my hm database backup but even the new database does not work. I even deselected all files while restoring the database (config, filters...) just reimporting the database file.

What can i do? I suppose the backup file is corrupt, but there is no way of at least recover my hands from the database and reimport them in a non corrupt one?

I have lots of hands and really dont want to lose them.

Please help

fozzy71
09-13-2013, 03:55 PM
It sounds like you made a backup with an old version of HM1 and the newer version you installed needs to update the database which is failing. You might want to try rolling back to an older version of HM1 and restore the backup file again and then export the database hands/information manually so you can then update your software and recreate the database manually.

You can download older versions of the software here - http://faq.holdemmanager.com/questions/426/Download+Links+For+Past+Builds

Once you have restored the database you will want to back it up manually by exporting all the information:

Export your Hand Histories
http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback ' Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

Then can you create a new database http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database

Finally reimport all your hands/notes/summaries into the new database


All original hands that are auto-imported get moved to an archive for performance reasons. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).

mic
09-13-2013, 05:10 PM
I have done that, uninstalled hm with revo uninstaller and then installed the oldest version in the page you linked (1.11.01b) but i keep getting the same error message.

Patvs
09-13-2013, 11:43 PM
The message is the error of a corrupt backup. (which is common if you backed up a corrupt database)

You have no backup of your old archive folder with all the original handhistory files?
Did you play most of your hands on Full Tilt or PokerStars? If so, email their support and request the handhistories for everything you've ever played.

Then import them into a new empty database.




---


Is it possible you created the backup in an old version of PostgreSQL for example SQL 8.3?
And you're now using 8.4? Or you used 8.2 in the past? Did you create the backup in pgadminIII, or in HM1? You may be able to still use the backup file, if you restore it, using the same version of PostgreSQL that was used to create the backup.