144 Table zen_sessions is marked as crashed - GoDaddy

[popemil]

Headache!

Not because yesterday was raining and today is sunny, but because I have read forums and faq's for hours without solving my problem.

I guess I am not that lucky, thus I need a hand here, sorry for bugging you guys.

No modifications on my 1.3.9 zencart on Godaddy linux hosting since 5 months ago, and all of a sudden yesterday I got this both as a regular user and as admin, from more than one computer:

"
144 Table './min1022707533517/zen_sessions' is marked as crashed and last (automatic?) repair failed
in:
[select value from zen_sessions where sesskey = 'pi4i7h0e9i0nadn4kcmr90k324' and expiry > '1320824491']
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.
"

It happens pretty often on Godaddy I could see, that sites simply become unavailable for a while, I hope they don't get a habit to do this.

As I am a presumptuous person, I presumed it's their fault, and issued a complaint note a few minutes ago

However I have a little doubt, since entering FTP on my hosting I found things where I left them, so I am asking:

What the is happening, I have not modified anything, in months, it was all routine, and all of a sudden... 144 error (whatever that means)

Question, is there anything I can do to fix it from the backdoor?

Or should I keep pissing off the Godaddy personnel?

Thanks for the time,

Emil.

[DrByte]

You need to repair the table.
You can do that with phpMyAdmin, or with whatever other tools your hosting company offers you in their hosting control panel. For direct help, call their tech support.

[popemil]

Do you ever sleep Sensei?

Or is more than one answering under this DR Byte profile... lol

I understood but not all the concept, I do have full FTP and back destop access, no problem, all I need is to understand where exactly to go and what to do to fix the issue.

Godaddy replied sying this is not a problem of them but a Zen-Cart issue:


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

Discussion Notes
Support Staff Response
Dear Emil,

Thank you for contacting Online Support. We have reviewed your account and could not find any issues with the hosting server. The type of error you are experiencing is most likely caused by coding or scripting. Because we do not provide coding support, we are unable to determine what specifically in your code may be causing the error. However, the following may be of some assistance in diagnosing the problem:

http://www.zen-cart.com/

You may wish to review your code to determine if there are any issues, because it appears that is the most likely cause of the error. You may also wish to enable detailed error messages as a temporary diagnostic measure. The procedure for this will vary, depending on the scripting language being used. We also recommend consulting both the vendor's online documentation, as well as the large number of online forums dedicated to coding and scripting.

If you cannot access the administrative panel for Zen Cart you may be able to modify the necessary files through your file manager.

You can edit existing and create new website content through the FTP File Manager in your Hosting Control Center.

To Edit Website Content through the FTP File Manager


1. Log in to your Account Manager. (I know how to do that)

2. From the Products section, click Web Hosting. (I know how to do that)

3. Next to the hosting account you want to use, click Launch. (I know how to do that)

4. In the Content section of the Hosting Control Center, click the FTP File Manager icon. (I know how to do that)

5. Select the file to edit, and then click the menu bar Edit icon. (which one should I lay my hand on) To create a new file for your site, click the menu bar New icon.

6. Modify your file's content in the editing window. (and what should I modify exactly)

NOTE: The underlying source of an .htm or .html file can viewed in the HTML source editor. Click the menu bar HTML icon to view a file's underlying HTML. Click Ok to save changes made in this editor.


7. Click the menu bar Save File icon. Your changes will appear on your website momentarily. (I know how to do that)


Please let us know if we can assist you in any other way."

end of quotation

This time I give them credit, it mighyt not be their fault, and even if it is, I cannot prove it... lol

So, where exactly should I lay my hands on , what specific page and do what logic thing to make it happen right?

To be or not to be (programmer) this is the question (skull in hand, of course; mine)

[DrByte]

1. Quit GoDaddy. Clearly their support staff have NO CLUE what they're doing.
2. This is not a Zen Cart software problem to fix via FTP. It's a database problem. Your "zen_sessions" table receives many inserts and deletes all day. It's a high-traffic table. If the server encounters a problem which prevents it from properly storing or deleting a record, the table may be marked as crashed. Sometimes it will attempt to automatically repair itself. If that fails, you will see the error message you've reported.
If the GoDaddy tech person had any skill at all, they'd know exactly what to instruct you to do:

If you have phpMyAdmin:
- click on your database from the pulldown menu
- click on the Operations tab across the top
- choose the Repair option
- select the zen_sessions table
- Go.

