Error using addoc on CLI

[ericsmythe]

Historically each version of a document has a filetype and a mimetype. The filetype is basically the extension of the file you uploaded or inserted with adddoc. So it depends on the filename. Whether a version can be viewed online or not depends on the filetype and not on the mimetype.
adddoc doesn't set the filetype but only the mimetype. I should fix this.
A much cleaner solution would be to get rid of the filetype and stick with the mimetype only.

Uwe

I understand. I would like to find a temporary fix (IOW hack) until this is supported.
I tried:
mysql> UPDATE tblDocumentContent SET mimeType = 'image/png', fileType = '.PNG' where document = '17';

That just left an ugly icon and nothing clickable to Download or View Online. What else do I need to do for a View Online of documents uploaded with adddoc?

Thanks
Eric