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
That did it! Thanks.
BTW, for backing up the databases using mysqldump, is that something I can execute from phpmyadmin? I am using a cpanel access to the site. I wasn't seeing that as a specific application in the cpanel or the database pages. Bruce
"Metzler, David" metzlerd@evergreen.edu wrote: v:* {behavior:url(#default#VML);} o:* {behavior:url(#default#VML);} w:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} I have also had these periodically, mostly when Ive 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 dont know the root underlying cause but this should get your site back up and running. Without risking content.
As always, its 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/ ]
That did it! Thanks.
BTW, for backing up the databases using mysqldump, is that something I can execute from phpmyadmin? I am using a cpanel access to the site. I wasn't seeing that as a specific application in the cpanel or the database pages. Bruce
*//*
/*You should ask you ISP about that - it really depends how you are set up to access MySQL from your account.*/
-
Bruce Whealton -
Dan Robinson -
Metzler, David