<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<BR><BR><B><I>Larry Garfield <larry@garfieldtech.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">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, '68.213.148.90',<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 | http://lists.drupal.org/ ]<BR><BR>-- <BR>Larry Garfield AIM: LOLG42<BR>larry@garfieldtech.com 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 | http://lists.drupal.org/ ]<BR></BLOCKQUOTE><BR>