
fixed the problem (see below) by changing Config.pm back to: # CustomerPriority # (If the customer can set the ticket priority) $Self->{CustomerPriority} = 1; it appears to be a bug (#159) in this feature. i get the same error with or without the following line in CustomerMessageNew.dtl <input type="hidden" name="PriorityID" value="3"> ---- Greetings, The last thing I was doing (I think) was changing the auto-responses. Now I get the following error when creating a new ticket via customer.pl Is there an easy fix for this? Please help. djw. /var/log/messages: Jun 2 09:20:52 twiggy OTRS-CGI-10[28896]: [Error][Kernel::System::Ticket::Priority::PriorityLookup][Line:49]: No TypeID for normal found! Jun 2 09:20:52 twiggy OTRS-CGI-10[28896]: [Error][Kernel::System::Ticmysql> use otrs Reading table information mysql> use otrs Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changedfor completion of table and column names You can turn off this feature to get a quicker startup with -A Database changedket::CreateTicketDB][Line:224]: You have an error in y our SQL syntax near ' 1, 0, 1, current_timestamp, 1, current_timestamp, 1)' at line 1, SQL: 'INSERT INTO ticket (tn, creat e_time_unix, queue_id, ticket_lock_id, user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered, valid_id, create_time, create_by, change_time, change_by) VALUES ('2003060210000014', 1054542052, 1, 1, 1, 1, , 1, 0, 1, current_t imestamp, 1, current_timestamp, 1)' Jun 2 09:20:52 twiggy OTRS-CGI-10[28896]: [Error][Kernel::System::Ticket::CreateTicketDB][Line:239]: create db record faile d!!! Jun 2 09:20:52 twiggy OTRS-CGI-10[28896]: [Error][Kernel::System::Ticket::Article::CreateArticle][Line:47]: Need TicketID! fwiw, mysql> select * from otrs.ticket_priority; +----+-------------+---------------------+-----------+---------------------+-----------+ | id | name | create_time | create_by | change_time | change_by | +----+-------------+---------------------+-----------+---------------------+-----------+ | 1 | 1 very low | 2003-05-27 13:08:28 | 1 | 2003-05-27 13:08:28 | 1 | | 2 | 2 low | 2003-05-27 13:08:28 | 1 | 2003-05-27 13:08:28 | 1 | | 3 | 3 normal | 2003-05-27 13:08:28 | 1 | 2003-05-27 13:08:28 | 1 | | 4 | 4 high | 2003-05-27 13:08:28 | 1 | 2003-05-27 13:08:28 | 1 | | 5 | 5 very high | 2003-05-27 13:08:28 | 1 | 2003-05-27 13:08:28 | 1 | +----+-------------+---------------------+-----------+---------------------+-----------+ 5 rows in set (0.03 sec) Thanks for giving this your attention, djw@spyderworks.co.uk Thanks for giving this your attention, djw@spyderworks.co.uk