PDA

View Full Version : Keep getting this error



jpatch
10-16-2009, 04:32 PM
error xx001 invalid page header in block 112 of relation "playerhandscashkeycolumns_hero_idx1"

how do i fix that?

fozzy71
10-16-2009, 07:16 PM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Try to fix that index: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or reindex the whole DB: start > programs > postgresql 8.x > pgadmin > right-click > connect > right-click > maintenance > reindex

If that doesnt work you will need to try a new DB:

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21