Unknown Token Encountered Error - Produced somewhat randomly

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Unknown Token Encountered Error - Produced somewhat randomly

Postby gkeuler » Tue Apr 05, 2011 3:16 pm

I was making some cosmetic changes (report width/name etc) to this previously working stat when it started producing this error, all of the columns are in the right place, Any idea whats causing this error?

Unknown Token Encountered: #3rd

if (flg_f_saw=false, '',if (flg_blind_b AND str_actions_f='BF','H Fold',if (flg_blind_b AND str_actions_f='BR','H Raise, ' + format_number( amt_f_raise_made, 0, false, false ),if (flg_blind_b AND str_actions_f='XF','H Fold',if (flg_blind_b AND str_actions_f='XC','H Call',if (flg_blind_b AND str_actions_f='XR','H Raise, ' + format_number( amt_f_raise_made, 0, false, false ),if (flg_blind_s AND (str_actions_f='BF' OR str_actions_f='BR' OR str_actions_f='BC' OR str_actions_f='RF' OR str_actions_f='RC' ),'V Raise, ' + format_number( amt_f_raise_facing, 0, false, false ),2)))))))
gkeuler
 
Posts: 27
Joined: Fri Jan 29, 2010 5:17 am

Re: Unknown Token Encountered Error - Produced somewhat rand

Postby kraada » Tue Apr 05, 2011 3:50 pm

What's the rest of the error say? It should tell you what token is causing the problem.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests