[support] Newbie with a dead site

erase erase02 at gmail.com
Mon May 7 21:29:58 UTC 2007


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


More information about the support mailing list