Import Issues

[Flag_Hippo]

Also do you get one, both or neither of the errors from your first post if you try and rebuild the cache on a new database?

[ZakWray]

Okay so my interpretation of the second thread you linked is there is no solution to the current issue i have? It would be nice just to go back to how things were, i mean i did not change anything or add anything re: stats for this to happen. I simply use a custom HUD which I have used for years and I know its the chosen HUD which many regulars use to play the tournaments i play and afaik nobody else has had this issue.

At the moment I have created a new database and it works fine. I do not get any errors when i do a full cache rebuild. I don't see what the difference is between my old and new database?

[Flag_Hippo]

Since you are not getting the same errors on the new database that indicates a database issue with your original database. You can try a reindex via the "Database > Database Management window" - to do that select the affected database, then click "Housekeeping > Reindex". After the housekeeping is complete you should try a full cache rebuild again where hopefully you won't get the same errors again but if you do then I would recommend continuing with the new database instead.

[ZakWray]

I tried this overnight and I get the second error message after doing the reindex: I also get the same message after the vacuum is finished too so it repeats twice but I am no longer getting the first error message

[ZakWray]

..although i guess that only happens when I try the full cache

[Flag_Hippo]

The first possible reason of that error is a result of data corruption from a computer crash/powercut while the database was active although it can also be caused by faulty hardware. If the reindex wasn't able to fix the error then I recommend continuing with the new database instead.

[ZakWray]

Yeah i think i have had a couple of crashes/cuts lately so probably is the cause. Could there be a solution/fix to this at a later date? I will continue with the new database then, thanks for your help.

[Flag_Hippo]

Unfortunately if the reindex didn't fix the corruption there isn't another solution other than starting a new database.