Zen Cart Logo
Forums / General Questions / 1194 Table 'counter_history' is marked as crashed

1194 Table 'counter_history' is marked as crashed

Locked

Views: 1,795

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
5 Nov 2009, 2:13 PM
#1
malejyetti avatar

malejyetti

New Zenner

Join Date:
Jul 2008
Posts:
4
Plugin Contributions:
0

1194 Table 'counter_history' is marked as crashed

Hello,

I ahve got problem with running the Zen Cart 1.3.8 not upgraded

it says this message : 194 Table 'counter_history' is marked as crashed and should be repaired
in:
[select startdate, counter, session_counter from counter_history order by startdate DESC limit 10]
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.

But I tried to reset this in Tools> Store Manager > and reset all

Can somebody help what else can I do, please?

6 Nov 2009, 3:46 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: 1194 Table 'counter_history' is marked as crashed

Have you tried to go to phpMyAdmin through the Control Panel of your domain and tried to do a Repair on the counter_history table?

12 Nov 2009, 7:53 PM
#3
malejyetti avatar

malejyetti

New Zenner

Join Date:
Jul 2008
Posts:
4
Plugin Contributions:
0

Re: 1194 Table 'counter_history' is marked as crashed

Thank you very much for help. I tried do it in admin - store manager - then reset counter history, but still the same. I don't really know what exactly do you mean. Coul you explain? I am not very good at php..

cheers
Petr:oops:

12 Nov 2009, 7:58 PM
#4
malejyetti avatar

malejyetti

New Zenner

Join Date:
Jul 2008
Posts:
4
Plugin Contributions:
0

Re: 1194 Table 'counter_history' is marked as crashed

1194 Table 'counter_history' is marked as crashed and should be repaired
in:
[select startdate, counter, session_counter from counter_history order by startdate DESC limit 10]
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.

12 Nov 2009, 8:03 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: 1194 Table 'counter_history' is marked as crashed

If you don't have access to phpMyAdmin to fix the database problem yourself, you'll need to talk to your hosting company for their assistance.

17 Dec 2009, 6:26 PM
#6
dready80 avatar

dready80

New Zenner

Join Date:
Dec 2009
Posts:
4
Plugin Contributions:
0

Re: 1194 Table 'counter_history' is marked as crashed

Hi,
I might be a little late in this thread, but all 1194 table crashed errors are simple to fix. Just visit your phpmyAdmin section of your host panel or cPanel, locate the table concerned, in this case 'counter_history', select it, and click on the repair table button. The repair button/link should be displayed somewhere around that page.
In addition, one should always optimize their entire databases. Everyone with a database, I believe, is provided with the optimize database option.

18 Dec 2009, 6:56 AM
#7
malejyetti avatar

malejyetti

New Zenner

Join Date:
Jul 2008
Posts:
4
Plugin Contributions:
0

Re: 1194 Table 'counter_history' is marked as crashed

Hi All,

finnaly all is warking, I didn't have a clue how to do it before. But now is it working again.

Many thanks
Petr