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
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.