[SOLVED] SQL error

[nanotowers]

Hi folks, i have this error; when i close the ticket.

Mensaje de error: Duplicate entry '27009' for key 'PRIMARY', SQL: 'INSERT INTO article (ticket_id,[..]


Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Nov 19 15:23:15 2014 Message: Duplicate entry '27009' for key 'PRIMARY', SQL: 'INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_in_reply_to, a_references, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2014-11-19 15:23:15' , ?, '2014-11-19 15:23:15' , ?)' Traceback (1572): Module: Kernel::System::Ticket::Article::ArticleCreate (v1.311.2.2) Line: 252 Module: Kernel::Modules::AgentTicketActionCommon::Run (unknown version) Line: 748 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31

[nanotowers]

look the picture

[nanotowers]

in the database i created an article with the id 27011, the 27009 and 27010 through an error, so i continue the next article id, in this line the MySQL let me insert the information, so one of my agents try the close a ticket and the problem was fix it. i omitted the article id 27009 and 27010.

[ecastanos]

Hello good morning, how did you solve the problem, I'm new to otrs

[zzz]

Hey,

That sounds like an old bug. You should definitely upgrade your system.

How to fix: It's probably enough if you increase the auto_increment of the article table by one.

Best regards
Emin