PDA

View Full Version : Error XX001



dalailama
03-15-2010, 06:52 PM
I am getting this error message everytime I start the program.


An error occurred when retrieving the player list: ERROR: XX001: invalid page header in block 494 of relation base /16397/16487


Solution?

fozzy71
03-15-2010, 08:15 PM
Your DB is damaged/corrupt. You can try to do a Reindex via the PGAdmin > Maintenance menu. If that doesn't work you will need to try a new DB.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (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 - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (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

dalailama
03-21-2010, 10:01 AM
Still doesn´t work. I get the same message after creating a new UTF DB according to the instructions...

fozzy71
03-21-2010, 02:59 PM
I would reinstall postgresql completely.

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

1) Uninstall PostgreSQL from the Windows Control Panel. (You can delete your old \Postgresql data folder)
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:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

dalailama
03-21-2010, 04:16 PM
Thanks. Will the information in the old DB be gone or is there any way to extract that information?

dalailama
03-21-2010, 07:27 PM
Very strange.. I can not update to the latest beta.

The package was unable to replace the files HMimport.exe, mono.security.dll and npqsql.dll.

The files are not locked so that shouldn´t be a problem.

morny
03-21-2010, 09:57 PM
Please try rebooting and Please install the latest version: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe again, sometimes hm processes dont close properly and the install messes up, so reboot and run the update before you open and other programs