PT problem yet again

[the machine]

wont let me inport any more. had the same problem last night then i did a one step compact and it worked fine for teh rest of teh night. had same problem today and keeps saying that there is an error.

nothing is documented in the error log.

says records can not be added. no insert permission on hand histories.
the hand trying to be imported pops up in the error box and the whole hand history is included in it.

then says 0 hands we imported.


any ideas?



ive done another compact and repaired the DB as well

[CudjoeBill]

How big is the DB (ptrack.mdb)? Access (the default PT DB) has a limit of 2GB. If you compacted and then it worked for a while, you might be close to 2GB. Check out the PT Forums for how to upgrade to PostgreSQL or to create another DB.

[the machine]

where do i find the ptrack.mdb file to find out how big it is. i do have alot of data mined hands so its very likely that it may be too large

[fozzy71]

Computers 101

C:\Program Files\Poker Tracker V2

[the machine]

i remember having to do this before because my db was too large. installing sql now but have a question, can either you fozzy if you know about it or cudjoe PM me you aim so i can ask some questions rather then clutter up the forum plz. thx

[the machine]

nm figured out what i needed to know.

[CudjoeBill]

Its really late, Dude. Heading off to bed. But go here and follow PT Pat's instructions. They should get you up and running. If you run into problems, the PT Forums are filled with posts about setting up PostgreSQL.

CB

P.S. Follow all the instructions. Don't skip steps 2-4 (a common problem). Let us know how it goes.

[the machine]

thanks cudjoe. i did all that and basically just had one question. the page shows one step that says leave it all default but then when going through the process the installation thing has enable contrib module and has 2 things checked. during instal the default was adminpack. which isnt on his instal help page. i left it at the default and am converting now.

[the machine]

ok well i assumed that my problem was because my DB was too large so i dl'd postgresql and converted the db im using to postgres db.

im still getting the error message when i import. i have no clue what is wrong

this is the original message before i converted but i am still getting the same error message when i try to import


Shot at 2007-07-24





ughhhhhh nm just ralized i didnt open the new postgresql db when i was doing the import hence the same error message. im good to go now.

[the machine]

ok probelm

when i click on a hand in hte new postgresql DB the hand history box pops up with nothing in it. new hands that have been imported post conversion show in the hand histoy box but the converted ones dont show up.

when i go into the old access db and click on any hand this is the message i get

Error retrieving hand history from the database!

-1907 - SQLSTATE = 42000
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'HAND_HISTORIES'.


what do i do????