By dimitris_s on

I was just viewing my site when suddenly when electricity cut-off for a second or so. When i booted the server where drupal is, and my desktop pc and opened my site, there was this message that was saying too me, that due to that electricity cut-off something messed with mySQL.

user warning: Duplicate entry '8525' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://www.dobro.gr/node?destination=node', '192.168.0.2', 1, 'f6bfca78933ff8fac2e5b2c1bc0a1fa1', 5810, 1184165957) in C:\apache_root\includes\database.mysql.inc on line 172.

I saw from other topics that something like this can be fixed by altering the node_id through the sequences table of mySQL. The difference is that my error, says "INSERT INTO accesslog" and not "INSERT INTO node", so I need some expert advice on this.

Is there something that I have to alter through mySQL on some table?

How can I fix this? :(

Comments

jastraat’s picture

jastraat commented

I think accesslog just tracks who has accessed the site. If you don't mind losing that information, the easiest thing would be to empty that table. (I'd recommend backing the table up first just in case.)

-------------------

http://fraggles.artsci.wustl.edu (Drupal user documentation and development blog)

dimitris_s’s picture

dimitris_s commented

Thank you very much for your help! I emptied the accesslog table and it works fine now!

Funny thing but enough to make my anxiety grow more :

When I emptied the table, I refreshed the page through firefox, and I saw that the message was still there. You can imagine my face, when I saw that the message was still there lol - O.o - I had to clear my cache to see the "real result"..

Again, thank you very much jastraat! Be well!

jastraat’s picture

jastraat commented

Yeah, the browser cache has gotten me on a number of occasions too. *grin We got a similar DB error message when we transfered our databases to a new server, so I figured our solution might work for you.

-----------------

http://fraggles.artsci.wustl.edu (Drupal user documentation and development blog)

HanleyDesigns’s picture

HanleyDesigns commented

I'm also receiving this error, I'm unsure how to empty the table, any help with this would sure be appreciated! cheers

The structure of Table:accesslog below...

aid
sid
title
path
url
hostname
uid
timer
timestamp

HanleyDesigns’s picture

HanleyDesigns commented

I figured it out, in the SQL section of the database, I just entered the following command:

TRUNCATE TABLE tablename