StatsLab 16 problem

PBCA Commish · 12-07-2015, 02:29 PM

I tried to do a manual pick for the first overall pick. I selected the player and I got the following error message after the page was loading:

ERROR: No player found for auto pick! Try regenerating the autodraft list.
SELECT SQL_NO_CACHE dp2.* FROM (SELECT dp1.player_id,if(porder IS NULL,999999,porder) as porder FROM (SELECT dp.player_id FROM ootp_sql_draft_pool as dp LEFT JOIN amateur_draft as ad ON dp.player_id=ad.player_id WHERE dp.league_id=100 AND ad.player_id IS NULL) as dp1 LEFT JOIN ootp_sql_draft_list as dl ON dp1.player_id=dl.player_id WHERE human_manager_id=-1000 ORDER BY porder) as dp2 GROUP BY player_id ORDER BY porder LIMIT 1

I have turned off auto-picks for now...so not quite sure why I'm getting an error for auto-picks...

Player does end up in the draft order though when I go back to the draft page.

Any idea?

Thanks for the help!

12-07-2015, 02:29 PM	#1
PBCA Commish Minors (Single A) Join Date: Nov 2015 Location: Montreal, Canada Posts: 98	StatsLab 16 problem I tried to do a manual pick for the first overall pick. I selected the player and I got the following error message after the page was loading: ERROR: No player found for auto pick! Try regenerating the autodraft list. SELECT SQL_NO_CACHE dp2.* FROM (SELECT dp1.player_id,if(porder IS NULL,999999,porder) as porder FROM (SELECT dp.player_id FROM ootp_sql_draft_pool as dp LEFT JOIN amateur_draft as ad ON dp.player_id=ad.player_id WHERE dp.league_id=100 AND ad.player_id IS NULL) as dp1 LEFT JOIN ootp_sql_draft_list as dl ON dp1.player_id=dl.player_id WHERE human_manager_id=-1000 ORDER BY porder) as dp2 GROUP BY player_id ORDER BY porder LIMIT 1 I have turned off auto-picks for now...so not quite sure why I'm getting an error for auto-picks... Player does end up in the draft order though when I go back to the draft page. Any idea? Thanks for the help! Last edited by PBCA Commish; 12-07-2015 at 02:31 PM.