Hi

I have successfully set up a OTRS installation, whith an external "Customer User Backend DB". External users can login and work. External users are visible under "Customer Users" in the admin area.
Now I'm trying to impelment "Customer Users <-> Groups" mapping. Checking "Customer Users <-> Groups" in the admin area I can't see any user. Checking the logs I see:

Wed Sep 21 01:13:12 2005 error OTRS-CGI-10 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 ')' at line 1, SQL: 'SELECT mos_users.username, mos_users.username, SUBSTRING(mos_users.email,LOCATE('@',mos_users.email)+1) FROM mos_users WHERE valid_id in ( )'
Wed Sep 21 01:13:12 2005 error OTRS-CGI-10 Table 'Mambo.valid' doesn't exist, SQL: 'SELECT id FROM valid WHERE name = 'valid''

Looking at the second line it seems that OTRS is trying to access the "valid" table erroneously on the external "Customer User Backend DB" instead off its own, internal DB. A Bug?

-- 

Best regards

Roberto Giana


_____________________________________________________

Giana Roberto Consulting - GiaRoCo
https://www.giaroco.ch/

_____________________________________________________