TRIAL VERSION - Unable to execute query

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Re: TRIAL VERSION - Unable to execute query

Postby WhiteRider » Sun Aug 10, 2008 3:35 pm

WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: TRIAL VERSION - Unable to execute query

Postby pokerpro » Sun Aug 10, 2008 3:50 pm

Fantastic, WR.

Problem solved!

Should I continue to leave the
"zero_damaged_pages = on"
command in that text file?
pokerpro
 
Posts: 30
Joined: Tue Aug 05, 2008 2:17 am

Re: TRIAL VERSION - Unable to execute query

Postby WhiteRider » Sun Aug 10, 2008 3:54 pm

In that post it says "After the error has been resolved, it is highly recommend that you go back into your PostgreSQL config file and remove the line we just added."
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: TRIAL VERSION - Unable to execute query

Postby pokerpro » Mon Aug 11, 2008 3:09 am

Although it was resolved and working perfectly yesteday, the problem has re-emerged today.

I applied the same solution but this time, I am left with the error message and PT3 is basically non-functional.

I am very concerned that I may need to revert back to PT2 if PT3 non-functionality persists.

Please advise.
pokerpro
 
Posts: 30
Joined: Tue Aug 05, 2008 2:17 am

Re: TRIAL VERSION - Unable to execute query

Postby pokerpro » Mon Aug 11, 2008 3:18 am

I have never had these problems with PT2 and its coming to the stage that I am very disappointed by PT3.

It was working fine under the trial, but a few days into the purchase it is totally non-functional.

I don't mind if I lose my hands, but I really do need to get PT3 working. I cannot afford to play without a read on opponents.
pokerpro
 
Posts: 30
Joined: Tue Aug 05, 2008 2:17 am

Re: TRIAL VERSION - Unable to execute query

Postby pokerpro » Mon Aug 11, 2008 3:39 am

I shut the computer down, restarted and re-did the process yet again.

This time it is working (again).

I really don't know what is going on. PT3 switches from functionality to non-functionality in a random manner.

Please advise.
pokerpro
 
Posts: 30
Joined: Tue Aug 05, 2008 2:17 am

Re: TRIAL VERSION - Unable to execute query

Postby WhiteRider » Mon Aug 11, 2008 4:22 am

There must be a problem in this database - you could create a new database and re-import into it.
(Have you manually entered any tournament summaries into this DB? Those aren't exported properly at the moment.)

If you still have the original HH files in the 'move processed files to' folder, manually import them; otherwise use the database management screen to Export your hands, then re-import them into a new database.

I'll try to get Derek/APerfect10 (who wrote the guide you've used) to have a look at this thread.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: TRIAL VERSION - Unable to execute query

Postby APerfect10 » Mon Aug 11, 2008 10:58 pm

After setting zero_damaged_pages on, are you experiencing crashes or frequent lost connections to the database?

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm

Re: TRIAL VERSION - Unable to execute query

Postby pokerpro » Tue Aug 12, 2008 11:26 am

Hi Derek

It worked perfectly yesterday and also today so far!

The problem I was having was lost connections to the database, but its been stable for a couple of days (today and yesterday).
pokerpro
 
Posts: 30
Joined: Tue Aug 05, 2008 2:17 am

Re: TRIAL VERSION - Unable to execute query

Postby fccman » Wed Aug 13, 2008 1:06 pm

I had this same problem today using version 3 build 2 running vista home premium. I simply opened "services.msc" and restarted the postgre service and all was then fine after the service was restarted. Now the last tournament I played on full tilt when I got knocked out right on the bubble I immediately shut down the full tilt client much faster than normal possibly having something do with it I dunno but that was the sequence of actions. The postgre service was showing that it was running when I restarted it anyway.
fccman
 
Posts: 1
Joined: Tue Aug 12, 2008 3:58 am

Previous

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin