''You cannot activate an invalid database''

[bradbellickfbi]

Hi all,

I did something very stupid. My SSID was full, so I decided to cleanup my desktop. I deleted some files in the PostgreqSQL map, which I thought were some old handhistories. I deleted some files from the data map which were from 2017.

But when I started Pokertracker 4 I found out that I could not use my database anymore, I had to create a new database. And when I want to set up my previous database as default it says that it is invalid (see picture).

I am really hoping there is some way I can get back my handhistories. Or did I just fuck it up and are all my hands are gone?

Thank you

[Flag_Hippo]

Unfortunately you have deleted files that made up your database and corrupted it (if the files are in your recycle bin you can try restoring them but that may not work). If you don't have a recent backup then you can reimport from the original hand history files if you have them. By default PokerTracker 4 moves your auto-imported files to your 'Processed' folder which you can access via the 'File -> Open User Data Folder' option:

Guide: Processed Files

If all the hands were not played on this computer originally then you may not have all the hands in your 'Processed' folder but your poker site may be able to provide you with copies.

You are also using a very old version of PostgreSQL (v8.4) which isn't 64bit and reached its 'End of Life' in 2014 so I would take this opportunity to update to a newer version of PostgreSQL (v9.6 is our recommended version) before you import hands again. We have a guide for reinstalling PostgreSQL here.

[bradbellickfbi]

Hi again,

It worked! I want to thank you very much. Your explanation was very clear, I did everything you told me to.

I am really happy now!! Thanks!!!

[Flag_Hippo]

Pleased to hear it.