Fatal Error *need help*

[leobidu]

Does anyone know how to fix this Error in the image?

[Flag_Hippo]

Unfortunately that error indicates the database has been damaged and this can happen if there was a computer crash/powercut while the database was active although it can also be caused by faulty disk sectors or running PC 'cleaning' software. You can try a reindex to repair it via the 'Database > Database Management' window, select the affected database, then click 'Housekeeping > Reindex'. After the housekeeping is complete you should click your database again then 'Rebuild Cache -> Full Cache Rebuild' but if that doesn't fix it you will need to create a new database.

[sp00ky]

Hi,
I created a new Database imported about 4 k hands from directory.
Then I opened some tables started "get hands while playing" and for every hand there is a very long red error message like: ... Error: : Unable to import hand ). Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: schema "pph" does not exist CONTEXT: SQL statement "SELECT chps.id_player, chps.id_gametype, chps.id_limit, chs.cnt_players,((case when( lookup_positions.flg_sb....

what can I do?

[Flag_Hippo]

That error means you have statistics which use additional tables which need to be added to the database outside of PokerTracker 4. You will need to contact [email protected] to find out what you need to do to your database for those stats to work. In the meantime you can also turn off your Premium HUD by disabling the "Configure -> Options -> Download Premium Content" option and then restarting PokerTracker 4.

[sp00ky]

Hi,
I did what you suggested, but it did not solve the problem. got still errror message : ...Reason: Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: schema "pph" does not exist CONTEXT: SQL statement "SELECT chps.id_player, chps.id_gametype, chps.id_limit, chs.cnt_players,((case when( lookup_positions.flg_sb) then 0 else (case when( lookup_positions.flg_bb) then 1 else (case when( lookup_positions.flg_ep) then 2 else (case when( lookup_positions.flg_mp) the ...

[Flag_Hippo]

As I mentioned in my previous reply that error is due to your ProPokerHUDs content so you'll need to contact them to resolve it. If you have disabled the premium content then try creating a new database and that should allow you to use PokerTracker 4 in the meantime:

Guide: Creating A New Database in PokerTracker 4