Mimetype field in the db too short

[Jukkax]

The 70 char. mimetype field in the database is too short, example many MS Office 2007+ mimetypes are longer than that:

http://filext.com/faq/office_mime_types.php

Uploading these kind of documents results to an error message about too long mimetype.

[steinm]

The 70 char. mimetype field in the database is too short, example many MS Office 2007+ mimetypes are longer than that:

http://filext.com/faq/office_mime_types.php

Uploading these kind of documents results to an error message about too long mimetype.

I haven't seen those mimetypes. The next version of letodms will have longer fields for the
mimetype.

Thanks.

Uwe

[Jukkax]

The 70 char. mimetype field in the database is too short, example many MS Office 2007+ mimetypes are longer than that:

http://filext.com/faq/office_mime_types.php

Uploading these kind of documents results to an error message about too long mimetype.

I haven't seen those mimetypes. The next version of letodms will have longer fields for the
mimetype.

Thanks.

Uwe

Is it possible to fix the current db in 3.2.0?

Haven't checked yet but I'd image it's possible to edit the field length with MySQL tools without losing data?

[steinm]

The 70 char. mimetype field in the database is too short, example many MS Office 2007+ mimetypes are longer than that:

http://filext.com/faq/office_mime_types.php

Uploading these kind of documents results to an error message about too long mimetype.

I haven't seen those mimetypes. The next version of letodms will have longer fields for the
mimetype.

Is it possible to fix the current db in 3.2.0?

Haven't checked yet but I'd image it's possible to edit the field length with MySQL tools without losing data?

ALTER TABLE tblDocumentContent MODIFY mimeType varchar(100);
ALTER TABLE tblDocumentFiles MODIFY mimeType varchar(100);

should do it. Make a backup of the database before.

Uwe

[Jukkax]

The 70 char. mimetype field in the database is too short, example many MS Office 2007+ mimetypes are longer than that:

http://filext.com/faq/office_mime_types.php

Uploading these kind of documents results to an error message about too long mimetype.

I haven't seen those mimetypes. The next version of letodms will have longer fields for the
mimetype.

Is it possible to fix the current db in 3.2.0?

Haven't checked yet but I'd image it's possible to edit the field length with MySQL tools without losing data?

ALTER TABLE tblDocumentContent MODIFY mimeType varchar(100);
ALTER TABLE tblDocumentFiles MODIFY mimeType varchar(100);

should do it. Make a backup of the database before.

Uwe

Yeah, that solved the problem. Thanks.