Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / General Questions / Getting Error in Admin - What does this mean?

Getting Error in Admin - What does this mean?

Locked
Results 1 to 16 of 16
This thread is locked. New replies are disabled.
19 Aug 2006, 19:20
#1
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Getting Error in Admin - What does this mean?

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? :unsure:
19 Aug 2006, 20:21
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: Getting Error in Admin - What does this mean?

in addition, you should notify your host of the problem, as it suggests a risk of database-corruption.
19 Aug 2006, 20:35
#4
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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

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.
19 Aug 2006, 20:38
#5
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Posts:
1,349
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

Can you go to the phpmyadmin and let us know how many tables can you see there?
SAn
19 Aug 2006, 20:47
#6
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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.
19 Aug 2006, 20:52
#7
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Posts:
1,349
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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 ;


-------
19 Aug 2006, 20:53
#8
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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.
19 Aug 2006, 20:57
#10
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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.
19 Aug 2006, 20:58
#11
superprg avatar

superprg

Totally Zenned

Join Date:
Feb 2006
Posts:
1,349
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

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.

if the table is there, dont run the sql
19 Aug 2006, 21:08
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: Getting Error in Admin - What does this mean?

I just spoke with Jim ... running a repair of the table via cPanel should resolve it.

- cPanel
- MySQL
- look at your databases
- click the "Repair" link to the right of the database name
19 Aug 2006, 21:14
#13
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

Thanks Dr. Byte! I go try that right now. :)
19 Aug 2006, 21:19
#14
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

It worked!! :clap:

On the log when it was fixing it, it said:

xxxxxxxx_zc.admin_activity_log
info : Found block that points outside data file at 1388536
status : OK


For future reference, did I do something that caused this to happen?
19 Aug 2006, 21:23
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: Getting Error in Admin - What does this mean?

It was a rare server-side problem. Nothing done wrong on your part.
19 Aug 2006, 21:30
#16
boggled avatar

boggled

Zen Follower

Join Date:
Mar 2006
Posts:
286
Plugin Contributions:
0

Re: Getting Error in Admin - What does this mean?

Whew! I appreciate knowing I didn't 'break it'. :smile: