Re: ERROR 1439 (42000) at line 2440: Display width out of range for column
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Mon, 18 Dec 2017 10:03:24 -0500
Message-ID: <p18lbt$jgt$1_at_jstuckle.eternal-september.org>
>
> Hey Kees Nuyt ,
>
> Thanks for your reply.
>
> 2440 : `bk_rank` bigint(320) DEFAULT NULL
>
Date: Mon, 18 Dec 2017 10:03:24 -0500
Message-ID: <p18lbt$jgt$1_at_jstuckle.eternal-september.org>
On 12/18/2017 1:30 AM, Gowrishankar Pandurangan wrote:
> On Sunday, December 17, 2017 at 5:17:14 PM UTC+5:30, Kees Nuyt wrote:
>> On Sun, 17 Dec 2017 02:37:58 -0800 (PST), hiiamgowri_at_gmail.com
>> wrote:
>>
>>> Hello Team,
>>>
>>> I am getting an error
>>> "ERROR 1439 (42000) at line 2440: Display width out of range for column"
>>> when trying to import dump in to the MySQL5.5.
>>>
>>> Could you please anyone help me out to fix this issue.
>>>
>>> Thanks in advance!
>>
>> What's in line 2440 of the dump you are trying to import?
>>
>> awk '(NR==2440){print)' /path/to/your/dumpfile
>> --
>> Kees Nuyt
>
> Hey Kees Nuyt ,
>
> Thanks for your reply.
>
> 2440 : `bk_rank` bigint(320) DEFAULT NULL
>
The maximum value for a BIGINT column is 9,223,372,036,854,775,807. This means the maximum number of digits is 19 (+1 for a minus sign). 320 is more than that.
What version was the dump created on? How did you create the dump?
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Mon Dec 18 2017 - 16:03:24 CET