[support] Newbie with a dead site

[Metzler, David]

At the mysql prompt.  

Mysql> delete from session; 

Mysql> delete fom cache; 

You might to another mysqlcheck after that just to be safe. 


-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of erase
Sent: Monday, May 07, 2007 3:07 PM
To: support at drupal.org
Subject: Re: [support] Newbie with a dead site

Hi Laura

Thanks for the suggestion but could you be a little more explicit, how
would I do that? I'm new to mysql as well as Drupal?

Many Thanks
Phil

On 5/7/07, Laura Scott <laura at pingv.com> wrote:
> Phil, you could just empty the sessions table. The net effect is that 
> everyone would have to log in again, that's all. You might try 
> emptying your cache table, too, while you're in there.
>
> Laura
>
> On May 7, 2007, at 3:48 PM, erase wrote:
>
> > Thanks Dave
> >
> > That did look hopefull reporting:
> >
> > drupal.users
> > warning  : 3 clients are using or haven't closed the table properly
> > status   : OK
> > drupal.users_roles                                 OK
> >
> > And now runs without error, but still reports the following on the
> > site:
> >
> > Warning: Table '.\drupal\sessions' is marked as crashed and should 
> > be repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions 
> > s ON u.uid = s.uid WHERE s.sid = '207a004ebaa486e50fc0560a9dc892a8' 
> > in C:\xampp\htdocs\includes\database.mysql.inc on line 172
> >
> > Thanks
> > Phil
> >
> > On 5/7/07, Metzler, David <metzlerd at evergreen.edu> wrote:
> >> You need to do a repair using the mysqladmin tools.  Something
like:
> >>
> >> mysqlcheck -u root -p --auto-repair drupaldbname
> >>
> >> Dave.
> >>
> >> -----Original Message-----
> >> From: support-bounces at drupal.org [mailto:support- 
> >> bounces at drupal.org] On Behalf Of erase
> >> Sent: Monday, May 07, 2007 2:30 PM
> >> To: support at drupal.org
> >> Subject: [support] Newbie with a dead site
> >>
> >> Perhaps I should start by saying that I'm obviuosly very daft for 
> >> not having backed up the last few days work! Where I now am after 
> >> power loss is with a site reporting:
> >>
> >> Warning: Table '.\drupal\sessions' is marked as crashed and should 
> >> be repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions

> >> s ON u.uid = s.uid WHERE s.sid = '207a004ebaa486e50fc0560a9dc892a8'

> >> in C:\xampp\htdocs\includes\database.mysql.inc on line 172
> >>
> >> But when I try running the command in mysql it just reports:
> >>
> >> mysql> select drupal
> >>     -> SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid 
> >> = s.uid WHERE  s.sid = '207a004ebaa486e50fc0560a9dc892a8';
> >> ERROR 1064 (42000): You have an error in your SQL syntax; check the

> >> manual that corresponds to your MySQL server version for the right 
> >> syntax to use near 'SELEC T u.*, s.* FROM users u INNER JOIN 
> >> sessions s ON u.uid = s.uid WHERE s.sid ' at line 2
> >> mysql>
> >>
> >> Any ideas where I go from here?
> >>
> >> Thanks
> >> Phil
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >>
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
--
[ Drupal support list | http://lists.drupal.org/ ]