[support] Newbie with a dead site

[Laura Scott]

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/ ]