The limitation is in MySQL's "TEXT" data type, which is used for the relevant column ('setting_value' in the 'sched_conf_settings' table). That type stores up to 64KB.
If you change the data type to LONGTEXT, you'll get up to 4GB, which "ought to be enough for anyone" -- use the following query for that:
- Code: Select all
ALTER TABLE sched_conf_settings CHANGE COLUMN setting_value setting_value LONGTEXT;
I haven't tested this, so please back up your database before you start and give your site a quick explore to make sure there aren't unexpected ramifications.
FYI, next time you run an upgrade, the database schema sync will see the LONGTEXT column and attempt to turn it back into a TEXT column, in keeping with the database descriptor (dbscripts/xml/ocs_schema.xml); in order to prevent that from happening, change the type of the column in that descriptor from "X" to "XL".
Public Knowledge Project Team