MariaDB

Couldn't import zoneinfo to MariaDB on Debian squeeze

Bug #780108 reported by Mikhail Gavrilov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
New
Undecided
Unassigned

Bug Description

Data import ending with fatal error: ERROR 1406 (22001) at line 39365: Data too long for column 'Abbreviation' at row 1

mikhail@p5k:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql
Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh87' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh88' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh89' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh87' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh88' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh89' as time zone. Skipping it.
ERROR 1406 (22001) at line 39365: Data too long for column 'Abbreviation' at row 1

Revision history for this message
Colin Charles (ccharles) wrote :

Which version of MariaDB was this? Where did you get the version of MariaDB from?

Revision history for this message
KAMI (kami911) wrote :

I found this burgeport via searchnig "Data too long for column 'Abbreviation' at row 1"
I set the | sql_mode | STRICT_TRANS_TABLES
I am using Ubuntu 10.04 / MySQL version 5.1.41-3ubuntu12.7-log

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.