Actually, it means that you've hit the practical limit of the access table. The column 'aid' is set to a tinyint(), unsigned, which has a maximum value of 128 unique records. The table records 0 - 127, then you start to get errors. I had the same problem with the 'boxes' table. http://drupal.org/node/66961 Administer your SQL tables and set 'aid' to be an INT. - Ken Rickard agentrickard alextrup wrote:
Issue status update for http://drupal.org/node/71389 Post a follow up: http://drupal.org/project/comments/add/71389
Project: Drupal Version: 4.7.2 Component: base system Category: bug reports Priority: critical Assigned to: Anonymous Reported by: alextrup Updated by: alextrup Status: active
I wasn't sure which component to put this under.
I have been creating many access control rules, to deny certain usernames being used. I currently have 125 rules in the list (but I have aids up to 127 in my database with 1 or 2 aids missing - which were rules I deleted)
I now get the following error every time I try to add any additional rules
user warning: Duplicate entry '127' for key 1 query: INSERT INTO access (aid, mask, type, status) VALUES ('133', 'examplerule', 'user', 0) in /home/.jaunt/diversity/woo.sh/includes/database.mysql.inc on line 120. Is there a known limit on the number of rules that can be applied?
Thanks,
Alex
alextrup