http://www.thecfl.us/forum/ |
|
| draft analyzer/utility issue http://www.thecfl.us/forum/viewtopic.php?t=10506 |
Page 1 of 1 |
| Author: | mac88 [ Thu Nov 05, 2020 10:43 pm ] |
| Post subject: | draft analyzer/utility issue |
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' |
|
| Page 1 of 1 | All times are UTC-07:00 |
| Powered by phpBB® Forum Software © phpBB Limited https://www.phpbb.com/ |
|