Search found 20 matches

by tentacle
13 May 2020, 02:51
Forum: Help
Topic: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Replies: 10
Views: 6543

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Hi,

In ZZZAuto.pm there indeed was few broken characters and upgrade worked perfect after that!

Thanks!

I'd offer you 48 beers right now in a bar if I could. This really helped a lot!
by tentacle
04 May 2020, 09:25
Forum: Help
Topic: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Replies: 10
Views: 6543

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Hi, Could somebody point me to right direction on how to find weird characters from the database dump? I'm pretty sure there's some unsupported character which crashes the upgrade. DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chun...
by tentacle
08 Nov 2018, 10:37
Forum: Help
Topic: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Replies: 10
Views: 6543

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Still happens on newest version 6.0.12

Any tips?

There must be some weird letters or something in the database but the question is how to find those.
by tentacle
15 Aug 2018, 13:22
Forum: Help
Topic: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Replies: 10
Views: 6543

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Could anyone give me a hint where to look for problems? Ok it might be some weird letter in the database but how to find it? DBUpdate-to-6.pl gives this error and stops: [Wed Aug 15 14:12:53 2018] DBUpdate-to-6.pl: utf8 "\xE4" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line...
by tentacle
22 Mar 2018, 14:36
Forum: Help
Topic: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Replies: 10
Views: 6543

Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1

Same error here.

Where should I look for more information on this?

---

Databases are UTF-8

Centos 7
MariaDB 5.5.56

otrs-5.0.23-01.noarch.rpm -> otrs-6.0.6-01.noarch.rpm
by tentacle
22 Jun 2016, 14:28
Forum: General
Topic: Autofill ticket subject and text field on close
Replies: 6
Views: 4184

Re: Autofill ticket subject and text field on close

Thanks!

This was just what I was looking for
by tentacle
18 Jun 2016, 14:23
Forum: General
Topic: Autofill ticket subject and text field on close
Replies: 6
Views: 4184

Autofill ticket subject and text field on close

Hi,

Is it possible to autofill ticket subject and text field when closing ticket
or remove requirement to input something on both fields?

We get lots of tickets that need no comments or anything and just need to be closed.
by tentacle
17 Apr 2013, 09:45
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

Where should I place my script if I'd like it to run when new tickets are generated
and agents would be normally notified?
by tentacle
16 Apr 2013, 06:55
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

I just can't see the section of code where it actually sends out notifications though.
by tentacle
15 Apr 2013, 09:23
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

Is there function which sends out all notifications?

I could just run my script instead of it or after/before.

This way notification settings would also apply.
by tentacle
14 Apr 2013, 21:46
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

Hi,

We have dedicated SMS box for notifications and it needs to be
used via special script.
by tentacle
14 Apr 2013, 20:16
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

It would be nice if email notifications could just be replaced so that notification settings
would apply for agents.
by tentacle
14 Apr 2013, 18:49
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

Yes, I'd like to notify agents via SMS instead of email and have suitable bash script
to do it. Just need to integrate it with OTRS.

Email notifications could even be replaced if needed / easier.
by tentacle
14 Apr 2013, 17:53
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

Re: How to check if ticket gets response

Hi, I've tried to modify Test.pm. For new tickets I could run my bash script with: if ( $Param{Event} eq 'TicketCreate' ) { #something } But what is the event that would trigger followup? i've tried countless variations of followup, ticketfollowup, etc. if ( $Param{Event} eq 'FollowUp' ) { #somethin...
by tentacle
14 Apr 2013, 11:51
Forum: Help
Topic: How to check if ticket gets response
Replies: 11
Views: 3468

How to check if ticket gets response

Hi,

How could you check if ticket gets response and do something afterwards?

I'm trying to create module for sending SMS messages to agents after new tickets and
responses.

For new tickets I've got it working already.

Thanks!
by tentacle
14 Apr 2013, 11:50
Forum: Developers
Topic: SMS Notification module
Replies: 7
Views: 3727

Re: SMS Notification module

Sorry for posting in Developers. I thought this would be suitable section.

You can delete this post.
by tentacle
14 Apr 2013, 11:27
Forum: Developers
Topic: SMS Notification module
Replies: 7
Views: 3727

Re: SMS Notification module

Hi,

Got SMS working for new tickets but how could you check if ticket gets followup?

Just point me to the right direction and I'll figure it out.

Thanks!
by tentacle
14 Apr 2013, 09:29
Forum: Developers
Topic: SMS Notification module
Replies: 7
Views: 3727

Re: SMS Notification module

How do I check if agent has notifications enabled?

Can't find it on the manuals :(
by tentacle
13 Apr 2013, 10:47
Forum: Developers
Topic: SMS Notification module
Replies: 7
Views: 3727

SMS Notification module

Hi, I've been looking SMS module for OTRS and found just one: http://nor.fi/~jheusala/pub/SMSNotification.pm As this module has been created several years ago and it doesn't work anymore. Could anyone please help me out to get this running. What lines need modifications? I haven't got too much perl ...