Hey guys, I figure I'll post here because this forum is pretty active and it might help someone in the future...


I'm getting an error when I upload the .csv priority list created from draft analyzer to the draft utility.

I upload the csv and get the error that stats -- Unknown column '???' in 'order clause'

Just to be clear before I import the priority list I open excel and filter, once the priority list is set there, I upload that .csv into draft analyzer. That's the only way I know how to do it btw.

Does anyone have an idea what is happening? I have no idea. Thanks

If it helps this is the entire error...

There was an error in the list statement:

select selection.player_id, concat('<a href="show_player.php?in_game_id=', player.player_in_game_id, '">', player.player_name, '</a><input type="hidden" name="player_id[]" value="', player.player_id, '"') player_name,selection_priority,position.position_name q288e9ab005ea269aad13dfdb3e111911,player.player_height q1b1ce22d4cd1f2511002d3d97d8227c9,player.player_weight q5da0545ebde3af83381dc55a56655090,player.player_score q84c06bc8cd1737f0aff53d627853f8da,player.player_adj_score q2a2e1b14f0a66e1efc1dd1d643b8e68b,player.player_solec q9a75b5cb74b440c660c72194727275cc,if (player.player_solec <= combine_ratings.combine_low_sole, "color: #0b0; font-weight: bold", if (player.player_solec >= combine_ratings.combine_high_sole, "color: #00f; font-weight: bold", NULL) ) q9a75b5cb74b440c660c72194727275cc_style,player.player_40 qd8ba30889d8c2287c87293790a534583,if (player.player_40 >= combine_ratings.combine_low_40, "color: #0b0; font-weight: bold", if (player.player_40 <= combine_ratings.combine_high_40, "color: #00f; font-weight: bold", NULL) ) qd8ba30889d8c2287c87293790a534583_style,player.player_bench q2069d886d10a87f3fc2d1b85ad645949,if (player.player_bench <= combine_ratings.combine_low_strength, "color: #0b0; font-weight: bold", if (player.player_bench >= combine_ratings.combine_high_strength, "color: #00f; font-weight: bold", NULL) ) q2069d886d10a87f3fc2d1b85ad645949_style,player.player_agil q29001e4f1ae87af91c06dfc405739101,if (player.player_agil >= combine_ratings.combine_low_agil, "color: #0b0; font-weight: bold", if (player.player_agil <= combine_ratings.combine_high_agil, "color: #00f; font-weight: bold", NULL) ) q29001e4f1ae87af91c06dfc405739101_style,player.player_broad q51333a435fd4c584f1c0908991c45ca8,if (player.player_broad <= combine_ratings.combine_low_broad, "color: #0b0; font-weight: bold", if (player.player_broad >= combine_ratings.combine_high_broad, "color: #00f; font-weight: bold", NULL) ) q51333a435fd4c584f1c0908991c45ca8_style,player.player_pos_drill q358b6cfd6ccaf79c9f272caaa1bed874,if (combine_ratings.combine_high_pos is not null, if (player.player_pos_drill <= combine_ratings.combine_low_pos, "color: #0b0; font-weight: bold", if (player.player_pos_drill >= combine_ratings.combine_high_pos, "color: #00f; font-weight: bold", NULL) ) , NULL) q358b6cfd6ccaf79c9f272caaa1bed874_style,player_comments.player_comments_text,player.player_id upqueue,player.player_id inactivate,player.player_id del from (selection,player,position,combine_ratings) left join player_comments on player_comments.player_id = player.player_id and player_comments.team_id = '33' left join team_player on team_player.player_id = player.player_id and team_player.team_id = '33' where selection.team_id = '33' and player.player_id = selection.player_id and position.position_id = player.position_id and combine_ratings.position_id = position.position_id and selection_priority = 0 order by -1,selection_priority

Unknown column '???' in 'order clause'

_________________
Oregon