Major Database problem

[jsampras1]

PT3 has been working fine since i got it. Peroidically i get error messages and then it shuts down, but usually it just starts up fine after that. I didn't even do anything with PT3. I just opened it, started importing files, and started playing.

This last time, something got screwed up with my DB. It shows no stats for ring games, and area that says player just says "unable to execute query: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id"

There's no function to repair database, so i don't know what to do. I have hundreds of thousands of hands on that, and tens of thousands from May that i don't have HH's for any more. Is my DB just history? Is there any way to fix it?

[WhiteRider]

Please enable logging, reproduce the problem and submit your PokerTracker.log to the Support system , and link to this thread.