We've been trouble shooting an issue with new documents not being stored in the file framework library. We've narrowed it down to the mime type for the Microsoft Office 2007 and newer formats. The column 'type' in the Database table file_node table is set to varchar(64). The type description for the MS files are about 71 characters long (some are shorter a bit).

Has anyone else run into this problem? We will be working on a small patch for our instance.

This is a Windows 2003 server, running IIS6.

Error Message in site log

Data too long for column 'type' at row 1 query: INSERT INTO file_nodes (nid, vid, uri, size, type, views, downloads) VALUES (37, 39, 'bitcache://712d66a727a4255b334674f44abf7d11be477be2', 65024, 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 0, 0) in E:\www\IIS\Communities6\includes\common.inc on line 3436.

Comments

miglius’s picture

Status: Active » Fixed

This is already fixed in the dev version.

Status: Fixed » Closed (fixed)
Issue tags: -data length, -Microsoft Office, -DOCX, -PPTX, -DOTX

Automatically closed -- issue fixed for 2 weeks with no activity.