ads
08-31-2010, 10:31 AM
I recently had some problems with my laptop that required it to be reformatted, and was in the process of rebuilding my database (by reimporting old HHs that I had backed up to an external hard drive) when my new database encountered some problems. It first began when I wasn't able to start hem up - I got an error message each time. After a couple of restarts, I was able to get back in but noticed that large chunks of my database were missing - for example, the number of players I had stats on was now roughly 14,000 when it had been >250,000 before the error messages appeared.
I checked to see if my own personal hands were still in the database and, thankfully, they appeared to all be there. These were my main concern and I was glad that they appeared to survive the problem. However, when I attempted to import hands into my database (both old HHs saved in folders, and auto-importing new hands I just played), it would list 100% of them as import errors and they wouldn't be added to my database.
I thought it might be a good idea to export the HHs of this database into my hard drive and reimport them into a new database. However when I attempted to import them, after a while I got the error message:
ERROR: XX002: index "handhistories_pkey" contains unexpected zero page at block 0.
When I attempted to export the hands into my hard drive in smaller chunks (via the hands tab, right click -> export hands to hard drive), I got the same message. In fact, it appears that I cannot view or replay any hand history in my database, simply nothing happens when I try to.
I have since created a new database for my recent hands and have been using this with no problems so far. I would really like access to my old hands and to somehow have my new and old databases come together. If there's a way of getting the hand histories from my old database and then reimport them onto my new one that would be ideal. It is mainly my own hands that I am concerned about.
Regrettably I have deleted many of the hand histories that I had backed up - since they were in various folders and unorganised, I deleted them as they were imported into my new database - with the intention of exporting all the HHs once the database had been restored and backing them up that way, before the original problem surfaced. Unfortunately I don't know what the original error message said as it only appeared 2-3 times before holdem manager started again.
I hope I have described everything clearly and we can somehow resolve this - if there's any further details required please let me know.
Thanks, ads
I checked to see if my own personal hands were still in the database and, thankfully, they appeared to all be there. These were my main concern and I was glad that they appeared to survive the problem. However, when I attempted to import hands into my database (both old HHs saved in folders, and auto-importing new hands I just played), it would list 100% of them as import errors and they wouldn't be added to my database.
I thought it might be a good idea to export the HHs of this database into my hard drive and reimport them into a new database. However when I attempted to import them, after a while I got the error message:
ERROR: XX002: index "handhistories_pkey" contains unexpected zero page at block 0.
When I attempted to export the hands into my hard drive in smaller chunks (via the hands tab, right click -> export hands to hard drive), I got the same message. In fact, it appears that I cannot view or replay any hand history in my database, simply nothing happens when I try to.
I have since created a new database for my recent hands and have been using this with no problems so far. I would really like access to my old hands and to somehow have my new and old databases come together. If there's a way of getting the hand histories from my old database and then reimport them onto my new one that would be ideal. It is mainly my own hands that I am concerned about.
Regrettably I have deleted many of the hand histories that I had backed up - since they were in various folders and unorganised, I deleted them as they were imported into my new database - with the intention of exporting all the HHs once the database had been restored and backing them up that way, before the original problem surfaced. Unfortunately I don't know what the original error message said as it only appeared 2-3 times before holdem manager started again.
I hope I have described everything clearly and we can somehow resolve this - if there's any further details required please let me know.
Thanks, ads