So I set up a couple questions that were "Selection with Selection Partners Parameters"
Anytime they are searched with that information selected in their Partner information I get the following error messages:
Message: Can't execute query: Column 'role' in where clause is ambiguous
SELECT COUNT(u.user_id) FROM user AS u LEFT JOIN userinfo as i ON u.user_id=i.user_id WHERE hide_time=0 AND u.user_id!=1005 AND orientation=2 AND (weight>3 AND weight<30) AND (sexual_orientation>1 AND sexual_orientation<2) AND (height>1 AND height<23) AND (real_or_virtual>3 AND real_or_virtual<3) AND 92 & (1 << (cast(role AS signed) - 1)) AND (
File: /var/www/clients/client1/web12/web/_include/lib/db5.php (Line: 170)
File: /var/www/clients/client1/web12/web/_include/lib/db5.php (Line: 425)
File: /var/www/clients/client1/web12/web/_include/lib/list.php (Line: 49)
File: /var/www/clients/client1/web12/web/_include/current/users.php (Line: 552)
File: /var/www/clients/client1/web12/web/_include/lib/block.php (Line: 189)
File: /var/www/clients/client1/web12/web/_include/lib/block.php (Line: 172)
File: /var/www/clients/client1/web12/web/_include/core/main_close.php (Line: 13)
File: /var/www/clients/client1/web12/web/users_featured.php (Line: 63)
Anyone seen this before? Any ideas? If I disable those questions then marching search works fine...