PDA

View Full Version : I didn't do anything...



fraabru
05-24-2009, 11:47 AM
so my HEM is just royally screwed....

when i go to the cash games tab it gives me
ERROR:XX001 invalid page header in block 57 of relation 'playerhandscashmisc_hero_idx1

when i go to graphs under cash games tab
formatting chart object reference not set to an instance of an object...

i have a mac and run parallels....
i literally use 2 programs... HEM and pokerstars....
i have 1.08.01

what gives?

morny
05-24-2009, 11:52 AM
Can you try repairing the index http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

fraabru
05-24-2009, 11:56 AM
Can you try repairing the index http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

tried that gives invalid page header block 271

do i have to do the whole reimport hands thing?

morny
05-24-2009, 11:58 AM
Yeah youll need to export and reimport, if its too corrupt to let you export youll need to import your archived hands instead

Please export your hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database

fraabru
05-24-2009, 12:03 PM
Yeah youll need to export and reimport, if its too corrupt to let you export youll need to import your archived hands instead

Please export your hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database

when i try to export it says invalid page header in block 448 of relation 'pokerhands' then it said they have been exported... i don't get it...


how do i import archived hands?

and what causes this... how do i prevent this in the future??

fraabru
05-24-2009, 12:20 PM
so i need to make a new database and import archived hands into the new database?

is that correct?

and if it is how do i import archived hands? do i want to import archive hands from a folder?? which folder?

morny
05-24-2009, 12:31 PM
Yes thats correct, you would have setup the archive folders yourself, it would be C:/HMarchive by default or else a folder you specified yourself. If your not sure try doing a search for a username and take note of the folder where most of the files are

The 2 most common causes of this problems are 1) powering off your computer or having your computer lose power while the database is doing something and 2) an old drive with bad sectors on it. Basically what happens is a small portion of a file gets slightly corrupt and then when you reboot and windows goes into that checkdsk procedure it finds the bad section and, thinking it is doing a good thing, removes it. Postgres then loads the table and a portion of it is gone so it doesn’t like that and blocks access to the entire table. Normally when this happens it is on a completely useless file that you'll never even notice is now gone and quite often it will happen to an index in the DB which can easily be rebuilt but in your case it happened to one or more of the tables.

So, to protect against this

1) keep you hands histories in case you do need to reimport
2) use a power bar and avoid hard shutdowns (when you flick the power switch on the pc)
3) if your drive is old consider replacing it with a new one. They are cheap and much faster now than even a few years ago.

fraabru
05-24-2009, 01:06 PM
ok... i imported and its the wrong folder...

getting a little miffed.... i think i imported the one from my mac and not pc...

i think i found the right one tho...

but now i have like 5 databases... sigh.... can i delete the ones that aren't right? i didn't see an option... and i am importing right now...

should i change my folder that contains my Hand History's to C:/HMarchive so it matches up with you guys?? or does it matter?

btw thanks for all your help... you guys have great support... glad i bought your product... even tho it can be a royal pain in the arse sometimes :)