Error log question

Support
1

this error is appearing frequently:

[2023-02-01 13:41:52] (ERROR @ /www/core/xpdo/om/xpdoquery.class.php : 770) Encountered empty IN condition with key usergroup
[2023-02-01 13:41:52] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 240) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘) OR ( ProfileUserGroup.usergroup IS NULL AND UGProfile.active = 1 )…’ at line 1
)

MODX 2.8.4 hosted on MODXCloud

Anyone know what might be causing this error

Thanks
Roy

2

Do you have manager users that are not in any user group?

3

The only example I could find where there’s no sanity check for the ProfileUserGroup.usergroup being empty before a query is in the Form Customization code (line 254) of the default user/create controller.

I think this is a bug. I’ve filed it here.

Do you have a Form Customization rule referring to a user group that no longer exists or, as halftrainedharry suggests, a manage user who is not in any usergroups?

4

Yes there were some admin users that were not in the administrator group. I have updated the users and will keep an eye on the error log

Thanks
Roy