Error message and no website

[partspete]

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.

[TheOracle]

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

- File
- db

?

[Ajeh]

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

[TheOracle]

NOTE: your table will be called:
zen_session

It's: zen_sessions actually.

[partspete]

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

[TheOracle]

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.

[partspete]

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

[TheOracle]

Thanks for the update and inputs.

[Ajeh]

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

[TheOracle]

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

http://www.zen-cart.com/forum/showpo...96&postcount=6