[support] Problem with Drupal site

[Jonathan D. Wright]

I think he means to delete all rows from your 'sessions' table.


On 1/10/07, Bruce Whealton <brucewhealton at yahoo.com> wrote:
>
> I'm not sure what you mean by flushing the table - not sure which table
> you mean or
> how to do that.  Sorry for my ignorance.  I also can point out, if it
> helps to know, that
> I haven't moved the site or done any debugging, or anything to the site.
> It was
> up fine one day and then it wasn't.  It hasn't loaded up once since this
> error
> first appeared.
> Bruce
>
> *Larry Garfield <larry at garfieldtech.com>* wrote:
>
> The only time I've seen this is when I'm running Drupal through a debugger
>
> (Zend) and I kill it part way through. It works again after I refresh the
> page, though.
>
> The session table contains state information for users currently logged
> into
> the site. Depending on your site, it may be safe to simply flush that
> table
> (along with the cache table). It's a not-uncommon thing to do before
> moving
> a site from one server to another. Any users currently logged in will get
> kicked out, and if you have any save-in-session features enabled those
> will
> be lost as well, but neither should be a permanent problem nor should
> doing
> so affect unpublished nodes. (Only you know if that's an acceptable
> trade-off.)
>
> On Tuesday 09 January 2007 6:31 pm, Mark Shropshire wrote:
> > 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/ ]
>
> --
> Larry Garfield AIM: LOLG42
> larry at garfieldtech.com ICQ: 6817012
>
> "If nature has made any one thing less susceptible than all others of
> exclusive property, it is the action of the thinking power called an idea,
>
> which an individual may exclusively possess as long as he keeps it to
> himself; but the moment it is divulged, it forces itself into the
> possession
> of every one, and the receiver cannot dispossess himself of it." -- Thomas
>
> Jefferson
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070110/55f1b344/attachment.htm