<div>That did it! Thanks.</div> <div> </div> <div>BTW, for backing up the databases using mysqldump, is that something I can execute</div> <div>from phpmyadmin? I am using a cpanel access to the site. I wasn't seeing that</div> <div>as a specific application in the cpanel or the database pages.</div> <div>Bruce<BR><BR><B><I>"Metzler, David" <metzlerd@evergreen.edu></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <META content="Microsoft Word 11 (filtered medium)" name=Generator> <STYLE> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </STYLE> <STYLE> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt;
font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:blue; text-decoration:underline;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </STYLE> <DIV class=Section1> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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:<BR><BR><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">DELETE FROM sessions<o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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. <o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I don’t know the root underlying cause but this should get
your site back up and running. Without risking content. <o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">As always, it’s good to make a mysql backup using mysqldump prior to executing scripts like this. <o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Good luck, <o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <div
class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Dave<o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></div> <DIV> <DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> <HR tabIndex=-1 align=center width="100%" SIZE=2> </SPAN></FONT></DIV> <div class=MsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> support-bounces@drupal.org [mailto:support-bounces@drupal.org] <B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Mark Shropshire<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, January 09, 2007 4:32 PM<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> support@drupal.org; brucewhealton@yahoo.com<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [support] Problem with Drupal site</SPAN></FONT><o:p></o:p></div></DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Bruce,<o:p></o:p></SPAN></FONT></div> <DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></div></DIV> <DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">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. <o:p></o:p></SPAN></FONT></div></DIV> <DIV> <div class=MsoNormal><FONT face="Times New
Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></div></DIV> <DIV> <DIV> <DIV> <DIV> <DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">On Jan 9, 2007, at 3:52 PM, Bruce Whealton wrote:<o:p></o:p></SPAN></FONT></div></DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR><BR><o:p></o:p></SPAN></FONT></div> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Hi all,<BR> 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<BR> online and a writer's community. Poetry submissions come in via the drupal<BR> submission queue. I haven't made any changes to the site code or any admin<BR> changes or any changes at all to the site. Thus the site error comes as quite
<BR>an unexpected and confusing surprise. The error message is listed below...<BR> I hope that this can be fixed. I don't want to loose the many poems submitted<BR>and published and those awaiting publication. It would be over a year's worth of <BR>published poems that could be lost. Can someone help me, please, with this<BR>problem.<BR> 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 <BR>me maintain the site but I cannot be sure if there is a recent backup available on <BR>the site. <BR><BR>Error message>>><BR><B><SPAN style="FONT-WEIGHT: bold">Fatal error</SPAN></B>: Duplicate entry '0' for key 2 query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('8cbce4316d9b4797ef37e81fee84a52f', 0, '68.213.148.90', 1168370359) in <B><SPAN style="FONT-WEIGHT:
bold">/home/brucew/public_html/home/includes/database.mysql.inc</SPAN></B> on line <B><SPAN style="FONT-WEIGHT: bold">66<BR><BR>Thank you,<BR>Bruce</SPAN></B><o:p></o:p></SPAN></FONT></div> <DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">--<SPAN class=apple-converted-space> </SPAN><o:p></o:p></SPAN></FONT></div></DIV> <DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">[ Drupal support list | <A href="http://lists.drupal.org/">http://lists.drupal.org</A>/ ]<o:p></o:p></SPAN></FONT></div></DIV></DIV> <div class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></div></DIV></DIV></DIV></DIV></BLOCKQUOTE><BR>