+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Bugs/Errors (https://community.letodms.com/forumdisplay.php?fid=11)
+--- Thread: Mimetype field in the db too short (/showthread.php?tid=381)
Mimetype field in the db too short - Jukkax - 10-15-2011
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.
RE: Mimetype field in the db too short - steinm - 10-16-2011
(10-15-2011, 11:24 PM)Jukkax Wrote: 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
RE: Mimetype field in the db too short - Jukkax - 10-16-2011
(10-16-2011, 01:30 AM)steinm Wrote:(10-15-2011, 11:24 PM)Jukkax Wrote: 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?
RE: Mimetype field in the db too short - steinm - 10-16-2011
(10-16-2011, 01:56 AM)Jukkax Wrote:(10-16-2011, 01:30 AM)steinm Wrote:(10-15-2011, 11:24 PM)Jukkax Wrote: 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
RE: Mimetype field in the db too short - Jukkax - 10-16-2011
(10-16-2011, 02:38 AM)steinm Wrote:(10-16-2011, 01:56 AM)Jukkax Wrote:(10-16-2011, 01:30 AM)steinm Wrote:(10-15-2011, 11:24 PM)Jukkax Wrote: 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.