PDA

View Full Version : error message



pekingtokyo
11-03-2009, 03:43 AM
I got this error message:

An error occurred while retrieving the imported file list: ERROR: XX002: index "importedfiles_idx1" contains unexpected zero page at block 405

anyone know how to fix this?

fozzy71
11-03-2009, 11:33 AM
You can try to fix that specific index - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try to reindex your entire DB thru PGAdmin > Maintenance


If neither option works you will want to follow the stickies to backup all of your current DB and then create a new DB.

How to backup your current DB manually via exports:

http://www.holdemmanager.net/forum/showthread.php?t=20754


*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, 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. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21