I think he means to delete all rows from your 'sessions' table.<br><br><br><div><span class="gmail_quote">On 1/10/07, <b class="gmail_sendername">Bruce Whealton</b> <<a href="mailto:brucewhealton@yahoo.com">brucewhealton@yahoo.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>I'm not sure what you mean by flushing the table - not sure which table you mean or
</div> <div>how to do that. Sorry for my ignorance. I also can point out, if it helps to know, that</div> <div>I haven't moved the site or done any debugging, or anything to the site. It was</div> <div>up fine one day and then it wasn't. It hasn't loaded up once since this error
</div> <div>first appeared.</div> <div>Bruce<div><span class="e" id="q_1100e792a200c48c_1"><br><br><b><i>Larry Garfield <<a href="mailto:larry@garfieldtech.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
larry@garfieldtech.com</a>></i></b> wrote:</span></div></div><div><span class="e" id="q_1100e792a200c48c_3"> <blockquote style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;">The only time I've seen this is when I'm running Drupal through a debugger
<br>(Zend) and I kill it part way through. It works again after I refresh the <br>page, though.<br><br>The session table contains state information for users currently logged into <br>the site. Depending on your site, it may be safe to simply flush that table
<br>(along with the cache
table). It's a not-uncommon thing to do before moving <br>a site from one server to another. Any users currently logged in will get <br>kicked out, and if you have any save-in-session features enabled those will <br>
be lost as well, but neither should be a permanent problem nor should doing <br>so affect unpublished nodes. (Only you know if that's an acceptable <br>trade-off.) <br><br>On Tuesday 09 January 2007 6:31 pm, Mark Shropshire wrote:
<br>> Bruce,<br>><br>> I get these every now and then on a number of sites and servers. I<br>> couldn't find much info on it and the sites still seem to be running<br>> fine. I would love to get details on how to resolve.
<br>><br>> On Jan 9, 2007, at 3:52 PM, Bruce Whealton wrote:<br>> > Hi all,<br>> > My drupal site suddenly started displaying an error that I<br>> > cannot make sense of...nor do I know what to do. I have been using
<br>> > Drupal to run a poetry magazine<br>> > online
and a writer's community. Poetry submissions come in via<br>> > the drupal<br>> > submission queue. I haven't made any changes to the site code or<br>> > any admin<br>> > changes or any changes at all to the site. Thus the site error
<br>> > comes as quite<br>> > an unexpected and confusing surprise. The error message is listed<br>> > below...<br>> > I hope that this can be fixed. I don't want to loose the many<br>> > poems submitted
<br>> > and published and those awaiting publication. It would be over a<br>> > year's worth of<br>> > published poems that could be lost. Can someone help me, please,<br>> > with this<br>> > problem.
<br>> > The error is included below. Please let me know if you have any<br>> > idea what I can do. I had thought that some backups were being<br>> > made by someone helping<br>> > me maintain the site but I cannot be sure if there is a
recent<br>> > backup available on<br>> > the site.<br>> ><br>> > Error message>>><br>> > Fatal error: Duplicate entry '0' for key 2 query: INSERT INTO<br>> > sessions (sid, uid, hostname, timestamp) VALUES
<br>> > ('8cbce4316d9b4797ef37e81fee84a52f', 0, '<a href="http://68.213.148.90" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">68.213.148.90</a>',<br>> > 1168370359) in /home/brucew/public_html/home/includes/
<br>> > database.mysql.inc on line 66<br>> ><br>> > Thank you,<br>> > Bruce<br>> > --<br>> > [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.drupal.org/</a> ]<br><br>-- <br>Larry Garfield AIM: LOLG42<br><a href="mailto:larry@garfieldtech.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">larry@garfieldtech.com</a> ICQ: 6817012
<br><br>"If nature has made any one thing less susceptible than all others of <br>exclusive property, it is the action of the thinking power called an idea, <br>which an individual may exclusively possess as long as he keeps it to
<br>himself; but the moment it is divulged, it forces itself into the possession <br>of every one, and the
receiver cannot dispossess himself of it." -- Thomas <br>Jefferson<br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.drupal.org/
</a> ]<br></blockquote><br>
</span></div><br>--<br>[ Drupal support list | <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br><br></blockquote></div><br>