Zen Cart Logo
Forums / General Questions / TABLE CRASHED - URGENT, please help me...

TABLE CRASHED - URGENT, please help me...

Locked

Views: 1,065

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
25 Mar 2010, 6:06 AM
#1
scoutmom64 avatar

scoutmom64

New Zenner

Join Date:
Sep 2007
Posts:
14
Plugin Contributions:
0

TABLE CRASHED - URGENT, please help me...

MY website is giving this message at the main CUSTOMER LOGIN URL. My ADMIN is working fine though!

145 Table './singer_zencart1/zen_whos_online' is marked as crashed and should be repaired
in:
[delete from zen_whos_online where time_last_click < '1269495808']

NOTE: I have NOT made any changes or anything to cause this. I was not even online when it happened. My website has been up for YEARS and this has never happened before. PLEASE HELP, I AM LOSING CUSTOMERS OVER THIS. :(

25 Mar 2010, 6:10 AM
#2
kiddo avatar

kiddo

Totally Zenned

Join Date:
Jul 2006
Location:
SF Bay Area
Posts:
837
Plugin Contributions:
1

Re: TABLE CRASHED - URGENT, please help me...

Use your phpmyadmin tool to repair the table. Takes just a second.

25 Mar 2010, 6:22 AM
#3
scoutmom64 avatar

scoutmom64

New Zenner

Join Date:
Sep 2007
Posts:
14
Plugin Contributions:
0

Re: TABLE CRASHED - URGENT, please help me...

Oh, please tell me how to do this!!! I am forever grateful!!!

25 Mar 2010, 6:27 AM
#4
scoutmom64 avatar

scoutmom64

New Zenner

Join Date:
Sep 2007
Posts:
14
Plugin Contributions:
0

Re: TABLE CRASHED - URGENT, please help me...

I logged into my Cpanel. I found the PHPMYADMIN button, but all it does is bring up my database. PLEASE tell me where to go from here. I need this fixed asap.... I appreciate any help!

25 Mar 2010, 6:28 AM
#5
kiddo avatar

kiddo

Totally Zenned

Join Date:
Jul 2006
Location:
SF Bay Area
Posts:
837
Plugin Contributions:
1

Re: TABLE CRASHED - URGENT, please help me...

Start by going to your cpanel or whatever control panel your hosting company provides and find phpmyadmin. Open it.

On the left you should see a link for your database. click this.

Now toward the bottom of the screen about in the middle, there are a dropdown what to do with selected tables and a button to select all tables.

Select all tables and from the dropdown choose check table, then do it again choosing repair table, then again choosing optimize table.

All done.

If you are really unsure, pm me and I will walk you through on phone or do it for you. Free of course.

ps: your hosting company will often be able to do this for you just for asking.

25 Mar 2010, 6:33 AM
#6
scoutmom64 avatar

scoutmom64

New Zenner

Join Date:
Sep 2007
Posts:
14
Plugin Contributions:
0

Re: TABLE CRASHED - URGENT, please help me...

OMG!! YOU ARE SO AWESOME!!! I OWE YOU BIG TIME!!! You have saved the day and I am so happy!!!!! It worked!!! :clap: MY HERO!!!!!!

25 Mar 2010, 6:37 AM
#7
kiddo avatar

kiddo

Totally Zenned

Join Date:
Jul 2006
Location:
SF Bay Area
Posts:
837
Plugin Contributions:
1

Re: TABLE CRASHED - URGENT, please help me...

Am glad it fixed it up. Doing the optimize part may even help quicken things up if it has not been done in a long time.

You are a winner!

25 Mar 2010, 7:36 AM
#8
scoutmom64 avatar

scoutmom64

New Zenner

Join Date:
Sep 2007
Posts:
14
Plugin Contributions:
0

Re: TABLE CRASHED - URGENT, please help me...

I'm curious. What is the optimize part? Do tell!!!