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