I just entered a record in the table, I specified the aid '2196625' (in other words, one more than the one that MySQL was complaining about). Somehow that seems to have fixed the problem. I can now enter new values in the table. MySQL just picked up from ...25 and continued with ...26, ...27 and so on.
Daniel.
Daniel Carrera wrote:
Hello,
Whenever I visit a page on my Drupal 5 website I get the following warning:
user warning: Duplicate entry '2196624' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('What are the Ingots?', 'node/1', '', '78.50.210.53', 0, 'ffdknj3d71h0p3ss7d5lb8ng66', 472, 1236783811
So I go to the 'accesslog' table. I can see that key 1 refers to the 'aid' field. I don't see anything unusual in this field. The value 2196624 is not at all present, so how can it be "duplicate"?
I don't know what to try. Any ideas?
Daniel.
[ Drupal support list | http://lists.drupal.org/ ]