1

Topic: Error at modification of table structure

Good afternoon, colleagues help to understand what to make, there is a table dataful:

Attachment
ID INT (10) PK
FILEBLOB LONGBLOB
FILENAME varchar (1024)
CREATEDATE date
CREATE_ID INT (10)
NOTE varchar (255)

At attempt to remove restriction NOT NULL and generally to attempt to add a column there is an error (the screen see)
Change of fields VARCHAR on TEXT does not give results, also tried to make the table

ALTER TABLE tableName ENGINE = InnoDB ROW_FORMAT = Dynamic;

There is a same error, version MySQL 5.6.22

2

Re: Error at modification of table structure

Screen

3

Re: Error at modification of table structure

If I change type field LONGBLOB on BLOB an error transits, but after that mysql gone away
What to do how to get rid of an error?

4

Re: Error at modification of table structure

Go a standard sparing way - creation of the new table with demanded structure, copying of the data, renaming of the old table, renaming of the new table.