Help - store stopped working!

[dobsy]

One of our Oscommerce sites suddenly stopped working today - the homepage now only displays the following error message - any ideas?

 

1016 - Can't open file: 'sessions.MYD'. (errno: 145)

 

select value from sessions where sesskey = '7be14ed3a8953faf5ca9c1067706995c' and expiry > '1124532153'

 

[TEP STOP]

[burt]

Use PHPMyAdmin to repair the sessions table.

[dobsy]

Use PHPMyAdmin to repair the sessions table.

<{POST_SNAPBACK}>

 

 

Thanks - I'm getting an error message in PHPmyadmin

 

"MySQL said: Documentation

#1016 - Can't open file: 'sessions.MYD'. (errno: 145) "

 

What do you suggest? Delete the table and remake it - (if so, what's it's structure?)

 

Could this have had anything to do with my server reaching 100% diskspace?

 

thanks for your help,

 

 

Rob

[♥Vger]

Sessions are only active for 20 or so minutes, but the information on those sessions remain stored in the database. Take a look and see just how much session data you have stored there!

 

Vger

[dobsy]

Take a look and see just how much session data you have stored there!

 

Vger

<{POST_SNAPBACK}>

 

I can't - looks like the table's corrupted! Is it ok to delete the table and set up a new one from scratch? - I think the fact it's corrupted is preventing the entire shop from working, because on entry the site cannot write a session to the db.

 

thanks,

 

Rob

[♥Vger]

via phpMyAdmin:

 

DROP TABLE IF EXISTS sessions;

CREATE TABLE sessions (

sesskey varchar(32) NOT NULL,

expiry int(11) unsigned NOT NULL,

value text NOT NULL,

PRIMARY KEY (sesskey)

);

 

Vger

[dobsy]

via phpMyAdmin:

 

DROP TABLE IF EXISTS sessions;

CREATE TABLE sessions (

  sesskey varchar(32) NOT NULL,

  expiry int(11) unsigned NOT NULL,

  value text NOT NULL,

  PRIMARY KEY (sesskey)

);

 

Vger

<{POST_SNAPBACK}>

 

THANKYOU! That worked. You are a lifesaver.

 

thanks again,

 

Rob