user warning: Data too long for column 'maxstring'
lewpano - November 1, 2009 - 23:30
| Project: | Table Wizard |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
After adding a couple of tables I get something like that
Data too long for column 'maxstring' at row 1 query: INSERT INTO tw_columns (twtid, colname, weight, primarykey, availablefk, secure, ignorecol, isempty, coltype, minlength, maxlength, minstring, maxstring) VALUES (20, 'Event_Details', 11, 0, 0, 0, 0, 0, 'text', 0, 19088, '', 'On Saturday 7 July&
(i cut the message)
So this field (Event_Details) does not appear in the table. This happens with all fields that have text, even when i tried to analyze a default drupal's table in which again I took the same error for the teaser field. As I've seen maxstring has 255 length so the error makes sense... but the behavior doesn't:)
#1
I tried this, adding a table with an 860-character text field, and it truncated silently when added to tw_columns. Is there any more info you can give me? Any more to the message following the long text? What version of MySQL are you using? What version of Drupal?
Thanks.