[horde] The preference "blacklist" could not be saved because its data exceeds the maximum allowable size

Jens Wahnes wahnes at uni-koeln.de
Thu Jun 14 08:25:30 UTC 2018


Alex Abbas | Columbus wrote:

> 
> When I try and blacklist an email in the Horde portal I am getting an error message - "The preference "blacklist" could not be saved because its data exceeds the maximum allowable size".

are you the administrator of the Horde installation in question or are 
you a user of it?

Apart from what I wrote about that topic back in April, you might be 
hitting the limit that is controlled by the $conf['prefs']['maxsize'] 
setting, with the default being 65535 AFAIK. So that would be an awful 
lot of email addresses blacklisted if you really have got ~65K bytes of 
email addresses saved there already (assuming an average length of 30 
bytes per email address, that would be approx. 2000 email addresses).

If you use a lower limit for $conf['prefs']['maxsize'] or don't employ 
the usual "SQL Database" backend for preferences, things might be 
different for you. If you do, however, employ an RDBMS backend for 
preference storage, you may want to check the current size of that pref 
(use an SQL statement to the effect of "select length(pref_value) from 
horde_prefs where pref_uid='your_horde_username_here' and 
pref_name='blacklist'").

> Can someone confirm if this is saying the blacklist has hit its limit for addresses that I can add to it or is it saying the email I am trying to blacklist is too big in size?

If you're talking about the length of the individual email address that 
you are about to add to the blacklist, I don't think there is any limit 
on that -- other that the general 65 K limit, that is.

> How do I increase the number of email addresses I can blacklist and how do I increase the size of the emails I am able to blacklist.

If you are hitting the limit emposed by $conf['prefs']['maxsize'], you 
could raise that through gearwheel icon, Administration, Configuration, 
Horde (horde), Preferences tab. Depending on the actual database system 
in use, 65535 might be the maximum there, depending on the table 
definition for the pref_value column ("TEXT", "BLOB", "LONGBLOB" or 
similar). I'd recommend shortening the list of blacklisted addresses in 
this case, however, because I don't think it makes any sense to 
blacklist thousands of email addresses.

Should you not be close to said limit, refer to what I wrote in april 
about the limits of blacklist entries set through the permissions 
system. So that would be gearwheel icon, Administration, Permissions, 
Filters (ingo), Backends, your backend name, "Maximum number of 
blacklist addresses (max_blacklist)".


Jens


More information about the horde mailing list