1194 Table 'b' is marked as crashed and should be repaired

[magibson]

My server upgraded their php recently and now my website is down. They moved all of my files to an old server to keep me from having to upgrade my zencart but it still isn't working. Now I'm getting the following message when I try to access my website of www.sturgisrings.com

1194 Table 'b' is marked as crashed and should be repaired
in:
[select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = 1 and b.banners_id = bh.banners_id group by b.banners_id, b.expires_date, b.expires_impressions]
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.

Any idea what is wrong now and what can be done to fix it. I am losing business every day that this is not fixed. It looks like a zencart file that is messed up but my host doesn't know what to do to fix it nor do I. Any help would be greatly appreciated.

[DrByte]

1194 Table 'b' is marked as crashed and should be repaired

As shown in the "similar threads" links below, you or your host need to go into phpMyAdmin and Repair that table.

[magibson]

Thnks for the response. Sent message to my host to get somebody to go into my phpMyAdmin folder to fix the table. Is there a step-by-step walk-through somewhere for upgrading my version of zen cart that I could follow without having to hire somebody to do the upgrade? I have a feeling that I'm just going to continue to get errors until I upgrade to the latest zen cart version.

[magibson]

My Host tells me that there is NO Table 'b' in the database that is being used by my shopping cart. So Now what do I do?

[DrByte]

My Host tells me that there is NO Table 'b' in the database that is being used by my shopping cart. So Now what do I do?

Your host apparently doesn't know much about MySQL. If they couldn't read the error message and know what it means when you first told them about it, then they really ought not to be in the hosting business.

"b" refers to an "alias", which in this case refers to the table named "banners":
(and "bh" refers to the "banners_history" table)

[select b.banners_id, b.expires_date, b.expires_impressions,  sum(bh.banners_shown) as banners_shown from banners b, banners_history  bh where b.status = 1 and b.banners_id = bh.banners_id group by  b.banners_id, b.expires_date, b.expires_impressions]

Here's how to do it yourself:
1. log in to phpMyAdmin
2. on the left column, choose your database from the pulldown list
3. click on the banners table
4. now on the right-hand side of the screen you see several tabs. Click on the Operations tab.
5. click on the "repair table" link

[DrByte]

Is there a step-by-step walk-through somewhere for upgrading my version of zen cart

Several documents at www.zen-cart.com/upgrades

[magibson]

Several documents at www.zen-cart.com/upgrades

Thank you for the help. One of my host company's techs finally found a corrupt database that the others didn't notice and he repaired it and now the site is back up and running. I will now try to read the upgrade documents so I can upgrade to the latest zencart release and avoid more problems later.