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
OTRS_CUSTOMER_LOGIN issue
Moderator: crythias
-
- Znuny newbie
- Posts: 1
- Joined: 04 Sep 2018, 14:49
- Znuny Version: OTRS5
-
- Znuny newbie
- Posts: 75
- Joined: 27 Aug 2018, 13:50
- Znuny Version: Community
- Real Name: Christian Clavet
- Company: Tact Group
Re: OTRS_CUSTOMER_LOGIN issue
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 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
OTRS Community 6.0.11
Debian 9.0
MariaDB