[rt-users] Re: BUG in rt2->rt3 conversion re: keywords

[Jamie Wilkinson]

This one time, at band camp, Nicolae P. Costescu wrote:
>I was able to straighten the keywords out with a lot of SQL gymnastics. 
>Basically I had to create new CustomFields, then new CustomFieldValues, 
>then map all the customfields from the TicketCustomFieldValues to the new 
>CustomFields. Then I disabled the queue specific custom fields for every 
>queue except 0 (global), except for the queues that really were supposed to 
>have queue specific custom fields (whew).

Can you post the specific sql statements you used?  I've also been hit by
this, and it's the last thing I need to fix for our RT3 migration.

-- 
jaq at spacepants.org                           http://spacepants.org/jaq.gpg