1105 File './root/sessions.MYD' not found (Errcode: 13)

[ersio]

I know i know ive seen this topic before and i checked each and every post. when i ran repair, all i get is root.sessions repair error File './root/sessions.MYD' not found (Errcode: 13)

I dont know what to do from here? Im afraid to delete the table as some suggested cause i dont know how to apply a backup

[ersio]

I want to empty the sessions table but it wont let me click the option, says "in use"

[ersio]

any advice please?

[DrByte]

drop the table and recreate it

You'll fiind the proper syntax for creating the table in the /zc_install/sql/mysql_zencart.sql file ... search for "create table sessions"

[ersio]

thanks for the response, but i must be to illiterate as im not sure how to recreate, i see the create table sessions but now sure how to do it, maybe you could elaborate more thanks again!

[ersio]

sorry for another post but i couldnt find how to edit/delete post.

i ran a sql query to get this:
1 - Can't create/write to file './root/sessions.MYD' (Errcode: 13)

[DrByte]

What version of Zen Cart are you using?

[ersio]

the latest the 1.38

[DrByte]

For v1.3.8, you would open phpMyAdmin, choose your database from the pulldown menu on the left, then click the "SQL" tab on the right, and paste this into the command window, and click Go:

DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
  sesskey varchar(32) NOT NULL default '',
  expiry int(11) unsigned NOT NULL default '0',
  value mediumblob NOT NULL,
  PRIMARY KEY  (sesskey)
) TYPE=MyISAM;

You should be reporting this database problem to your hosting company or server administrator ... because database corruption such as you're talking about shouldn't be happening.

[ersio]

i did to only recieve the error i posted above