PDA

View Full Version : Import Errors with Ongame



DaniCalifornia
03-20-2009, 04:00 PM
Hi,

I use HEM 1.07 and it used to work really well with almost no hands missing and now I always have Import Errors when I try to import hands. I have no idea what could be wrong cos I don't remember changing anything in my config and now no hands are imported.

In RvG software/holdem manager/SQLErrors.txt I have those errors


The Error: ERROR: XX001: invalid page header in block 3885 of relation "compiledplayerresults_month"

Occurred when running ExecuteNonQuery with this query: EXECUTE CSExecute_month(65765,0,2,-300,0,-0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0); EXECUTE CSPositionActionInsert_month(65765,0,0,0,0,0,0,0,0 ,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 );


any idea?
Thanks

DaniCalifornia
03-20-2009, 04:04 PM
I also had this error when I tried to do some DB managements

http://img15.imageshack.us/img15/668/hemerror.png


edit: With PostgreSQL I also have this error

ERROR: invalid page header in block 49284 of relation "handhistories"

ERROR: invalid page header in block 49284 of relation "handhistories"
when I try to do a maintenance operation.

What do I have to do?
Thanks

morny
03-20-2009, 06:05 PM
Please export your hands from the current 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