Error when regular user creates Email Marketing record

[robertbmirth]

Hey all, I have a user trying to create and send an email campaign. When they go to create a new Email Marketing record, the following error happens:
Error filling in user array: Query Failed: SELECT DISTINCT id, name as display from email_templates INNER JOIN team_sets_teams tst ON tst.team_set_id = email_templates.team_set_id INNER JOIN team_memberships team_memberships ON tst.team_id = team_memberships.team_id
AND team_memberships.user_id = '{current_user_id}'
AND team_memberships.deleted=0 where deleted=0 order by name: MySQL error 1052: Column 'id' in field list is ambiguous
This doesn't happen when Ian admin user tries to create the record. Any ideas?

*edit*

I'm running Sugar Pro 6.2.1 on an OnDemand environment

[robertbmirth]

I'm still having this issue, but as a temporary resolution, on SugarPro you can use the roles module to give users admin access to specific modules, so unless you have any reason to limit access to your Email Templates, you can just give the users sending email campaigns admin access to the Email Templates module via a role and it will resolve the issue.