You are here: Home / Odoo 12 Changing Upload limits

Odoo 12 Changing Upload limits

by Hawke Robinson last modified Jan 12, 2021 09:57 PM
Since Odoo 13 was so inherently unstable we moved to Odoo 12 (had to fresh install, no backward migration option). This posting covers file and data size considerations.

Odoo12 has been very stable, even with many community modules.  This posting is about different options for file size limits, upload limits, and data size considerations. These are mostly just notes to myself in case I need to come back to these for future installs.

 

 

Nginx Front end upload limits:

https://www.soladrive.com/support/knowledgebase/4835/How-to-Increase-or-Limit-the-Database-Upload-Size-Allowed-for-Odoo-Front-End.html

...

server {
    client_max_body_size 300M;
    ...
    location / {
        ...
        proxy_send_timeout 300;
    }
}

 

 

 

Open Odoo Database Manager

Now you can launch the Odoo database manager and upload the backup file (change odoo-url to an actual URL of your Odoo instance):

https://odoo-url/web/database/manager

 

 

 

Odoo data size limits and design issues

https://www.odoo-consultants.com/odoo-data-size-limits/

  • Assess data volume from the beginning. Large clients already have quite a precise idea of how many transactions they run on a daily / weekly / monthly basis.
  • Each client is specific. Tables do not grow evenly inside all Odoo systems. They follow data flow logic and this is the one you ought to follow.
  • Modules, database structure, scaling, clustering, partitioning and indexing must be used according to data growth logic.
  • DO NOT use standard community modules just because you think they are going to make you gain time. Most of the modules I see can do the trick on small to medium-size implementations… but their API versioning and coding will be bottlenecks which will end-up ruining the implementation and make the system unusable in the long run.
  • Store data “store through”. DO NOT use functions. These will kill you with large data.

 

 

 

Change odoo forms to allow larger sizes

https://www.odoo.com/fr_FR/forum/aide-1/file-size-limit-error-42610

 https://www.odoo.com/fr_FR/forum/aide-1/error-in-attachment-from-documents-page-43823

 

addons/web/static/src/js/fields/basic_fields.js:        this.max_upload_size = 99 * 1024 * 1024; // 99 MB 

addons/muk_web_utils/controllers/backend.py: 'max_upload_size': int(params.get_param('muk_web_utils.binary_max_size', default=25))
addons/muk_web_utils/static/src/js/fields/image.js: this.max_upload_size = result.max_upload_size * 1024 * 1024;
addons/muk_web_utils/static/src/js/fields/binary.js: this.max_upload_size = result.max_upload_size * 1024 * 1024;

ddons/muk_web_utils/models/res_config_settings.py: res.update(binary_max_size=int(params.get_param('muk_web_utils.binary_max_size', 25)))

 

 

Navigation