Getting Error in Admin - What does this mean?

[Boggled]

I'm getting an error in my Admin area...even when I try to log off.
It keeps saying:

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

All I was doing was adding products/images. I haven't changed any settings or touched any of the code.

Before I got this error, my Admin section slowed to a crawl and was timing out.
Then I got a 0 DB_ERROR_NOT_CONNECTED message on both the website side and the admin side.

That corrected within just a minute or so and now the website is fine, but I'm getting this new error in the Admin no matter what I try to do.

Any ideas as to what's happened?

[superprg]

See here:

http://zen-cart.com/wiki/index.php/E...8errno:_145.29

[DrByte]

in addition, you should notify your host of the problem, as it suggests a risk of database-corruption.

[Boggled]

Thanks for the reply superprg. I just went and tried what the wiki page suggested and it told me that 'table did not exist'. That really makes me start to worry!

Thanks Dr. Byte - I'm hosting with Sashbox and I sent Jim an email when it started, but I haven't heard back from him yet.

I wondered if it was a server problem because when I first got the "0 DB_ERROR_NOT_CONNECTED", I went to Sashbox's support page to enter a ticket and I got a page full of errors there too.

After the 'Not connected' error cleared up, so did Sashbox's page. Looks like it's a problem solely in my Admin now. I have another site hosted with them and it's not having any problems whatsoever, but I don't know if they're on the same server.

I hope this doesn't affect people buying and paying for their stuff on my website!! Business has just started to pick back up and I've been getting some good sales.

[superprg]

Can you go to the phpmyadmin and let us know how many tables can you see there?
SAn

[Boggled]

Okay...I'm php challenged...where would it tell me this?

(I try to stay out of this area of my cpanel completely! LOL)


I see something that says Databases with my user name.
Under that it says: _phpbb1 (30) _zc (92)

Is that it?

It also has something in red saying 'No privileges' under the create new database.

[superprg]

Fin..._zc (92)
that means you have 92 tables and only one missing i.e. zen_admin_activity_log

click on _zc and run this sql to create the table

----------
CREATE TABLE `zen_admin_activity_log` (
`log_id` int(15) NOT NULL auto_increment,
`access_date` datetime NOT NULL default '0001-01-01 00:00:00',
`admin_id` int(11) NOT NULL default '0',
`page_accessed` varchar(80) NOT NULL default '',
`page_parameters` varchar(150) default NULL,
`ip_address` varchar(15) NOT NULL default '',
PRIMARY KEY (`log_id`),
KEY `idx_page_accessed_zen` (`page_accessed`),
KEY `idx_access_date_zen` (`access_date`),
KEY `idx_ip_zen` (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;


-------

[Boggled]

I clicked on the _zc database and it showed this table.

On that table is listed the ''admin_activity_log" that it's listing in the error.
Out beside it, under the column "Records" it says "In use" and every thing in the other columns are blank.

[superprg]

Go here and let us know the missing table first

http://www.zen-cart.com/wiki/index.p...atabase_Schema

[Boggled]

It looks like the zen_admin_activity_log is still there, but it's 'hung up' or something.

Should I still run the SQL you suggested?
Don't know if it makes a difference or not, my Zen version is 1.2.7 on this site.