PokerTracker

My old hard drive went a bit screwy. Something about bad sectors. So it was copied (sans a few bad files in my postresql database that couldn't be gotten) onto my new hard drive.

Now, when I try to vacuum/analyze my database I get an error saying:

An error has occurred trying to perform the requested action. The error was:

7 - SQLSTATE = XX002
ERROR: index "game_players_idx_02" contains unexpected zero page at block 337497;
Error while executing the query

Any way to fix this? I tried vacuum/analyze and just plain vacuum.

I'm using PT2 and XP btw. I also had to uninstall and reinstall postgres as I suspect some files from that were missing. I was getting errors that I found out required a reinstall by searching through the forums.

Moved to the PTv2 forum so you can get a more targeted reply.

You can try reindexing as detailed here
http://www.pokertracker3.com/forums/arc ... ex+pgadmin

You can just reindex the GAME_PLAYERS table as that is the one causing the error.

Bit of a problem.

Seems like maybe my only option is to start over? Problem being I don't know how to do that either.

If you just click on the PTPGSQL1 database it should connect to it so you can see the list of tables.

Ah, I'm an idiot.

After reindexing all the tables, the database cached correctly. Looks like a success. Thanks a ton.