rackem
Well-Known Member
I have a prefilter on a list that uses a "NOT IN" condition. When I try to go to my list I get a 500 error that contains "Subquery returns more than 1 row SQL="
After troubleshooting in phpMyAdmin, I found the error is in the WHERE clause.
WHERE ( `mps_votes`.`player` = (SELECT `id` FROM `mps_players` WHERE `active` = 0) )
If I replace "=" with "NOT IN", the query works. So it seems that the NOT IN condition in my prefilter is being wrongly inserted as "=".
This is for F! 3.1.
After troubleshooting in phpMyAdmin, I found the error is in the WHERE clause.
WHERE ( `mps_votes`.`player` = (SELECT `id` FROM `mps_players` WHERE `active` = 0) )
If I replace "=" with "NOT IN", the query works. So it seems that the NOT IN condition in my prefilter is being wrongly inserted as "=".
This is for F! 3.1.