Code

Opened 6 years ago

Closed 6 years ago

#7381 closed (fixed)

1406, "Data too long for column" DataError in WindowsXP

Reported by: Emily <emilyw@…> Owned by: nobody
Component: Uncategorized Version: master
Severity: Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

I am getting a DataError at /admin/polls/poll/5/
(1406, "Data too long for column 'choice' at row 1"),
The data I'm trying to input is this below, as you can see it's not
very long. I'm working in windows. The
model field is set as a textfield which is taking longtext.

I am able to input the first three lines of this into
the database before I get this error message so I'm guessing it's not
any special characters nor the line breaks - this is the same with
other similar data. Also my MySQL database works fine inputing the
data as longtext without using Django.


input data:
">gi|3819788|emb|CAA09968.1| immunoglobulin heavy chain, constant region, alpha-2 subunit [Homo sapiens]
VPPPPPCCHPRLSLHRPALEDLLLGSEANLTCTLTGLRDAS
GATFTWTPSSGKSAVQGPPERDLCGCYSVSSVLPGCAQPWNHGETFTCTAAHPELKTPLTANITKSGNTF
RPEVHLLPPPSEELALNELVTLTCLARGFSPKDVLVRWLQGSQELPREKYLTWASRQEPSQGTTTFAVTS
ILRVAAEDWKKGDTFSCMVGHEALPLAFTQKTIDRLAGKPTHVNVSVVMAEVDGTCY"

Attachments (0)

Change History (1)

comment:1 Changed 6 years ago by Emily <emilyw@…>

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.