144 Table zen_sessions is marked as crashed - GoDaddy

here is a picture of what I was talking about

This seems like a reasonable idea, but it's not. A static IP is expensive, and keeping your machine patched so that it's not vulnerable when it's on the public internet without a firewall is a full time job.

Static IP's aren't that expensive. I have a block of 8, (5 usable), from my ISP for $14.95 a month. I really should cancel them, though, since I don't use them anymore.

On the other hand, you're absolutely right about the headaches involved. I had my own web server for close to 10 years. I finally smartened up and realized that it made a lot more sense to use a real host than it did driving myself crazy keeping the thing running.

swguy:

Just like I told you here: http://www.zen-cart.com/forum/showpost.php?p=1078655&postcount=6

Admin->tools->Install SQL Patches

drop table sessions

create table sessions (use syntax from post I just gave)

That might work if I can access my admin page, but I could not, I had access denied both as user and as admin.... so my question was how could I do that from the my SQL backdoor of my host server, instead of using the "repair" button that didn't do any good.

barco57:

here is a picture of what I was talking about

Nice shoot, thanks. However that is not from Godaddy I presume, since it looks different from the options they gave me in the SQL database admin, not all hosts give you the same options, it's a jungle out there.

The issue is solved, the site is up and running again as admin and as users, after I made a lot of pressure, not because I managed to understand how to do it myself and made it, thus.... I am not that smart after all.. lol
See next reply, the way the treat clients....

Here is my last e-mail with Godaddy support and their reply after they did me the huge favor of fixing what they broke:

Customer Inquiry
I wander why you call yourself "support" if you give no support, and I wander why did I paid for your services if you provide only damages.
Here is something from one of the threads I started on this issue on various forums:

ME

Join Date: Aug 2010
Location: Italy, next to Venice, drop by when in premises.

Posts: 48

Re: 144 Table zen_sessions is marked as crashed - GoDaddy

Restore didn't do any good, so I am back in square 1.

Before I leave this hosting I need to do two things:

Number one, repair the darn problem and have the site up and running again

Number two, find a better and more reliable hosting place.

Thus I am looking for suggestions, opinions, methods, anything that might help.

Meanwhile I will keep bugging Godaddy, but at this point I don't trust them any longer.

11th November 2011, 11:33 PM

dude 1

Join Date: Feb 2006
Location: Tampa Bay, Florida

Posts: 3,811

Re: 144 Table zen_sessions is marked as crashed - GoDaddy

I would recommend you drop the table and recreate it from scratch.

12th November 2011, 10:43 AM

Dude 2

Join Date: Jan 2004

Posts: 50,575

Re: 144 Table zen_sessions is marked as crashed - GoDaddy

There was no need to do a restore.

You could simply do the repair or the drop-and-create using phpMyAdmin.

There are multiple levels of technical support staff at your hosting
company. If the junior staff cannot handle your request, escalate it to a higher level. Ask for their boss. Then if the next person cannot help,
ask for the manager above them. Then if they can't help, ask for the manager above them. Don't take no for an answer. You're a paying customer.

12th November 2011, 01:55 PM

dude 3

Join Date: Jun 2005
Location: Hertfordshire, UK

Posts: 7,386

Re: 144 Table zen_sessions is marked as crashed - GoDaddy

There is only one things that needs dropping here...

GoDaddy

Seriously... look at what this disastrous host has cost you... Possibly 30 to 40 hours in fathoming out what's gone wrong, and the same in downtime for your store... that is lost revenue to you.

The fix could have been done by their guys in under 30 seconds...

For a couple of dollars a month more, you can get PROPER E-COMMERCE HOSTING, on servers that are configured to handle it properly.

Cut your losses, don't even bother fighting them for refunds... just put it down to experience and get out of there.

This week alone we migrated two new clients - one from GoDaddy and the other from FastHosts (birds of a feather). All of us feel so much better - great sighs of relief!

-----------end of quotes-------------------------------------------

Therefore I want to be contacted by your technical manager and have the problem fixed.
Do not force my hand or I might be inclined to contact your company owner in person, and take my word, I can find ways to bother him a lot, telephone, e-mail, fax, until I get my problem solved, and most probably he won't be happy receiving overseas phone calls at home in the middle of the night because of you.
Regards,
Emil Pop.

As you could see I copy-pasted them our thread, taking away the names or any other indication to whom answered, but left in sight the date they joined and number of posts so that Godaddy personnel could see it was not a bunch of newbies like me responding.

