thousands of import errors?

[infurrrno]

I'm getting thousands of import errors when I try and import to my db. Is there anywhere I can check a log and find out what is causing them? Causing me much frustration

cheers

[netsrak]

We have some logging in the importing subfolder of your Holdemmanager installation path.

Which site are the hands from?
Which gametype?
Mined hands?
Which hm version?
What happens if you create a new database and import some of the hands via import file or import from folder?

[infurrrno]

We have some logging in the importing subfolder of your Holdemmanager installation path.

Which site are the hands from?
Which gametype?
Mined hands?
Which hm version?
What happens if you create a new database and import some of the hands via import file or import from folder?

stars, ft and ub.

yes, mined hands. (cash nl100 - nl1000)

version 1.11.05d

I havent tried a new db but will get back to u.

[infurrrno]

I found my import errors log, it is reading the following sort of thing;


C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1710.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1711.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1712.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1713.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1714.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1715.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1716.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1717.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1718.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1719.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.172.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Robbie\Desktop\hh's 2\FT_NL400_072010_part2\2212SH2010.07.1720.txt

...You get the idea. I can't make sense of it though.

[infurrrno]

I read every other thread on this particular error. Haven't found a common solution yet. Here is what I have done so far;

Updated to latest version 1.11.06a (still errors)

Tried importing subfolders rather than parent folder (still errors)

Vaccuumed etc (still errors)

***Creating new db worked.

Once again thanks for the great support!

[netsrak]

Your original database is damaged. If a reindex via pgadminII->maintenance doesn't help you need to reimport all your hands into a new database.

And you should do regular database backups in future.