Page 1 of 1

importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 11:45 am
by bigvb
so im trying to import a ton of datamined hands, during the loooong importing process a error window appears like every 2 mins (along with that dull windows thud sound). ive uploaded screenshot.

I repaired my db after importing last bunch and it seemed fine until about an hour into importing. I also dont get this problem when importing small
amounts of hands.

the most annoying thing about it is that the importing process is paused when the error message appears, i left computer on all night to import all the hands it its done almost none because error message came up (prob just after i went to sleep)

http://i42.photobucket.com/albums/e304/bigvb/prob.jpg

(btw wtf do i always have to login twice to post on pt forums)

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:19 pm
by bigvb
it imported like 2000 of 300,000 hands and says goto error messages to see errors but there are no error messages there.

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:22 pm
by bigvb
ok now i close pt, open it and try to import like 200 hands from my morning ipoker session it says no hards are there. i goto ipoker folder and hands are gone. now ipoker always downloads my hands, its v unlikely their system didnt do it as it was working 10 hours ago. im fuessing pt has moved hands but not imported

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:43 pm
by ptrack pat
See this FAQ #2
viewtopic.php?f=30&t=1377

If you have that many hands then you should convert to PostgreSQL because the database is probably full.

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:46 pm
by bigvb
cheers pat ill try converting to sql. What is the limit for access DB in pt3 and what is the limit for postgres in pt3

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:53 pm
by ptrack pat
Access has a 2gb file size limit which is around 220,000 hands, more if you play short-handed.

PostgreSQL has no file size limit at all. PT3 will use only PostgreSQL so there isn't going to be issues of db's getting full anymore...unless you run out of hard disk space.

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 12:57 pm
by bigvb
ok and finally are there any security issues with postgres, my pw is like super simple and username is obvious, postgreSQL is not a nice loophole for hackers is it?

Re: importing problems 2.17.01g

PostPosted: Thu Mar 27, 2008 1:23 pm
by ptrack pat
No, I've never heard of any problems like that.