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

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

Locked

Views: 4,883

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
12 Nov 2008, 12:54 AM
#1
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

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

12 Nov 2008, 1:07 AM
#2
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

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

12 Nov 2008, 1:03 PM
#3
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

any advice please?

12 Nov 2008, 4:01 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

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"

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 Nov 2008, 7:09 PM
#5
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

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 :D thanks again!

12 Nov 2008, 8:20 PM
#6
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

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)

12 Nov 2008, 10:26 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

What version of Zen Cart are you using?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 Nov 2008, 10:36 PM
#8
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

the latest the 1.38

12 Nov 2008, 10:42 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 Nov 2008, 10:42 PM
#10
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

i did to only recieve the error i posted above

12 Nov 2008, 10:56 PM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

ersio:

i did to only recieve the error i posted above

Then you need to talk to your server administrator because apparently you don't have the required permissions to use your database.
Either that or your server's disk drive is full and the database has no place to store its data.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 Nov 2008, 10:59 PM
#12
ersio avatar

ersio

New Zenner

Join Date:
Oct 2008
Posts:
41
Plugin Contributions:
0

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

i called yahoo to ask and they said there was no problem, but sent the problem on to their "engineer department" to see. I checked privaledges earlier and saw i had all, i then tested the code in another database and it worked fine. I'm not sure the problem yet. thanks for help