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@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@drupal.org [mailto:support- bounces@drupal.org] On Behalf Of erase Sent: Monday, May 07, 2007 2:30 PM To: support@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/ ]