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

[Celticlady]

:( I checked my site the other morning (haven't made any changes to it for weeks) suddenly I am getting a new error message. I have searched the forum for anythign remotly close but haven't found anything to help.

 

This error message is this on both my catalog and admin section.

 

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

 

select value from sessions where sesskey = '32dfe563083a2adf1a1b1b34b09d0135' and expiry > '1128612617'

 

[TEP STOP]

 

I was told on another forum board to try this link http://www.pownuke.com/phpmyadmin/index.php

 

I tried repairing the table as item #4 described but this is what happened.

 

4) Repairing a broken table

 

The typical error for a broken table contains the line mySQL error: Can't open file: 'table_name.MYI'. (errno: 145)

 

Click on the name of the table in the left column. Then click on the "Operations" tab. About half way down the page you will see a section called "Table Maintenance" Click on "Repair Table".

 

A results screen will then show a table in the right hand box of the second box labeled "Msg_text" and below that should say "OK".

 

 

but when I click on the operations tab there is nothing called table Maintenance or repair table. instead I get another error message to see it go to:

 

http://www.linksandloops.com/images/errormessage.jpg

 

So now what?? :huh:

 

Thanks in advance for any help on this issue.

 

Tina Richter

Jewelry Artist

http://www.linksandloops.com

[♥Vger]

Access your database via phpMyAdmin, locate the sessions table, tick the boxes next to each session and elect to 'drop' those sessions.

 

Vger

[Celticlady]

Access your database via phpMyAdmin, locate the sessions table, tick the boxes next to each session and elect to 'drop' those sessions.

 

Vger

 

I clicked on sessions but there is nothing else as a sub cat just a sessions link and when I click on it I get that second error I mentioned at http://www.linksandloops.com/images/errormessage.jpg so do I just drop the session itself? will it recreate itself?? Will this cause me to lose anything within my cart??

 

UGH!!! I know VERY little about PHP so I am kinda winging this. Haven't had many probs with my site that I couldn't figure out. Or ask questions and could fix. So I hope this is just as easy to handle. I would much rather be making jewelry then dealng with this LOL.

 

Thanks,

Tina Richter

Jewelry Artist

http://www.linksandloops.com

[Celticlady]

I FIXED IT!!!! WOOT!!

 

I deleted the Session and then recreated thank god I have a client that uses OSC so I just looked at what was need to create a sessions table.

 

Worked like a charm!!!

 

Thanks for your Help!! Now I can go make some more jewelry LOL

 

Tina Richter

Jewelry Artist

http://www.linksandloops.com

[allcam]

I FIXED IT!!!! WOOT!!

 

I deleted the Session and then recreated thank god I have a client that uses OSC so I just looked at what was need to create a sessions table.

 

Worked like a charm!!!

 

Thanks for your Help!! Now I can go make some more jewelry LOL

 

Tina Richter

Jewelry Artist

http://www.linksandloops.com

I had the same problem today. I also have to do the same: delete the session table and recreate a new session table. It works now.

[sealkid]

I had the same problem today. I also have to do the same: delete the session table and recreate a new session table. It works now.

 

yup, i just had to do the same for this error and run the SQL on 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)
);

 

anyone know what causes this to happen in the first place?

[CTE_Shopping]

yup, i just had to do the same for this error and run the SQL on 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)
);

 

anyone know what causes this to happen in the first place?

 

I have been using osCommerce for almost a year now and this is the most common problem I have. Out of the blue I have the session error and my site is OUT OF BUSINESS! Fixing it is one thing, but preventing it from happening would be of greater value. How about one of you brilliant programmers out there working no a permanent fix to this annoying problem. It would make my life a lot easier! I know there are some wonderful people out there what are incredibly helpful.

Thanks to all of you who take the time and make the effort to support those of us who remain clueless.

Sharron

[CTE_Shopping]

H E L P !I was unable to edit my last post. BOTH OF MY STORES ARE DOWN! After almost a year of struggling with one problem after another, fixing bugs, upgrading files and struggling with phpmyadmin, and even experienced wiping out my database of over 1000 items trying to use phpmyadmin. At this point, I am about ready to give up! When I first signed on support by others was very good. I never even got a response to my last three posts! If I can't fix this problem quickly and completely, I am going to go looking for another e-commerce resource.

 

https://df32.dot5hosting.com/~cteshopp/osCo...talog/index.php

https://df32.dot5hosting.com/~cteshopp/osCo...talog/index.php

 

Sharron Mirikitani