PDA

View Full Version : cant import any hands



justdoit
11-03-2009, 07:48 AM
hi,
had beta 42 before

now with 1.9 i cant import any hands anymore.
alyways have only import errors. few hours before i was able to import.
have this sql error:
The Error: error: 25P02: - current transaction is aborted, commands ignored

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;

:(

fozzy71
11-03-2009, 12:20 PM
*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

justdoit
11-19-2009, 07:07 PM
hi,
i'm experiencen the same problem over and over again.

i create a fresh db. import my hands from exported_hands folder from an older db.
then i import lots of hands from one folder.
after restarting hm then i cant import any hands. only get import errors. even after purging the hands.

any ideas?
bye

fozzy71
11-19-2009, 09:19 PM
What sites are the exported_hands from? Which Operating System, Firewall, and Anti-Virus are you using?

I am starting to think a clean reinstall of postgresql 8.4 may be the best thing.

If you decide you want to do that, you should make sure you back everything up first. Export any new hands, notes, and tourney summaries. Then use these instructions to reinstall a new version of postgresql. http://forums.holdemmanager.com/showthread.php?t=20755