[rt-users] Rebuild Groups Table

[Kenneth Crocker]

Kevin,

I also noticed, while perusing the DB, that there are a lot of gaps in
ticket numbers and the create dates are in the evening when no one is around
in the building, usually around midnight (TICKETS sorted in ID sequence).

Kenn
LBNL

On Tue, Jun 21, 2011 at 12:39 PM, Kenneth Crocker <kfcrocker at lbl.gov> wrote:

> Kevin,
>
> What is rt-validator?
>
> Kenn
> LBNL
>
> On Tue, Jun 21, 2011 at 12:14 PM, Kevin Falcone <falcone at bestpractical.com
> > wrote:
>
>> On Tue, Jun 21, 2011 at 12:10:02PM -0700, Kenneth Crocker wrote:
>> >    I'm looking thru a bunch of tickets (created back when we upgraded to
>> 3.8.7) and I noticed
>> >    there were no requestors for those tickets. I went into each of those
>> tickets to add a
>> >    Requestor and Viola' I got an error saying the group couldn't be
>> found. Sure enough, there are
>> >    a WHOLE SERIES of tickets that have no requestors and no groups
>> (AdminCc, Cc, Requestors,
>> >    Owners). Soooo, I was wondering if anyone had any SQL or code to
>> correct this situation.
>> >
>> >    I'm thinking if I just add the Groups using SQL, then I could just do
>> a bulk update within RT
>> >    to get Requestors in those tickets. By going at it that way, I should
>> have to worry about the
>> >    ACL, etc.
>>
>> How exactly did you lose the groups?
>>
>> I suggest seeing what rt-validator has to say about your dataset.
>>
>> -kevin
>>
>>
>> --------
>> 2011 Training: http://bestpractical.com/services/training.html
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110621/db087fa8/attachment.htm>