Division by 0 SQL error in Player Summary window

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

Moderator: Moderators

Division by 0 SQL error in Player Summary window

Postby DrewOnTilt » Sun Jun 22, 2008 11:32 pm

In a large database of mined hands, I got the following error when looking up a particular player's stats:

[ img ]

What might be the cause of this?

I am running a vacuum/analyze right now.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Division by 0 SQL error in Player Summary window

Postby kraada » Tue Jun 24, 2008 2:43 pm

That might help, also stopping and restarting PT3 might help.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Division by 0 SQL error in Player Summary window

Postby DrewOnTilt » Tue Jun 24, 2008 10:49 pm

Nope. Ran the vacuum/analyze and get the same problem. Ideas? I'm gonna open a support ticket.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Division by 0 SQL error in Player Summary window

Postby WhiteRider » Wed Jun 25, 2008 1:21 pm

Thanks.
Is it just for that one specific player?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Division by 0 SQL error in Player Summary window

Postby DrewOnTilt » Wed Jun 25, 2008 8:17 pm

WhiteRider wrote:Thanks.
Is it just for that one specific player?


I'm going to check that and will let you know when I submit the ticket.

BTW do you have an FTP site set up? My database is huge, and I have a feeling that I'm going to need to send it to you.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Division by 0 SQL error in Player Summary window

Postby WhiteRider » Thu Jun 26, 2008 2:34 pm

Yes, there is an FTP site, but you will be given details of it on your ticket if you need to upload something.
Thanks.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Division by 0 SQL error in Player Summary window

Postby DrewOnTilt » Fri Jun 27, 2008 7:13 pm

FWIW -

I am running Beta 13 but the database was a Build 2 database. Support had me create a new database and then re-import the hands. It was kind of a pain in the arse-hole, but it fixed the problem.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests