DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Moderator: crythias
-
- Znuny newbie
- Posts: 3
- Joined: 02 Feb 2018, 14:19
- Znuny Version: fives
- Real Name: bruno
- Company: ufpb
DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Friends,
Good morning!!
I have a problem
I follow the steps of tutorial on website otrs
When i run script DBUpdate-to-6.pl in the step 8: Step 8 of 37: Migrate configuration ... show this message:
DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1.
How can i fix this?
Good morning!!
I have a problem
I follow the steps of tutorial on website otrs
When i run script DBUpdate-to-6.pl in the step 8: Step 8 of 37: Migrate configuration ... show this message:
DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1.
How can i fix this?
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Did you check that all tables are utf8?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny newbie
- Posts: 3
- Joined: 02 Feb 2018, 14:19
- Znuny Version: fives
- Real Name: bruno
- Company: ufpb
Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Yes.
I dont understand very well.
At the same time, in the log of mysql show me this:
/var/log/mysql/error.log
180201 11:55:48 InnoDB: ERROR: the age of the last checkpoint is 9434075,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:04 InnoDB: ERROR: the age of the last checkpoint is 9437612,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:20 InnoDB: ERROR: the age of the last checkpoint is 9434135,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:43 InnoDB: ERROR: the age of the last checkpoint is 9449825,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:04 InnoDB: ERROR: the age of the last checkpoint is 9438727,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:20 InnoDB: ERROR: the age of the last checkpoint is 9442345,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:37 InnoDB: ERROR: the age of the last checkpoint is 9437790,
InnoDB: which exceeds the log group capacity 9433498.
Now i question, have connection with the error?
I dont understand very well.
At the same time, in the log of mysql show me this:
/var/log/mysql/error.log
180201 11:55:48 InnoDB: ERROR: the age of the last checkpoint is 9434075,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:04 InnoDB: ERROR: the age of the last checkpoint is 9437612,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:20 InnoDB: ERROR: the age of the last checkpoint is 9434135,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:56:43 InnoDB: ERROR: the age of the last checkpoint is 9449825,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:04 InnoDB: ERROR: the age of the last checkpoint is 9438727,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:20 InnoDB: ERROR: the age of the last checkpoint is 9442345,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
180201 11:57:37 InnoDB: ERROR: the age of the last checkpoint is 9437790,
InnoDB: which exceeds the log group capacity 9433498.
Now i question, have connection with the error?
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
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
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 407, <$FH> chunk 1.
This time I tried otrs-5.0.23-01.noarch.rpm -> otrs-6.0.10-01.noarch.rpm
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 407, <$FH> chunk 1.
This time I tried otrs-5.0.23-01.noarch.rpm -> otrs-6.0.10-01.noarch.rpm
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.
Any tips?
There must be some weird letters or something in the database but the question is how to find those.
-
- Znuny advanced
- Posts: 103
- Joined: 23 Dec 2010, 23:01
- Znuny Version: 6.0.18
- Location: Lauda-Königshofen
Re: DBUpdate-to-6.pl: utf8 "\xE1" does not map to Unicode at /opt/otrs/Kernel/System/Main.pm line 340, <$FH> chunk 1
Hey,
i still have the same Problem. How did you fix it?
i still have the same Problem. How did you fix it?
MfG Thomas
Produktiv:
OTRS: 5.0.9
ITSM: 5.0.?
FAQ: 5.0.?
OS: Debian 9.8 x64
Application: Apache2/MySQL 5.5
VM auf: VMware ESXi 6.5
E-Mails: MS Exchange 2013
-- Achtung, es folgt ein Witz:
-- weiter geht's im Thread…[/size]
Produktiv:
OTRS: 5.0.9
ITSM: 5.0.?
FAQ: 5.0.?
OS: Debian 9.8 x64
Application: Apache2/MySQL 5.5
VM auf: VMware ESXi 6.5
E-Mails: MS Exchange 2013
-- Achtung, es folgt ein Witz:
Code: Select all
# dpkg-reconfigure brain
Paket »brain« ist nicht installiert und es ist keine Info verfügbar.
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 here.
Still can't upgrade.
Any hints?
Still can't upgrade.
Any hints?
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> chunk 1
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> chunk 1
-
- Administrator
- Posts: 3963
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
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,
Check your current sysconfig (ZZZAuto.pm) first.
What is you current OTRS version?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
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!
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!