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.
_______________________________________________
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
