[development] Re: [Drupal bug] Access Control Rules Error
agentrickard at gmail.com
Thu Jun 29 13:12:15 UTC 2006
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.
Administer your SQL tables and set 'aid' to be an INT.
- Ken Rickard
> 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
> 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?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the development