[otrs] AUTOREPLY otrs Digest, Vol 132, Issue 1

baer at opm-computer.de baer at opm-computer.de
Sat Oct 5 00:14:09 UTC 2019


Sehr geehrte Damen und Herren, 

in der Zeit vom 27.09.2019 bis einschließlich 13.10.2019 befinde ich mich nicht im Büro.

Beachten Sie bitte, dass Ihre E-Mail nicht automatisch weitergeleitet wird. 
In dringenden Fällen wenden Sie sich bitte an unsere Hotline unter 0203-378530, oder an Herrn Gries (gries at opm-computer.de).
Bei technischen Problemen oder Fragen können Sie auch eine Mail an support at opm-computer.de senden.



Mit freundlichen Grüßen 

Ronny Bär
OPM IT Service GmbH


Send otrs mailing list submissions to
	otrs at lists.otrs.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.otrs.org/mailman/listinfo/otrs
or, via email, send a message with subject or body 'help' to
	otrs-request at lists.otrs.org

You can reach the person managing the list at
	otrs-owner at lists.otrs.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of otrs digest..."


Today's Topics:

   1.  Troubleshooting DBUpdate-to-6.pl errors - FK issue (Nick Bright)
   2. Re:  Troubleshooting DBUpdate-to-6.pl errors - FK issue
      (Florian Edlhuber)
   3.  OTRS 6 Calendar (Nick Bright)
   4.  Fill OTRS-Adressbook from Nextcloud contacts? (Mathias Waack)
   5.  Tickets number of digits (Alexis HAUSER)
   6. Re:  Tickets number of digits (=?UTF-8?B?TFEgTWFyc2hhbGw=?=)


----------------------------------------------------------------------

Message: 1
Date: Thu, 19 Sep 2019 13:58:24 -0500
From: Nick Bright <nick.bright at valnet.net>
To: otrs at lists.otrs.org
Subject: [otrs] Troubleshooting DBUpdate-to-6.pl errors - FK issue
Message-ID: <2fdbe889-8415-5f3a-6233-4431945548b0 at valnet.net>
Content-Type: text/plain; charset=utf-8; format=flowed

Greetings,

I'm working on upgrading to v6, and in the process I'm getting an error 
on Step 31/44 in DBUpdate-to-6.pl, clearly caused by some error in the 
database. I'm trying to find that error to correct it, but the error 
message isn't giving me enough information to do so.

Does anybody have any suggestions on how to find the offending data? 
Once I find it, then I can figure out what to do to correct it.

Step 31 of 44: Post changes on article related tables ...

 ??????? - Reseting auto-incremental if needed for article table.
 ??????? - Performing needed actions on article_data_mime table.
 ??????? - Performing needed actions on article_data_mime_plain table.
 ??????? - Performing needed actions on article_data_mime_attachment table.
 ??????? - Re-create foreign keys pointing to the old article table.
[Thu Sep 19 13:31:20 2019] DBUpdate-to-6.pl: DBD::mysql::db do failed: 
Cannot add or update a child row: a foreign key constraint fails 
(`otrs`.`#sql-5e0_29`, CONSTRAINT `FK_ticket_history_article_id_id` 
FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)) at 
/opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.16.3 OS: 
linux Time: Thu Sep 19 13:31:20 2019

 ?Message: Cannot add or update a child row: a foreign key constraint 
fails (`otrs`.`#sql-5e0_29`, CONSTRAINT 
`FK_ticket_history_article_id_id` FOREIGN KEY (`article_id`) REFERENCES 
`article` (`id`)), SQL: 'EXECUTE FKStatement'

 ?Traceback (5899):
 ?? Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394
 ?? Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
 ?? Module: 
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_RecreateForeignKeysPointingToArticleTable 
Line: 419
 ?? Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run 
Line: 67
 ?? Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
 ?? Module: scripts::DBUpdateTo6::Run Line: 69
 ?? Module: scripts/DBUpdate-to-6.pl Line: 87


ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.16.3 OS: 
linux Time: Thu Sep 19 13:31:20 2019

 ?Message: Error during execution of 'EXECUTE FKStatement'!

 ?Traceback (5899):
 ?? Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397
 ?? Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
 ?? Module: 
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_RecreateForeignKeysPointingToArticleTable 
Line: 419
 ?? Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run 
Line: 67
 ?? Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
 ?? Module: scripts::DBUpdateTo6::Run Line: 69
 ?? Module: scripts/DBUpdate-to-6.pl Line: 87

-- 
-----------------------------------------------
-  Nick Bright                                -
-  Vice President of Technology               -
-  Valnet -=- We Connect You -=-              -
-  Tel 888-332-1616 x 315 / Fax 620-331-0789  -
-  Web http://www.valnet.net/                 -
-----------------------------------------------
- Are your files safe?                        -
- Valnet Vault - Secure Cloud Backup          -
- More information & 30 day free trial at     -
- http://www.valnet.net/services/valnet-vault -
-----------------------------------------------



------------------------------

