+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Technical Support (https://community.letodms.com/forumdisplay.php?fid=10)
+--- Thread: "mimeType too long" error (/showthread.php?tid=379)
"mimeType too long" error - Jukkax - 10-14-2011
When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
RE: "mimeType too long" error - steinm - 10-14-2011
(10-14-2011, 04:02 PM)Jukkax Wrote: When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
The mimeType field in the database is 70 chars, which is too short for your mimetype, but
are you sure your mimetype is ok?
Uwe
RE: "mimeType too long" error - Jukkax - 10-14-2011
(10-14-2011, 08:23 PM)steinm Wrote:(10-14-2011, 04:02 PM)Jukkax Wrote: When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
The mimeType field in the database is 70 chars, which is too short for your mimetype, but
are you sure your mimetype is ok?
Uwe
Tested from three different Windows XP & 7 computers, every Office 2010 Word document failed with this error message. Haven't tested with Excel etc. yet. I guess the mimetype is announced by the application it self (MS Word in this case), so this is not something the user can fix?
If we need to expand the mimetype field in the database, what's the (non-destructive) procedure? I'm not very familiar with database manipulation/management.
EDIT: according to http://filext.com/faq/office_mime_types.php the 70 character mimetype field really is too short for todays mimetypes. I'll open up this in the bug/error forum.