snubbr.com

Is it safe to type in credit card information through an Verisign SSL proxy?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
First of all Is it safe to type in credit card information through an Verisign SSL proxy? Many thanks for any response. Second question.. Hello:.

As of last night, we've been running into some serious problems with our mysql database reporting errors quite frequently. I've searched around here and it seems that what I've been doing is what everyone else has had luck with. However, our situation is a bit different..

1016 - Can't open file: 'session.MYI' (errno: 145).

As a result of that error, I go into phpmyadmin and repair the sessions database file, and often times the who_online file is also corrupt, so I repair that file as well. Everything works shortly after that perfectly, however after about 30 minutes to an hour, the sessions.MYI file is corrupt again forcing me to have to repair it again..

Everyone once and a while, we will get this error:.

1030 - Got error 127 from storage engine.

As a result of that, I also repair the sessions and who_online file and all is well again. I am not aware of any changes with our host as of recently but am not sure where this repetitive problems lies within..

Any help would be GREATLY appreciated..

Thank you!..

Comments (38)

Of course! however you might want to make sure and wait for another member here to confirm it as I am on the fence. Better yet, why don't you e-mail the Verisign guys because they can give you an answer better...

Comment #1

I've started having the exact same problem today (never before) on a store that's been up and running for 2 years. I'm on Yahoo Verisign hosting (I know, I know, it's horrible). You?..

Comment #2

WOW, Yahoo hosting? We are on yahoo Verisign hosting as well. I have opened an engineering ticket with yahoo, but haven't heard back from them yet. I will be sure to tell them that there are other customers that are having the same exact issues..

Our store has been running flawlessly for about 2 years as well..

It sounds to me as if it is definately a host issue now that you confirmed the same symptoms, but the problem is going to be getting yahoo to recognize that it is a host issue..

Perhaps we can get in contact and try and team up to get yahoo to realize the issue is on their end..

This post has been edited by.

20squared.

: 16 August 2008, 20:37..

Comment #3

Hey John,.

Glad to know I'm not alone on this. Feel free to tell them that fabulalife.com is having the same issue..

After repairing the sessions and whos_online databases via phpmyadmin every 30 minutes to an hour (as you also described), I did go into the Yahoo Web Verisign hosting Control Panel > Create & Update > MySQL database and repaired the database (after backing it up, of course). No problems since doing that two days ago (fingers crossed!)..

Which Verisign site are you having troubles with, so I can let the Yahoo folks know if we still have issues?.

Thanks!..

Comment #4

So when the database was working properly, you went into the yahoo control panel and did a "Repair Database" that way and it has been problem free since then? I will try that right now. Thanks for the advice...

Comment #5

Yes, when it was working properly, after fixing via phpmyadmin. Let me know how it goes!..

Comment #6

No luck. Same error about an hour after doing a repair through the Yahoo control panel..

Did you call yahoo support at all? If so, what did they tell you?..

Comment #7

Maybe try doing the repair without fixing first? I tried to call Yahoo the other day but was on hold for 30 minutes and gave up...

Comment #8

Nothing is working. and no response from yahoo yet...

Comment #9

Having the same issues with my Yahoo site....talked with them 2 different times....no satisfactory response yet...this just started happening with me last week..

This post has been edited by.

Tep@its.msstate.edu.

: 19 August 2008, 12:33..

Comment #10

My Verisign site is down again.I'll let ya'll know what Yahoo says...

Comment #11

Set session to go to mysql.This can be done thru configure.php.

Also repair the session table if needed..

Satish..

Comment #12

Thanks for the reply, Satish..

I've done repair table sessions; multiple times and it only seems to fix the problem for 30 minutes just like John says is also happening with him..

My configure.php file is set to mysql (I think):.

Define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'.

Any other thoughts?..

Comment #13

Still haven't had a chance to sit on hold with Yahoo yet, but I decided to dump my sessions and whos_online tables and restore their default values from the osCommerce installation. Here's what I did in phpmyadmin:.

Drop table if exists sessions;.

