Page 1 of 1

MySQL Database Table Types Error

PostPosted:Mon Nov 12, 2012 10:35 pm
by okmuser
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

Re: MySQL Database Table Types Error

PostPosted:Fri Nov 16, 2012 8:20 am
by pavila
This bug is already corrected in the night build. We plan to make another release in a few days which fix these and other known problems.