By kathc on

I started out a couple of hours ago with errors like the following when any of my users tried to login:

Access denied
user warning: Duplicate entry '1436353' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'access denied', 'user/14', 1, '', 'http://www.thing.ca/user/14', 'http://www.thing.ca/user', 'ip.address.of.user', 1277145331) in /var/www/vhosts/thing.ca/httpdocs/includes/database.mysql.inc on line 174.
You are not authorized to access this page.

Following various advice, I truncated the watchdog table and now there's no big error message any more, just:

Access denied
You are not authorized to access this page.

I've tried two different user names/passwords that were working early this morning.

The server did have some kind of problem earlier in the day, and was rebooted. All of my data seems to be fine, and it's only the one site (of mine) that's having this problem (the others are Drupal 6, in sub-domains of this one and they're acting fine).

⋅ Categories: Drupal 5.x

Comments

kathc’s picture

kathc commented

several tables needed repair - sessions, cache_page, node_count, and now it seems fine.

drupjab’s picture

drupjab commented

how did you repair these tables? I am having the same problem.

Soban’s picture

Soban commented

and me have too same problem