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