16MB limit with mysql

[preminik]

Hi,
I have successfully installed and configured OpenKM to use mysql as database (datastore), but I found out that this configuration limits the max file size to 16MB.

The files are uploading without any errors and confirmation is also displayed as file upload successful. But when I try to download the file it is only 0 bytes.

mysql is configured to allow upto 132MB files.

Please help..!

Thanks with regards,
Preminik.

[pavila]

So you have increased the maximum upload file size (max.file.size) and can upload them but they are empty when downloaded? OpenKM (and MySQL) give you any error when upload any file bigger than 16MB? Take a look at $JBOSS_HOME/server/default/log/server.log file.

[preminik]

Thanks for the reply Pavila,

My mistake, the original Datastore was on MyISAM engine.
I re-created the database and used InnoDB engine for the Datastore, all good now.

Thanks again.
Preminik