[support] Problem with Drupal site

[Metzler, David]

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 at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Mark Shropshire
Sent: Tuesday, January 09, 2007 4:32 PM
To: support at drupal.org; brucewhealton at 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/ ]

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070110/e9da049e/attachment.htm