[development] Re: [Drupal bug] Access Control Rules Error

[sime]

Sounds like...
the access table key has been incremented ahead of the value in the 
sequences table. I don't know all the ways this can happen, so I won't 
hypothesize.

If you look at the structure of access table in phpmyadmin, the current 
autoincrement is shown next to "Next Autoindex". So make the value in 
sequences (WHERE name='access_aid') higher than that.

HTH
.s


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
>
>
>
>