Hi,

My taxonomy has got more than 5000 items.
I am trying this module to grant access to 1000 items to a user, but only around first 900 items are being saved!
Can anyone advise any fix to remove the limitation please?

many thanks in advance.

Comments

msamavi’s picture

msamavi commented

Any help please?

msamavi’s picture

msamavi commented
Priority: Normal » Critical
msamavi’s picture

msamavi commented

To add more details on the issue, I must say that for each user account the module saves only 996 taxonomies under 'Access by taxonomy' !

tinker’s picture

tinker commented

Tac_lite stores the ACL list in the 'users' table 'data' column. In MySql this column is type 'longblob' which can store 4294967295 bytes. Start by checking the table and see if the data column exceeds this for any user entry.

- If it does you have filled it to capacity and there is no easy fix.
- If it does not then you may need to adjust you database settings. Database available memory and the size of the communications buffers can restrict the amount of data transmitted between client and server.

If you are using a form page to set the values you could also be hitting a PHP form limitation depending on inputs used. Default PHP can submit 1000 variables.

msamavi’s picture

msamavi commented

Thank you very much tinker!
all fixed now

msamavi’s picture

msamavi commented
Status: Active » Closed (fixed)
tinker’s picture

tinker commented

@msamavi, Can you say what the problem was and how your fixed it? This will be useful if others experience the same issue.