[Register] sql error in log when &usergroups is set

[jonleverrier]

When the register snippet has &usergroups set and a user registers, it generates an error in the error log.

[2017-12-18 12:20:58] (ERROR @ /paas/xxxxx/www/core/xpdo/xpdo.class.php : 1320) Could not get table class for class: modAccess
[2017-12-18 12:20:58] (ERROR @ /paas/xxxxx/www/core/xpdo/xpdo.class.php : 1289) Could not get table name for class: modAccess
[2017-12-18 12:20:58] (ERROR @ /paas/xxxxx/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 MySQL server version for the right syntax to use near 'AS `modAccess` WHERE `modAccess`.`principal` = 64' at line 1
)

Upon registration, the user is successfully added to the correct User Group, so we're just talking about this stray error in the log.

Using Login 1.9.4 and MODX 2.6.1

[muzzwood]

I can replicate this. Thanks for making the issue @jonleverrier

[muzzwood]

Actually I'm getting the same error when removing a user via the manager. It doesn't matter if the user was created with the Register snippet or manually via the manager UI. Perhaps the cause is something in the core - I'll post the issue there and see if others can replicate it.

[Jako]

Closing this due to long inactivity. Feel free to reopen it with more details if it is still an issue.