Tried installing the module and received this error on the invite page.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY r.realname ASC LIMIT 0, 10' at line 1 query: SELECT u.uid, u.name, r.realname FROM users u INNER JOIN realname r USING(uid) LEFT JOIN users_roles ur ON u.uid = ur.uid WHERE u.status <> 0 AND LOWER(r.realname) LIKE LOWER('%test%') AND ur.rid IN () ORDER BY r.realname ASC LIMIT 0, 10 in C:\Work\Xampp\xampplite\htdocs\sites\all\modules\og_invite_restrict\og_invite_restrict.module on line 92

Comments

ultimike’s picture

ultimike
Primary language English
Location Florida, USA
commented
Status: Active » Closed (fixed)

This is warning is due to the fact that you didn't have any roles on admin/user/permissions with the "can be invited to join groups" permission enabled. This effectively means that no users on your site have permission to join any groups.

I went ahead and added a check in the code that won't run the query if no roles are selected, I also updated the readme.txt info with this information.

This will be rolled into the next dev release later tonight, assuming I figure out how to do it with Git.

Thanks,
-mike