[support] Problem with Drupal site

[Metzler, David]

Yes, basically you want to do an "Export" from phpmyadmin (use the SQL
format).  Then if something went wrong you could always a new database
and  "import" the data to get back to the last good state.  

 

I've done this successfully from some of my cpanel managed sites. 


Dave

 

________________________________

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Bruce Whealton
Sent: Wednesday, January 10, 2007 3:52 PM
To: support at drupal.org
Subject: Re: [support] Problem with Drupal site

 

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 at evergreen.edu> wrote:

	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
<http://lists.drupal.org/> / ]

	 

 

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