Open Source Document Management System | OpenKM - MySQL Database Table Types Error

Because information matters

MySQL Database Table Types Error
Problems with installing OpenKM? No problemo, the solution is closer than you think.

Board index
OpenKM English Users Installation « You are here

MySQL Database Table Types Error

Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.

2 posts

2 posts

MySQL Database Table Types Error

#19298 by okmuser
Mon Nov 12, 2012 10:35 pm

Hi,

I believe some of the tables created by OpenKM is not of the correct type.

For eg. the column MNL_CONTENT in table OKM_NODE_EMAIL should be of BLOB type as it can contain binary objects - pictures, files and so on. but it is in VARCHAR type which throws an error when importing emails (error: Data too long).

I also noticed similar errors when importing my repository into 6.2 (from 5.1.11) where the documents contains some particular notes. I did't get a chance to look deep into this error but it may be the same issue again.

Can you please check whether the table data types are in align with ver 5.1.11 (especially BLOB types)

Cheers,
OkmUser