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

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

-- [ Drupal support list | http://lists.drupal.org/ ]

Thanks David & Laura for pointing me in the right direction I was then told:

mysql> delete from sessions; ERROR 145 (HY000): Table '.\drupal\sessions' is marked as crashed and should be repaired

Which after Googling around led me to:

C:\xampp\mysql\bin>mysqlcheck --repair drupal sessions -u root -p Enter password: ******** drupal.sessions OK

Which restored the site in a slightly broken state, if I can't fix that I'll start another thread.

Many Thanks to you both Phil

On 5/7/07, Metzler, David metzlerd@evergreen.edu wrote:

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

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]