Error log question

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:
[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 = 1 )…’ at line 1

MODX 2.8.4 hosted on MODXCloud

Anyone know what might be causing this error


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

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?

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