Caught an error on the ticket deletion. The SQL should be:
SQL => "UPDATE ticket ".
" SET user_id = 0 ".
" WHERE ".
" ticket_id = $_",
instead of what I had previously posted.
On Sat, 2004-01-10 at 07:09, Mark Mertel wrote:
> Robert,
>
> here are some ideas on the deleting user requirement. I added a
> DeleteUser in User.pm and a GetUserTickets in Ticket.pm. I'm not sure if
> they work as written as I have yet to get all of otrs installed on my
> systems, but, they should be close.
>
>
>
> On Thu, 2004-01-08 at 02:47, Robert Kehl wrote:
> > On Friday, December 26, 2003 3:34 AM
> > Mark Mertel <[EMAIL PROTECTED]> wrote:
> > > It would probably be a good idea for the long term to provide a delete
> > > method in the object model for each object which can be saved to the
> > > database. Within these methods could be handled any type of action
> > > regarding cascading deletes, or updating any reference tables with
> > > some default value, i.e. if you wished to delete a user you would
> > > probably want to update any trouble tickets created by that user toi
> > > some system user account.
> >
> > A feature like the above is most likely to be built in the near future.
> > Feel free to contribute ideas and/or concrete patches/code on the
> > developers' list [EMAIL PROTECTED]
> >
> > Robert Kehl
> >
> > --
> > ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
> > http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
> >
> > _______________________________________________
> > 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/
--
Mark Mertel
[EMAIL PROTECTED]
Mobile 206.409.2018
Phone 206.322.9074
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
