niota

navigate to your ini-file for mysql and activate the secure_file_priv option. set this config to the path within your install from where you want to load the BLOB into your niota mysql metadatabase.

secure_file_priv = C:/Apache24/htdocs/niota/tmp/upload
# set max allowed packet size to 64 MB
max_allowed_packet = 67108864

This settings tell mysql which folder is not privileged and from where is is allowed to load into meta db. Set also max_allowed_packet.

If you upload the BLOB into meta db using system API mdconfig_CatalogObjectBLOB take care that in the system settings in the admin pages there is also the same ''secure_file_priv“ configured with the same path. This second configuration is needed to concatenate the proper source path as you enter in this system API only the filename as parameter.

Maximum size of upload files is limited in php.ini. If you get an “upload error” one possible reason could be, that your file exceeds this upload file size limit.

To change this limit do this:

• Login onto the server where you want to change the value.
• Navigate to php-root folder …\php-7.3.8_x64
• edit php.ini and locate upload_max_filesize
• check edit in php.ini post_max_size it must be higher than 'upload_max_filesize“, since file data is posted via POST action
• change the value according your needs
• save the file and restart Apache webserver