[support] Strange Database Error

[Daniel Carrera]

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