My Site is down, HELP. All products and customers are gone???

[dochsa]

Hi My site is down and the customers and products are gone? It makes no sense to me as all the other information is there. I was haked a year ago but installed all the changes suggested.

This is what the admin page is saying:
1016 Can't open file: 'customers.MYI' (errno: 144)
in:
[select count(*) as count from customers]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What does that mean and how did this happen over night?

[picandnix]

ZC version?
Does your shopfront work?
A link to your site?
Do you have a Database backup?

[dochsa]

ZC version:
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
v1.3.8 [2008-04-16 08:41:03] (Fresh Installation)
v1.3.8 [2008-04-16 08:41:03] (Fresh Installation)

Shop Front does not work, I have however gone to the admin portal and changed status to shop maintenance to true

Link to the site: www.assceneon.co.uk or http://assceneon.dochsa.com/Shop/

I thought I did through Yahoo hosting, I also have the back up mod installed but it is all not working.

This is the error it without the maint window on:
1016 Can't open file: 'products.MYI' (errno: 144)
in:
[select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m where p.products_status = 1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '0' order by m.manufacturers_name]


Any help is appreciated.

Donovan

[stevesh]

Search the forums for error 1016 and you'll see several threads recommending that you empty the sessions table in the database and then run Repair on that table in phpMyAdmin.

You also should upgrade ASAP to at least 1.3.9h.

[dochsa]

I deleted the session table and now nothing works? Help? Nothing will back up either?

[dochsa]

This is what I get now:
0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[RodG]

I deleted the session table and now nothing works? Help? Nothing will back up either?

Big mistake. Database tables should NOT be deleted unless you know exactly what you are doing. You were supposed to *empty* the table, not delete it.

You can recreate the table by running the following SQL command

------------------------------------------------
CREATE TABLE sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) unsigned NOT NULL default '0',
value mediumblob NOT NULL,
PRIMARY KEY (sesskey)
) ENGINE=MyISAM;
----------------------------------------------------

If your database tables use a prefix (eg "zen_") you'll need to modify the "CREATE TABLES sessions" to read "CREATE TABLE zen_sessions" (or whatever prefix you are using).

I'm not sure if this is going to fix the 'Not connected' issue or not. That is usually the result of a different problem (configuration error). Notherless you still need to restore the deleted table.

Cheers
rod

[dochsa]

Just an update. I did not delete the sessions table I did just empty it. How vere Yahoo hosting upgraded me to version 5 sql and that caused all things not to work. I have rolled back and this has allowed me to get into the store atleast.

Thanks for all your help I appreciate it.