Message: 2
Date: Fri, 20 Sep 2019 08:27:15 +0200
From: Florian Edlhuber <florian.edlhuber at gmx.de>
To: "User questions and discussions about OTRS." <otrs at lists.otrs.org>
Subject: Re: [otrs] Troubleshooting DBUpdate-to-6.pl errors - FK issue
Message-ID: <1568960835.93249.5018914934 at otrs.edlhuber.net>
Content-Type: text/plain; charset="utf-8"

Hi Nick,

19.09.2019 20:59 - Nick Bright schrieb:
> I'm working on upgrading to v6, and in the process I'm getting an error
> on Step 31/44 in DBUpdate-to-6.pl, clearly caused by some error in the
> database.
>(...)
> [Thu Sep 19 13:31:20 2019] DBUpdate-to-6.pl: DBD::mysql::db do failed:
> Cannot add or update a child row: a foreign key constraint fails

You are missing (or have wrong) key constraints. One quick and dirty
possibility
would be to turn off the key constraint check during update.

Better ask your database administrator, how to solve this issue.

--
Florian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20190920/06ba7be7/attachment-0001.html>

------------------------------

Message: 3
Date: Fri, 20 Sep 2019 10:38:35 -0500
From: Nick Bright <nick.bright at valnet.net>
To: otrs at lists.otrs.org
Subject: [otrs] OTRS 6 Calendar
Message-ID: <2693b17e-4213-b06e-4185-45dd32cbc88f at valnet.net>
Content-Type: text/plain; charset=utf-8; format=flowed

Is there a plugin or mechanism available to be able to view (read only 
is fine) Calendars in an external application? Specifically in the 
native calendar app on an Android phone?

Is there a way to link calendars to specific Agents or Queues?

-- 
-----------------------------------------------
-  Nick Bright                                -
-  Vice President of Technology               -
-  Valnet -=- We Connect You -=-              -
-  Tel 888-332-1616 x 315 / Fax 620-331-0789  -
-  Web http://www.valnet.net/                 -
-----------------------------------------------
- Are your files safe?                        -
- Valnet Vault - Secure Cloud Backup          -
- More information & 30 day free trial at     -
- http://www.valnet.net/services/valnet-vault -
-----------------------------------------------



------------------------------

Message: 4
Date: Tue, 1 Oct 2019 16:22:50 +0200
From: Mathias Waack <mathias.waack at seim-partner.de>
To: otrs at lists.otrs.org
Subject: [otrs] Fill OTRS-Adressbook from Nextcloud contacts?
Message-ID: <0d8daa2a-0465-539f-84ca-899ca68a62e4 at seim-partner.de>
Content-Type: text/plain; charset="us-ascii"

An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20191001/d3e35b2f/attachment-0001.html>

------------------------------

Message: 5
Date: Thu, 3 Oct 2019 16:59:49 +0200 (CEST)
From: Alexis HAUSER <alexis.hauser at imt-atlantique.fr>
To: otrs <otrs at lists.otrs.org>
Subject: [otrs] Tickets number of digits
Message-ID:
	<331633478.9938532.1570114789773.JavaMail.zimbra at imt-atlantique.fr>
Content-Type: text/plain; charset="utf-8"

Hi, 

Is there a way to change the number of digits used in the ticket numbers ? 

For example, transform Ticket# 20190411 40000 031 into date + 3 digits for ticket number : Ticket#20190411031 
Regards 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20191003/ba2bc1e8/attachment-0001.html>

------------------------------

Message: 6
Date: Fri, 04 Oct 2019 20:02:09 -0400
From: "=?UTF-8?B?TFEgTWFyc2hhbGw=?=" <qmarshall at iNetSpace.net>
To: "User questions and discussions about OTRS." <otrs at lists.otrs.org>
Subject: Re: [otrs] Tickets number of digits
Message-ID: <mailman.2.1570234098.17083.otrs at lists.otrs.org>
Content-Type: text/plain; charset="utf-8"

I believe that you can change the ticket format. The setting is in the admin section somewhere. (There was a thread a long while back on the subject.) The format you're mentioning i do not believe will work. The format includes more than what you reference.L.Q. MarshallOne's strength is only determined when the challenge seems overwhelming.<div>
</div><div>
</div><!-- originalMessage --><div>-------- Original message --------</div><div>From: Alexis HAUSER <alexis.hauser at imt-atlantique.fr> </div><div>Date: 10/3/19  11:00  (GMT-05:00) </div><div>To: otrs <otrs at lists.otrs.org> </div><div>Subject: [otrs] Tickets number of digits </div><div>
</div>
Hi, 

Is there a way to change the number of digits used in the ticket numbers ? 

For example, transform Ticket# 20190411 40000 031 into date + 3 digits for ticket number : Ticket#20190411031 
Regards 




---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20191004/ccbdcbb8/attachment.html>

------------------------------

Subject: Digest Footer

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs


------------------------------

End of otrs Digest, Vol 132, Issue 1
************************************




More information about the otrs mailing list