Error blind not a valid number for game.

[kuksi_pete]

What does this error mean? When I try to import hand history it say this, "error blind not a valid number for game" and the hand histories are show blind 0 001.00-0 002.00 for for instance 1/2$ blind games...

Error blind not a valid number for game.


*********************************
PT Version: 2.17.01g
Error Date: 03/18/2008 02:04
Database Error: 11
Error Text: Select error: SQLSTATE = S1000
database disk image is malformed (11)
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 ;
*********************************

*********************************
PT Version: 2.17.01g
Error Date: 03/18/2008 02:04
Database Error: 11
Error Text: Select error: SQLSTATE = S1000
database disk image is malformed (11)
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 ;
*********************************

[ptrack pat]

That looks like a regional settings issue
viewtopic.php?f=30&t=1366

As to the other error, On the Prima auto-import window, click the Configure Database Files button. On the next window, make a note of the folder location of the GameHistory.dat file that you are pointing PT to read from.

Close PT and the poker site. Go to this folder and rename the GameHistory.dat file to GameHistory_bad.dat. Then open the poker site software and play another hand. They should create a new GameHistory.dat file for you to continue to import from.

[9c0uoU]

[quoteyui]Error blind not a valid number for game[/quoteyui]

If this is on Party I have same, I think it may be because there are no curency symbols ($) in the HHs

[urlyui]http://forumserver.twoplustwo.com/showpost.php?p=3182784&postcount=303[/urlyui]

PartyGaming Build 120/119 jan 31 2008

[ptrack pat]

He's not playing at Party.

Are you using the latest patch?? v2.17.01g? If so, you need to be.
http://www.pokertracker3.com/products/PTH/download.php

[ScanX]

Hi,

I've got the latest patch, I've got regional settings set correctly and I've renamed my gamehistory.dat...yet the same error keeps coming back.

What am I missing ? :(

Thanks in advance

ScanX

[ptrack pat]

Get this "2.17.01i" patch and try it again...
http://www.pokertracker3.com/products/P ... 21701i.exe

[ScanX]

I've been using it for 1 hour now and the error didn't happen anymore !

Pokertracker support = 5 stars

Thanks again for always being so fast

ScanX