Forum OpenACS Q&A: How to increase file size limit of all file storage nodes?

Collapse
1: How to increase file size limit of all file storage nodes?
Posted by Nima Mazloumi on 04/23/04 01:54 AM
Is there a way to increase the file size limit of all existing file storage nodes in dotlrn/openacs?

If not, which database table stores all limits so that I can change these settings right away in the database?

Greetings,
Nima

Collapse
2: Re: How to increase file size limit of all file storage nodes? (response to 1)
Posted by Jun Yamog on 04/23/04 08:51 AM
Hi Nima,

The setting are stored in apm_parameter_values.  You will have to join apm_parameters.

You will need something like this.

update apm_parameter_values set attr_value ='YOUR NEW SIZE' from apm_parameters ap where ap.parameter_id = apm_parameter_values.parameter_id and ap.package_key = 'file-storage' and ap.parameter_name = 'MaximumFileSize';

Please kindly test the update statement above, its not 100% sure.  But more or less that is the idea.

Collapse
3: Re: How to increase file size limit of all file storage nodes? (response to 1)
Posted by Nima Mazloumi on 04/23/04 09:55 AM
Thanx alot Jun :)