Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Drafting the last team leads the page to freeze - #2

Open
zo0o0ot opened this issue Jan 12, 2018 · 1 comment
Open

Drafting the last team leads the page to freeze - #2

zo0o0ot opened this issue Jan 12, 2018 · 1 comment
Assignees
Labels

Comments

@zo0o0ot
Copy link
Owner

zo0o0ot commented Jan 12, 2018

error message:

{"success":false,"errors":["Unable to add pick: An exception occurred while executing 
\u0027SELECT p.pick_duration, m.manager_name, avg(pick_duration) as pick_average\r\n    
FROM players p\r\n    
LEFT OUTER JOIN managers m\r\n    
ON m.manager_id = p.manager_id\r\n    
WHERE p.draft_id = ?\r\n    
GROUP BY m.manager_name \r\n    
ORDER BY pick_average DESC\r\n    
LIMIT 1\u0027:\n\
nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column \u0027phpdraft.p.pick_duration\u0027 which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"]}

Angular seems to indicate that I can't do something when the draft is already closed, but the message went away quickly, so I'm not positive what it said.

@zo0o0ot
Copy link
Owner Author

zo0o0ot commented Jan 12, 2018

leagify-phpdraft-drafterror

error-phpdraft

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant