Hi Bryan, On Sun, May 04, 2003 at 12:04:34PM -0400, Bryan Fullerton wrote:
Addendum... I seem to only get this error when someone sends an email that adds to a ticket from 1.0.x. Maybe the upgrade process needs to add something to existing tickets?
Thanks,
Bryan
[...] Message: No TypeID for StateUpdate found!
Traceback (93443): Module: Kernel::System::Ticket::History::HistoryTypeLookup (v1.7) Line: 49 Module: Kernel::System::Ticket::History::AddHistoryRow (v1.7) Line: 74 Module: Kernel::System::Ticket::State::SetState (v1.14) Line: 174 Module: Kernel::System::PostMaster::FollowUp::Run (v1.27) Line: 138 [...]
Normally not. But there is a missing entry in scripts/DBUpdate-to-1.1.postgresql.sql. :-/ Add this recorde to your otrs database and it will work. [...] INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) VALUES ('StateUpdate', 1, 1, current_timestamp, 1, current_timestamp); [...] Sorry! Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972