Ongame SQL error

Any support related posts should go here.

Ongame SQL error

Postby sandstorm » Mon Aug 04, 2008 11:35 am

I run XP and installed SQLite today as I have done many times before on this computer. Started a new database file at ongame without luck. Any ideas?

*********************************
PT Version: 2.17.02a
Error Date: 08/04/2008 17:25
Database Error: 1
Error Text: Select error: SQLSTATE = S1000
no such table: HAND (1)
DataObject: d_gr_proom_hands_new_2
Syntax In Error: SELECT DISTINCT HAND.ID, DEALERPOSITION, RAKE, POT, HAND.TABLEID,
ENDEDATYEAR, ENDEDATMONTH, ENDEDATDAY, ENDEDATHOUR, ENDEDATMINUTE, ENDEDATSECOND,
NAME, 0 AS ROWID,
ENDEDATYEAR || CASE WHEN ENDEDATMONTH < 10 THEN '0' || ENDEDATMONTH ELSE ENDEDATMONTH || '' END ||
CASE WHEN ENDEDATDAY < 10 THEN '0' || ENDEDATDAY ELSE ENDEDATDAY || '' END ||
CASE WHEN ENDEDATHOUR < 10 THEN '0' || ENDEDATHOUR ELSE ENDEDATHOUR || '' END ||
CASE WHEN ENDEDATMINUTE < 10 THEN '0' || ENDEDATMINUTE ELSE ENDEDATMINUTE || '' END ||
CASE WHEN ENDEDATSECOND < 10 THEN '0' || ENDEDATSECOND ELSE ENDEDATSECOND || '' END AS TIMELINE
FROM HAND, POKERTABLE
WHERE HAND.TABLEID = POKERTABLE.ID
AND GAMETYPE = 0
AND MONEYTYPE = 1
AND ENDEDATYEAR || CASE WHEN ENDEDATMONTH < 10 THEN '0' || ENDEDATMONTH ELSE ENDEDATMONTH || '' END ||
CASE WHEN ENDEDATDAY < 10 THEN '0' || ENDEDATDAY ELSE ENDEDATDAY || '' END ||
CASE WHEN ENDEDATHOUR < 10 THEN '0' || ENDEDATHOUR ELSE ENDEDATHOUR || '' END ||
CASE WHEN ENDEDATMINUTE < 10 THEN '0' || ENDEDATMINUTE ELSE ENDEDATMINUTE || '' END ||
CASE WHEN ENDEDATSECOND < 10 THEN '0' || ENDEDATSECOND ELSE ENDEDATSECOND || '' END > ?
ORDER BY ENDEDATYEAR ASC, ENDEDATMONTH ASC, ENDEDATDAY ASC,
ENDEDATHOUR ASC, ENDEDATMINUTE ASC, ENDEDATSECOND ASC ;
*********************************
sandstorm
 
Posts: 1
Joined: Mon Aug 04, 2008 11:33 am

Re: Ongame SQL error

Postby ptrack pat » Mon Aug 04, 2008 1:27 pm

What email was used to purchase PT2?

Are you able to see the stats from the Ongame lobby window menu Statistics > Show Session Browser window?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 4 guests