PDA

View Full Version : Database error suggests reindex



reecelights
08-15-2008, 11:58 AM
Got this error first when I tried opening PGAdmin to backup my DB, then when I tried opening Database Management in HM.

The error suggests REINDEXing my DB, but I can't figure out how one does that.

I am running Vista. and have downloaded 1.06.01u.

Thanks,
Chuck

http://i189.photobucket.com/albums/z281/reecelights/PGDBError.jpg

fabio
08-15-2008, 12:56 PM
Please use this guide to login with pgAdmin, but as you can see on the last screen, click on maintenance. There you will find the reindex function

http://208.109.95.123/faq/afmviewfaq.aspx?faqid=21

reecelights
08-15-2008, 03:10 PM
It appears the problem is actually that I can't connect to the server. The error is keeping me from being able to run any reports.

This is the error I get when I double click to open the database:

http://i189.photobucket.com/albums/z281/reecelights/PGDBError2.jpg

reecelights
08-15-2008, 05:36 PM
Any guesses on how to solve this? I have tried running a system restore and using the old version, but the problem seems to be in my database. Any help on how to access the database so I can repair it would be appreciated.

I can't run any reports and would really appreciate being able to use HM when I play tonight.


Thanks.

fabio
08-15-2008, 05:54 PM
Hi,

I think it would be the best when I look into it via Teamviewer. When do you have time for this? Please email me at fabio@holdemmanager.net

Rvg72
08-16-2008, 01:03 AM
Any guesses on how to solve this? I have tried running a system restore and using the old version, but the problem seems to be in my database. Any help on how to access the database so I can repair it would be appreciated.

I can't run any reports and would really appreciate being able to use HM when I play tonight.


Thanks.

Reece, it does look like the DB is damaged. I just send you an e-mail with some information on recreating one of the indexes so we'll see if that gets you back up

Roy