On Sun, 3 Oct 2004 12:59:01 +0100, Des Quinn
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it intentional that if you have an existing user with tickets that if you
> change the cstomer id that they appear to have no tickets associated with
> them the next time they log in.
Yes, this will happen If you change the customers id in the database
where customer id is drawn from (because all tickets have a customer
id associated as well to be able to match up customer with ticket).
Scenario. Customer with id 1 creates a ticket. Ticket also has
customer id value of 1.
Customer
------------
cust id = 1
A Match!
Ticket
------------
cust id = 1
If you change the Customer's cust id to 2, then you have:
Customer
------------
cust id = 2
No Match!
Ticket
-------
cust id = 1
>
> if you change the customer id back to its original value then the tickets
> reappear. I am guessing that this is relating to the customer_id value in
> the ticket table.
Yep, exactly. See above.
>
> If I wish to change the customer ids in use can I just ho thru the ticket
> table and change the customer_id to the new values and the tickets should
> retain their association with the user?
Exactly. If you change the customer's id, you also have to change the
cust id of all the tickets.
Hth,
Tyler Hepworth
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/