If GoDaddy offers some other method to repair the table, use their method.

And find a better hosting company.



Also, the "Similar Threads" listed at the bottom of this page show other forum discussions where people have encountered the same problem, and how they fixed it.

[popemil]

Arigato sensei!

[swguy]

If you have phpMyAdmin:
- click on your database from the pulldown menu
- click on the Operations tab across the top
- choose the Repair option
- select the zen_sessions table
- Go.

Hopefully this will work, but I have seen cases where it doesn't. You may need to drop and recreate this table. Just use the definition from your version (1.3.9) of the sessions table (defined in zc_install/sql/mysql_zencart.sql) which is

CREATE TABLE sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) unsigned NOT NULL default '0',
value mediumblob NOT NULL,
PRIMARY KEY (sesskey)
);


You can just paste this into admin->Tools->Install SQL Patches and it will add the "zen_" prefix for you.

[RescoCCC]

The type of error you are experiencing is most likely caused by coding or scripting.

Wow, just wow. That has to be a copy/paste job. Nobody with even minimum experience would think that error was anything other than a database problem.

[GDJames]

I apologize for the answer that you recieved.

DrByte is correct about his assestment of the error being with the database. Http://x.co/az6X is a help article on how to access your phpMyAdmin. Once in there you can perform the functions previously mentioned by DrByte.

If you have phpMyAdmin:
- click on your database from the pulldown menu
- click on the Operations tab across the top
- choose the Repair option
- select the zen_sessions table
- Go.

Before you do I strongly suggest that you backup your database (http://x.co/az6a). Hope this helps.

James R
Social Media Specialist
GoDaddy.com

[popemil]

Unfortunately I am lost in woods... lol

In the database menu there is no Options and no repair in Godaddy php MyAdmin (provided by Starfield Technologies Inc.)

Thus I entered the "guilty" place, Zen Sessions table

Server: min1022707270946.db.6563892.hostedresource.com - Database: min1022707270946 - Table: zen_sessions
(below is the menu they allow me)
Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Empty
Drop


Field Type Collation Attributes Null Default Extra Action
sesskey varchar(32) latin1_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
expiry int(11) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
value mediumblob BINARY No Browse distinct values Change Drop Primary Unique Index Fulltext
With selected: Check All / Uncheck All With selected:
Print viewPrint view Propose table structurePropose table structureDocumentation
Add new fieldAdd field(s)At End of Table At Beginning of Table After
Indexes: Documentation Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop sesskey
Create an index on columns
Space usage Type Usage
Data 0 B
Index 1,024 B
Total 1,024 B
Row Statistics Statements Value
Format dynamic
Collation latin1_general_ci
Rows 0
Creation Nov 10, 2011 at 04:39 AM
Last update Nov 10, 2011 at 04:39 AM
Open new phpMyAdmin window

But there is an Repair table in the Operations Menu of the table, I used it:

SQL query:
REPAIR TABLE `zen_sessions`
[ Edit ] [ Create PHP Code ]



Full Texts
Table Op Msg_type Msg_text
min1022707270946.zen_sessions repair status OK


Query results operations Print viewPrint view Print view (with full texts)Print view (with full texts) CREATE VIEWCREATE VIEW

In other words they say is OK

I logged out, and tried to see my site as user:

144 Table './min1022707533517/zen_sessions' is marked as crashed and last (automatic?) repair failed
in:
[select value from zen_sessions where sesskey = 'llpenb43g22v15o8uhrcqgipi1' and expiry > '1320925667']

in other words it did not repaired it at all.

OK, today I solved nothing, BTW, what can I lose by reloading a blank database ? or something similar? Since I am no programmer this is jungle to me and I try to build a road-map in my head while understanding chinese of programing language!

[popemil]

Hopefully this will work, but I have seen cases where it doesn't. You may need to drop and recreate this table. Just use the definition from your version (1.3.9) of the sessions table (defined in zc_install/sql/mysql_zencart.sql) which is

CREATE TABLE sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) unsigned NOT NULL default '0',
value mediumblob NOT NULL,
PRIMARY KEY (sesskey)
);


You can just paste this into admin->Tools->Install SQL Patches and it will add the "zen_" prefix for you.

Not sure of this, but I shall give it a try, after all, what can go wrong...???? ("Trust me, I know what I'm doing" Sledge Hammer)