Last message from them:

Our support staff has responded to your request, details of which are described below:

Discussion Notes
Support Staff Response
Dear Emil Pop,

Thank you for contacting Online Support. My name is Jenny and I am in Management in this department. Your correspondence has been directed to my attention for review. I have reviewed the entirety of your account and your ticket. I have reviewed your issue with our advanced support. After carefully reviewing your hosting account and database we were able to repair your database** as a one time courtesy**. In the future you will need to repair this yourself by using the instructions below.

Run REPAIR TABLE on an affected table

Log in to your Account Manager.

From the My Products section, click Web Hosting.

Next to the hosting account you want to use, click Launch.

In the Databases section of the Hosting Control Center, click the icon for the type of database you want to manage. On this page, you can create new databases, delete databases, make changes to existing databases, or export databases.

To access more advanced management functions, click Manage via... next to the database you want to export.

Enter your username and password for your database.

Click on the table name of the affected table.

NOTE:If phpMyAdmin is unable to display the table information, or encounters errors loading the table details page, another option would be to use the SQL button at the top of the left frame to enter your own query. You can repair the table manually by issuing the command REPAIR TABLE <tablename> in this SQL window.


Click on the Operations tab at the top of the right panel.

Click Repair table at the bottom of the right panel.

This command can take some time and will block some queries, such as
inserts, to the table.

WARNING:It is possible that the phpMyAdmin Web server will time out waiting for a response from this command. If this happens, do not issue it again. Use the processlist feature, and you'll likely see the REPAIR command still running. Wait for it to complete. On large tables, this can take hours.

Some other errors that may be caused by table corruption include:

Can't find file table.MYI.

Duplicate unique key or constraint on write or update.

Got error ERR from table handler. (ERR being a number).

Index file is crashed / Wrong file format.

No more room in index file.

No more room in record file.

Old database file.

Record file is crashed.

Record was already deleted (or record file crashed).

table.frm is locked against change.

Table is crashed and last repair failed.

Tables was marked as crashed and should be repaired.

Unexpected end of file.

We regret that our services did not meet your requirements, and again apologize for any inconvenience the matter has caused. We would appreciate the opportunity to assist you again in the future, and would be happy to discuss any other matters or concerns that you may have. Please do not hesitate to contact us directly.

Please let us know if we can provide you with further assistance.

Sincerely,

Jenny C.
Online Support Supervisor

I wander if this Jenny C. really exists or the poor dude that fixed my problem was told to send me this note signing like some Jenny, I have a presumption Godaddy is using offshore escorted services both for customer support reply (please read the word reply as "throwing smoke in the eyes") and for fixing the problem, and this is not necessarily bad, but they are not coordinated together and are not aiming to solve the problem but to suppress the user.

So in the end I blame BOB PARSONS (the owner) for all the mess in his darn company, can somebody deliver him this message?

There are FOUR fundamental and (in my opinion) irreconcilable problems when hosting on GoDaddy.

1. Their server architecture is archaic. They do not invest in their technology. They do the bare minimum to keep their costs down.

2. They stuff the servers to breaking point (and beyond). far, far too many sites all battling for the resources of these coal-fired servers.

3. They split the servers. Dbase on one, code and files on another.

4. They have apes working for them in the support dept. For the most part, they don't know what they are doing.

Your post above, where they go into long raptures about what may be wrong with the table, and what else may go wrong, and how long it may take to fix, is a shoddy attempt at "blinding you by science".

The fact that they go to this trouble to give the appearance of being "technically advanced" is disgraceful.

So... as I said... if your objective is to run an eCommerce site, and you want it to be secure, robust, reliable, fast, virtually no downtime... Allowing YOU to focus on getting customers, selling products, making profits...

Then go to a decent host. PM me if you need some recommendations. I know two who will migrate your site for FREE, and both these host are also EXPERTS in zencart, and eCommerce in general.

We have had a website on one of these hosts since August 2005. That's SIX YEARS. It has NEVER gone down, we have NEVER had a single problem, we have NEVER had to open a support ticket. The host just knows how to keep things running...

schoolboy:

There are FOUR fundamental and (in my opinion) irreconcilable problems when hosting on GoDaddy.

...

4. They have apes working for them in the support dept. For the most part, they don't know what they are doing.

On behalf of all apes everywhere, I must protest this slight. :smile:

swguy:

On behalf of all apes everywhere, I must protest this slight. :smile:

Actually Scott... you are right... How insensitive of me to throw such an insult at the primate community...