Error message and no website

13 Jul 2006, 1:30 PM

#1

partspete

New Zenner

Join Date:: Dec 2005
Location:: Fort Wayne, Indiana
Posts:: 9
Plugin Contributions:: 0

Error message and no website

I can not go to my website or to the admin area, I get the following message:

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

Does anybody know what this means and if so how to fix it? Thanks, Peter.

13 Jul 2006, 1:33 PM

#2

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

In your includes/configure.php, and admin/includes/configure.php file, which sessions handling did you set ?

File
db

?

13 Jul 2006, 1:33 PM

#3

ajeh

Oba-san

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

Re: Error message and no website

Sounds like perhaps a MySQL crash ...

If you go to your phpMyAdmin ...

Select the session table and run the repair on it ...

NOTE: your table will be called:
zen_session

13 Jul 2006, 1:37 PM

#4

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

NOTE: your table will be called:
zen_session

It's: zen_sessions actually. :wink2:

13 Jul 2006, 1:38 PM

#5

partspete

New Zenner

Join Date:: Dec 2005
Location:: Fort Wayne, Indiana
Posts:: 9
Plugin Contributions:: 0

Re: Error message and no website

The sessions are set to db. I do not have phpMyAdmin. I did not set up the site so I am sorta limited here.

13 Jul 2006, 1:45 PM

#6

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

This was even problematic the first days I started with Zen-Cart as I have already posted this problem before on the old forum. Got fixed by -

replacing:

define('STORE_SESSIONS', 'db');

into:

define('STORE_SESSIONS', '');

from both configuration files. This should do the trick. :thumbsup:

13 Jul 2006, 1:54 PM

#7

partspete

New Zenner

Join Date:: Dec 2005
Location:: Fort Wayne, Indiana
Posts:: 9
Plugin Contributions:: 0

Re: Error message and no website

Thank you thank you thank you. It is all fixed now. I appreciate the help very much.

13 Jul 2006, 2:13 PM

#8

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

Thanks for the update and inputs. :thumbsup:

13 Jul 2006, 2:15 PM

#9

ajeh

Oba-san

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

Re: Error message and no website

Storing the sessions in the database is a better plan ...

Contact your hosting site and find out how to use phpMyAdmin and fix this correctly ...

Also find out if they know why the MySQL server had a problem ...

13 Jul 2006, 2:17 PM

#10

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

Would seem to be the case. I also found a detailed post that mentions it:

http://www.zen-cart.com/forum/showpost.php?p=33296&postcount=6

:wink2:

13 Jul 2006, 2:52 PM

#11

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Error message and no website

It just came back to me. If you're, also, using an older PHP version like PHP v4.3.10 or PHP v4.3.11, I remember encountering sessions issues back then. If you're using one of these two versions, (or even older), I'd strongly recommend you upgrade to the latest version of PHP. :wink2: