We populate the Customer_User table directly from our CRM database. Among the fields updated / inserted is valid_id which is set to 1 (valid).
For some reason, after a period of time, this status changes to 2 (invalid), disabling the customer. What would cause this?
Solved: Invalid Customer
-
RBehr
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Solved: Invalid Customer
Last edited by RBehr on 08 Nov 2011, 17:36, edited 1 time in total.
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
-
RBehr
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Re: Invalid Customer
This was not an OTRS issue - it was permissions-related to our CRM database.
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3