Re: [otrs] OTRS Special Characters
Hi, I opened; http://bugs.otrs.org/show_bug.cgi?id=11951 Thanks! 2016-03-18 4:49 GMT-03:00 Martin Gruner : > Hello John, > > this sounds like a bug. Could you open an entry at http://bugs.otrs.org > please and attach a failing raw email to it please? > > Best regards, > > Martin Gruner > Team Lead R&D > > OTRS AG > Bahnhofplatz 1a > 94315 Straubing > > T: +49 (0)6172 681988 0 > F: +49 (0)9421 56818 18 > I: www.otrs.com/ > > Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: > DE256610065 > Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann > (Vorsitzender), Christopher Kuhn, Sabine Riedel > > Mobile Kommunikation und transparente Prozesse - Mit der OTRS Business > Solution™ Managed 5 schnell und ohne eigene IT-Ressourcen starten - Jetzt > neue Features entdecken und bestellen > > https://www.otrs.com/neu-in-otrs-business-solution-5-mobile-kommunikation-transparente-prozesse/?lang=de > > > Am 11.02.2016 um 23:25 schrieb John O'Neill : > > > > Hi > > > > We have OTRS 5 in place at the moment, all is working well except for > when we receive emails in from certain users who have the following footer > in their emails > > > > Kind Regards / Mit freundlichen Grüßen / Freundliche Grüße / Saludos > cordiales / Saygılarımla / Cordialement > > > > > > > > Were working on the assumption that the issue has something to do with > the character set, our database is working in UTF8, with the following > settings in my.cnf > > > > [client] > > default-character-set=utf8 > > > > > > [mysqld] > > character-set-server=utf8 > > > > > > The show variables statement shows the following > > > > > > SHOW VARIABLES LIKE "character_set_%"; > > +--++ > > | Variable_name| Value | > > +--++ > > | character_set_client | utf8 | > > | character_set_connection | utf8 | > > | character_set_database | utf8 | > > | character_set_filesystem | binary | > > | character_set_results| utf8 | > > | character_set_server | utf8 | > > | character_set_system | utf8 | > > | character_sets_dir | /usr/share/mysql/charsets/ | > > +--++ > > > > So it seems that everything is set to be UTF8 and as such should be able > to handle the different character sets. > > > > Every time we get a mail in with the special characters we get the > following error > > > > "There was an error executing Execute() in > Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch: [Thu > Feb 11 22:24:12 2016] otrs.Daemon.pl: DBD::mysql::db do failed: Incorrect > string value: '\xC4\xB1lar\xC4...' for column 'a_body' at row 1 at > /opt/otrs/Kernel/System/DB.pm line 449." > > > > > > I have run out of ideas now and was wondering if anyone might be able to > suggest where I could go next, we are running otrs 5.0.3-01 on CentOS > release 6.7 (Final) > > > > > > Many thanks, > > John > > > > - > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > - > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs -- Atenciosamente, Davi Albergaria - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] OTRS Special Characters
Hello John, this sounds like a bug. Could you open an entry at http://bugs.otrs.org please and attach a failing raw email to it please? Best regards, Martin Gruner Team Lead R&D OTRS AG Bahnhofplatz 1a 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel Mobile Kommunikation und transparente Prozesse - Mit der OTRS Business Solution™ Managed 5 schnell und ohne eigene IT-Ressourcen starten - Jetzt neue Features entdecken und bestellen https://www.otrs.com/neu-in-otrs-business-solution-5-mobile-kommunikation-transparente-prozesse/?lang=de > Am 11.02.2016 um 23:25 schrieb John O'Neill : > > Hi > > We have OTRS 5 in place at the moment, all is working well except for when we > receive emails in from certain users who have the following footer in their > emails > > Kind Regards / Mit freundlichen Grüßen / Freundliche Grüße / Saludos > cordiales / Saygılarımla / Cordialement > > > > Were working on the assumption that the issue has something to do with the > character set, our database is working in UTF8, with the following settings > in my.cnf > > [client] > default-character-set=utf8 > > > [mysqld] > character-set-server=utf8 > > > The show variables statement shows the following > > > SHOW VARIABLES LIKE "character_set_%"; > +--++ > | Variable_name| Value | > +--++ > | character_set_client | utf8 | > | character_set_connection | utf8 | > | character_set_database | utf8 | > | character_set_filesystem | binary | > | character_set_results| utf8 | > | character_set_server | utf8 | > | character_set_system | utf8 | > | character_sets_dir | /usr/share/mysql/charsets/ | > +--++ > > So it seems that everything is set to be UTF8 and as such should be able to > handle the different character sets. > > Every time we get a mail in with the special characters we get the following > error > > "There was an error executing Execute() in > Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch: [Thu > Feb 11 22:24:12 2016] otrs.Daemon.pl: DBD::mysql::db do failed: Incorrect > string value: '\xC4\xB1lar\xC4...' for column 'a_body' at row 1 at > /opt/otrs/Kernel/System/DB.pm line 449." > > > I have run out of ideas now and was wondering if anyone might be able to > suggest where I could go next, we are running otrs 5.0.3-01 on CentOS release > 6.7 (Final) > > > Many thanks, > John > > - > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
[otrs] OTRS 5 - Agent Queue small view - how to make subject equal to medium view?
Dear friends, Can you help me getting the "subject" shown in Small view to be the same Article Title as shown in Medium view? I mean, in Medium View I see the "Article title" instead the last subject from customer's feedback. Seems that "small" view shows the latest message subject (and has no option for the Article title), whereas our help desk team would prefer to use the Article Title. I suspect that I'll have to change some template, but I'm not sure where and how. Thanks in advance, -- Atenciosamente, Edson Carlos Ericksson Richter - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Re: [otrs] Layout strange behavior in output
Hi again. I post again about this argument because I managed to understand
why this strange behavior happens on my system,
In the meanwhile I also updated the dev system to OTRS 5 and I'm in the
progress of upgrading all my files and templates.
I've finally understood that the problem is generate by the
LayoutObject->Block sections, not by my database queries as I thought
before.
For example, in my module I have something like this:
$Output .= $Self->{LayoutObject}->Block(
Name => 'HeaderTitle',
);
In the *.tt file I have the proper [% RenderBlockStart("HeaderTitle") %]
section with the proper RenderBlockEnd.
In fact, the section is correctly printed on screen.
But, togheter with the section, I got a spooky "1" on the top left corner
of the html body.
If I add another Block section, It gets correctly printed on screen, but
guess what? On the top left corner I will have a 12 (1 and 2) written. And
so on. The more Blocks i insert, the more numbers I got on the top left
corner.
I can't even start to guess what is happening here...
2016-02-18 11:43 GMT+01:00 Finetti, Stefano :
> I might also add that those numbers are inserted between two
> apparently outside from normal HTML code:
>
> **
> **
> **
> * 1234567891011121314151617181920 *
> **
>
> As you can see, the first div is the NavigationContainer (the OTRS Menu),
> while the last is the MainBox container, which is used in OTRS to generate
> the "main" contents page.
>
> (The numbers are a sequence: 1 2 3 4 5 6 7 8 9 10 11 12 etc. etc.)
>
> 2016-02-18 11:35 GMT+01:00 Finetti, Stefano <
> sfine...@lynx-international.com>:
>
>> Hello everyone,
>>
>> I must confess I'm a bit lost with something that never happened before
>> with other customizations I've done in OTRS.
>>
>> I'm trying to create a module for OTRS 4 to help my colleagues work with
>> our AS400 systems. Nothing very strange, just a new menu to be used to
>> check various informations about the systems.
>>
>> I'm not completely new to OTRS customizations, and I've managed to create
>> some custom module using LayoutObject, DBObject and so. This is not a code
>> problem, or at least, not an easy one to spot.
>>
>> When I access the page I created, I got the output correctly formatted
>> from the query I run on an external DB, and, - and this is the problem - a
>> long string just below the navigation menu containing a sequence of
>> numbers, that I've identified with the number of records that my queries
>> get.
>>
>> The absolutely strange thing is that I didn't put ANY print, echo or
>> something like that in the code, and that all the output is directed
>> through LayoutObject->Block with name and data.
>> The template files has the correct names for RenderBlockStart and Stop
>> and [% Data.Variables | html %] Section. In fact, inside the RenderBlocks
>> all the output is fine.
>>
>> Since it's quite difficult even to explain the problem, I made a
>> screenshot of what I'm talking about.
>>
>> [image: Immagine incorporata 1]
>>
>> I've filtered out the output for privacy, but here is the strange output
>> just below "Dashboard".
>> I'm not using any customized layout (i.e. no files in Output/HTML/, only
>> .tt files in Output/HTML/Standard/).
>>
>> This has been haunting me for days now, without any luck.
>>
>> --
>> *Lynx International Srl*
>> *Stefano Finetti*
>> *http://www.lynx-international.com *
>>
>> *Lynx International Srl is a part of AXED Group*
>> Via Pier Luigi Nervi e/3 - Torre 6 - 04100 Latina
>>
>>
>
>
> --
> *Lynx International Srl*
> *Stefano Finetti*
> *http://www.lynx-international.com *
>
> *Lynx International Srl is a part of AXED Group*
> Via Pier Luigi Nervi e/3 - Torre 6 - 04100 Latina
>
>
--
*Lynx International Srl*
*Stefano Finetti*
*http://www.lynx-international.com *
*Lynx International Srl is a part of AXED Group*
Via Pier Luigi Nervi e/3 - Torre 6 - 04100 Latina
--
This e-mail and any files transmitted contain documentation which is highly
confidential and intended solely for the use of the individual or entity to
whom they are addressed. All written data and other information in the
documentation is and shall remain the property of the disclosing party. If
you are not the intended recipient you are hereby formally notified that
any disclosure, dissemination, forwarding, storing, copying or use of any
of the information is strictly prohibited and will be legally pursued. If
you received this in error, please contact the sender and destroy the
documentation including deletion of the same from any computer. Thank you.
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
