PDA

View Full Version : Since database-reinstall: duplicate hands, but others missing



Melvilleq
02-02-2010, 07:30 AM
I changed computer, saved and reinstalled my database. System: XP professional. Testing quite a mess: HUD works fine, but after playing in the reports tab, every second or third hand exists two or even three times (see screenshot). Others are missing (I guess, session was 3 buy-ins up, HEM says I lost 50BB).

I saved/installed the database following the instructions of the FAQ.

One thing I don't know: old database was running on Postgres 8.3, new on postgres 8.4 (Your combo installer just did this).

Anybody can help me out? Appreciate it!

Screenshot of desaster:
http://img714.imageshack.us/img714/4224/bildschirmfoto20100202u.jpg

netsrak
02-02-2010, 09:46 AM
When restoring a database from an old backup you need to create a new empty database via pgadminIII using the same coding as the original database.
It is not possible to restore the backup to a database created by Holdemmanager.

Melvilleq
02-02-2010, 12:50 PM
When restoring a database from an old backup you need to create a new empty database via pgadminIII using the same coding as the original database.
It is not possible to restore the backup to a database created by Holdemmanager.
Sorry, what does: the same coding mean? What actions do I have to take from where I am now?

fozzy71
02-02-2010, 02:04 PM
If your backup was created with 8.3 you need to install the same version to do the restore.

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
3) Reboot.
4) Download and unzip this file, and run the .msi installer within the extracted folder. http://www.holdemmanager.com/downloads/postgresql.zip
5) Restore your .backup file using the steps in this FAQ - http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database

When you get to step 4 and 5 of Restoring Your Database you need to set the encoding to SQLASCII or WIN1252 if the SQLASCII doesnt work right.

Melvilleq
02-03-2010, 03:16 PM
Thanks a lot, fozzy, did everything above, looks good.