> Error: Unknown table 'queue' in where clause, SQL: 'update ticket
> set customer_id = ClientIDName
> where
> queue.id = ticket.queue_id and
> queue.name = "First Client Name::Incoming"'
>
Yes, it exists, but the sql query doesn't know where to find it because I
forgot to specify it.
Query needs to be this
update ticket,queue
set ticket.customer_id = ClientIDName
where
queue.id = ticket.queue_id and
queue.name = "First Client Name::Incoming"'
Hth,
Tyler
_______________________________________________
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/
