OTRS_CUSTOMER_LOGIN issue

Moderator: crythias

Post Reply
ramesh143123
OTRS newbie
Posts: 1
Joined: 04 Sep 2018, 14:49
OTRS Version?: OTRS5

OTRS_CUSTOMER_LOGIN issue

Post by ramesh143123 » 05 Sep 2018, 13:07

HI,

I have upgraded the OTRS version 4 to Version 5. After complete upgrade, I cannot raise any ticket from customer.pl page and got this error. Can you please tell the solution on this issue?

An Error Occurred
Unknown column 'a_message_id_md5' in 'field lisf, SOL: 'INSERT INTO article (ticket_id,article_type_id, article_sender_lype_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_message_...

Error Detals


Traceback
ERROR: OTRS-CGI -10 Perl: S.10.1 OS: linux Time: Sat Sep 106 :47 :52 2018

Message : Unknown column 'a_message_id_md S ' in ' f ield list' , 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_message_ id_rnd S, a_in_reply_to, a_ref erences, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
' 2018-09-01 06:47 :52 '

J ?,


' 2018-09-01 06:47 :52 '

J ?) .

RemoteAddress : 202 .83.25 .134
RequestURI: /otrs/ cu stomer .pl

Traceback ( 3149) :
Module: Kernel::System: :Ticket : :Article : :ArticleCreate L ine : 299 Module: Kernel: :Modules ::CustomerTicketMessage::Run L ine : 608 Module: Kernel: :System: :Web : :InterfaceCustomer::Run L ine : 1222
Module: ModPerl : :ROOT : :ModPerl : :Registry: :opt_otrs_bin_cgi_2dbin_customer_2epl : :handler Line: 40
Modu le: (eval) (vl .99) L ine : 204
Modu le: McdPerl : :RegistryCooker ::run (vl.99) Line: 204
Module: ModPerl : :RegistryCooker: :def au lt_handler (vl.99) Line : 170 Modu le: ModPerl : :Registry ::handler (vl.99) L ine : 31

User avatar
christianclavet
OTRS expert
Posts: 75
Joined: 27 Aug 2018, 13:50
OTRS Version?: Community
Real Name: Christian Clavet
Company: Tact Group

Re: OTRS_CUSTOMER_LOGIN issue

Post by christianclavet » 14 Sep 2018, 20:49

Hi!

OTRS seem to have problems finding the relevant data in the DB. Have you done the migration scripts?
This is not found on your current DB: a_message_id_md5
There might be others that are not found. Your DB seem to miss some data, you probably just need to update the DB to your version of OTRS.
----------------------------------------------
OTRS Community 6.0.11
Debian 9.0

MariaDB

Post Reply