Hi David, On Wed, Jun 04, 2003 at 10:59:18AM +0100, David West wrote:
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 [...] 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! [...] 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)
Did you update your system? Do you use the old Kernel/Config/Defaults.pm? Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.