Forums / General Questions / Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

Locked

Views: 2,848

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
15 Aug 2007, 11:01 AM
#1
moncia avatar

moncia

New Zenner

Join Date:
Nov 2006
Posts:
57
Plugin Contributions:
0

Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

I have not done any changes to any settings, and my hosting company claims there is nothing wrong with the database.

Why does my store all of a sudden look like this?

http://www.commercial-use.com/shop

:frusty:

15 Aug 2007, 12:15 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

Your MySQL database has a problem with its "sessions" table.

Use your phpMyAdmin to "repair" the table.
You may need to ask your hosting company to repair it for you.

You should be telling them the specific error message:> 1016 Can't open file: 'sessions.MYI' (errno: 145)

.
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.

15 Aug 2007, 1:53 PM
#3
moncia avatar

moncia

New Zenner

Join Date:
Nov 2006
Posts:
57
Plugin Contributions:
0

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

I was able to repair the file - or at least it said so in phpMyAdmin

But now I get this message

1030 Got error 127 from storage engine
in:
[delete from whos_online where time_last_click < '1187184435']

15 Aug 2007, 3:42 PM
#4
moncia avatar

moncia

New Zenner

Join Date:
Nov 2006
Posts:
57
Plugin Contributions:
0

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

BTW - to get to the stores pages the right url is now http://www.commercial-use.com/shop/index.php

15 Aug 2007, 3:56 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

Do a repair on the next table listed ... sometimes there can be a few tables that need repair following a crash ...

Check with your hosting site to see if they know why your MySQL server crashed ...

NOTE: This is not something that should happen frequently ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Aug 2007, 4:00 PM
#6
crazycucumber avatar

crazycucumber

Zen Follower

Join Date:
Jan 2006
Posts:
403
Plugin Contributions:
0

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

Usually get this when you have a table over 4GB in size or the mysql has run out of disk space. ( error logs could have filled up )

Contact your host again , is the best thing to do at this point.

Various Zen cart sites !

15 Aug 2007, 5:10 PM
#7
moncia avatar

moncia

New Zenner

Join Date:
Nov 2006
Posts:
57
Plugin Contributions:
0

Re: Help - my site is down - 1016 Can't open file: 'sessions.MYI' (errno: 145)

:clap: THANK YOU SOOOOOOO MUCH