I have also had these periodically, mostly
when I’ve been copying cloning or importing database sites. The cause is
very loosley described as stale sessions. If you have mysql administrative
access,consider executing the following query:
DELETE FROM sessions
This will remove all entries from the
session table. The session table only contains information about people
currently logged in or connected to drupal, so it may be safely deleted,
especially during times of low activity.
I don’t know the root underlying
cause but this should get your site back up and running. Without risking
content.
As always, it’s good to make a mysql
backup using mysqldump prior to executing scripts like this.
Good luck,
Dave
From:
support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Mark Shropshire
Sent: Tuesday, January 09, 2007
4:32 PM
To: support@drupal.org;
brucewhealton@yahoo.com
Subject: Re: [support] Problem
with Drupal site
Bruce,
I get these every now and then on a number of sites and servers. I
couldn't find much info on it and the sites still seem to be running fine. I
would love to get details on how to resolve.
On Jan 9, 2007, at 3:52 PM, Bruce Whealton wrote:
Hi all,
My drupal site suddenly started displaying an error
that I cannot make sense of...nor do I know what to do. I have been using
Drupal to run a poetry magazine
online and a writer's community. Poetry submissions come in via the
drupal
submission queue. I haven't made any changes to the site code or
any admin
changes or any changes at all to the site. Thus the site error
comes as quite
an unexpected and confusing surprise. The error message is listed
below...
I hope that this can be fixed. I don't want to loose
the many poems submitted
and published and those awaiting publication. It would be over a year's
worth of
published poems that could be lost. Can someone help me, please, with
this
problem.
The error is included below. Please let me know if you have any
idea what I can do. I had thought that some backups were being made by
someone helping
me maintain the site but I cannot be sure if there is a recent backup available
on
the site.
Error message>>>
Fatal error: Duplicate entry '0'
for key 2 query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
('8cbce4316d9b4797ef37e81fee84a52f', 0, '68.213.148.90', 1168370359) in /home/brucew/public_html/home/includes/database.mysql.inc
on line 66
Thank you,
Bruce
--
[ Drupal support list | http://lists.drupal.org/
]