[quote=Daryl Fawcett]When trying to send an email to 24 selected users, I am receiving the following error message:
Script: /home4/maritim5/public_html/forums/admin/dosendemail.php
Line#: 191
SQL Error: Column 'USER_ID' in where clause is ambiguous
SQL Error #: 1052
Query: SELECT COUNT(*) FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' AND t1.USER_ID <> '1' and t2.USER_ACCEPT_ADMIN_EMAILS <> 'Off' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID AND USER_ID NOT IN ('986') and t3.USER_LAST_VISIT_TIME > '1546300799' GROUP BY t1.USER_ID ORDER BY t1.USER_ID ASC
Is this a bug that needs fixing???
This has been corrected for 7.7.2 over here
https://www.ubbcentral.com/forums/u...threads-7-7-2-progress-report#Post262789Changelog 2019-06-16[FIX] MySQL 5.7+ fixes to correctly handle GROUP BY clauses. This is a code fix, not a band-aid patch, such as reconfiguring your SQL MODE settings to add "TRADITIONAL" or removing "ONLY_FULL_GROUP_BY" from it.
BTW, Are you aware that you can edit your posts. You dont need to reply to yourself over and over again. 50 of the 70 posts in this thread are by you, just replying to yourself.