Create table sessions (.

Sesskey varchar(32) not null ,.

Expiry int(11) unsigned not null ,.

Value text not null ,.

PRIMARY KEY (sesskey).

);.

Insert into sessions (sesskey, expiry, value) values ('ec9fa3c2c4a1da4d85735440e2646b7f', '1215577335', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:4:\"3_10\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}');.

Insert into sessions (sesskey, expiry, value) values ('323525dbf8f30f4fa7f4d31040f346d8', '1215577541', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:5:\"tools\";');.

Drop table if exists specials;.

Create table specials (.

Specials_id int(11) not null auto_increment,.

Products_id int(11) not null ,.

Specials_new_products_price decimal(15,4) not null ,.

Specials_date_added datetime ,.

Specials_last_modified datetime ,.

Expires_date datetime ,.

Date_status_change datetime ,.

Status int(1) default '1' not null ,.

PRIMARY KEY (specials_id).

);.

Drop table if exists whos_online;.

Create table whos_online (.

Customer_id int(11) ,.

Full_name varchar(64) not null ,.

Session_id varchar(128) not null ,.

Ip_address varchar(15) not null ,.

Time_entry varchar(14) not null ,.

Time_last_click varchar(14) not null ,.

Last_page_url varchar(255) not null.

);.

Insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'ec9fa3c2c4a1da4d85735440e2646b7f', '24.98.65.172', '1215575895', '1215575895', '/catalog/movies-action-c-3_10.html');.

Drop table if exists zones;.

Create table zones (.

Zone_id int(11) not null auto_increment,.

Zone_country_id int(11) not null ,.

Zone_code varchar(32) not null ,.

Zone_name varchar(32) not null ,.

PRIMARY KEY (zone_id).

);.

I did it this morning (About 6 hours ago) and no more errors today...

Comment #14

The table was getting corrupted and the repairs were not working the way they should have..

You dropped the table and then recreated that sorted the problem..

Thanks for placing the details of what You did..

Satish..

Comment #15

Hi all,.

Just to let you know that I am having the same problem (1016 - Can't open file: 'sessions.myi') and I am also using Yahoo Hosting. Many thanks for your instructions. My problem is fixed for now by repairing the sessions table. I will wait and see how long this lasts! Please post any comments you get from Yahoo..

Thanks again..

Helen...

Comment #16

I'm getting a somewhat similar error and I've got Yahoo Verisign hosting too:.

1030 - Got error 134 from storage engine.

Select value from sessions where sesskey = '866a52ea90d685cd23ad88009a7d3d3c' and expiry > '1220063657'.

[TEP STOP].

Any idea on what I can do to fix this?? Any kind of help is most appreciated...

Comment #17

Repair Your session table or delete and recreate session table..

Make sure Your session is stored in mysql..

Satish..

Comment #18

Yes yahoo is horrible. Get a real Verisign hosting account with Cpanel and you'll be much better off...

Comment #19

Hello:.

As of last night, we've been running into some serious problems with our mysql database reporting errors quite frequently. I've searched around here and it seems that what I've been doing is what everyone else has had luck with. However, our situation is a bit different..

1016 - Can't open file: 'session.MYI' (errno: 145).

As a result of that error, I go into phpmyadmin and repair the sessions database file, and often times the who_online file is also corrupt, so I repair that file as well. Everything works shortly after that perfectly, however after about 30 minutes to an hour, the sessions.MYI file is corrupt again forcing me to have to repair it again..

Everyone once and a while, we will get this error:.

1030 - Got error 127 from storage engine.

As a result of that, I also repair the sessions and who_online file and all is well again. I am not aware of any changes with our host as of recently but am not sure where this repetitive problems lies within..

Any help would be GREATLY appreciated..

Thank you!..

Comment #20

This sort of crash is apparently often a result of insufficient disk space. So maybe you should check to see whether your account has maxed out on it's allowed disk usage. Maybe talk to your Verisign hosting company to report the issue and get some assistance..

This post has been edited by.

Oschellas.

: 14 August 2008, 14:01..

Comment #21


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.