snubbr.com

Did microsoft's Tuesday's patch mess up anyone's Verisign SSL?

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...
Quick question: Did microsoft's Tuesday's patch mess up anyone's Verisign SSL? Hoping for any answer. Another question... I'm developing a (second) Verisign site using oscommerce and have never had to post to the forums before, but this one is beyond me... This is what I just did: I backed up my database in admin, then did an easy populate import, but forgot categories, so I went and restored the database and now have this error:.

1146 - Table 'retropolitan.sessions' doesn't exist.

Select value from sessions where sesskey = 'res4791amc9coi86lp92u0cts3' and expiry > '1232062533'.

[TEP STOP].

Site is www.retropolitan.com if that helps anyone. Any assistance would be greatly appreciated! Thank you, all...

Comments (7)

Hmm... I need to find out myself. I don't know what is the answer to your question. I'll do some poking around and get back to you if I find an good answer. You should email the people at Verisign as they probably could give you an answer..

Comment #1

Hi. Thank you so much for replying. I simply backed up the database using pure SQL from admin. Then, about 2 minutes later, I restored the database as it had been 2 minutes beforehand. Nothing more. That's a great suggestion. I'm going to compare my SQL database with another shop I did and see if there are other column differences...

Comment #2

I think this is worse than I thought. I am missing all of the following:.

Products_notifications.

Products_options.

Products_options_values.

Products_options_values_to_products_options.

Products_to_categories.

Reviews.

Reviews_description.

Sessions.

Specials.

Supertracker.

Tax_class.

Tax_rates.

Whos_online.

Zones.

Zones_to_geo_zones.

Meaning that the last table I now have is product_description...

Comment #3

Well the error you are getting is due to the table "sessions" not being present. I'd imagine that the suggested SQL fix I posted above would work..

Did you do the backup and restoring inside phpMyAdmin? If so what steps did you do specifically? If not, how did you do it?.

Edit: Sorry, didn't see that post above. Sounds like you've deleted some of your tables. You can either restore them with the backup (assuming you did it correctly) or you can run the following SQL. I sure hope that this wasn't a live store as you may find that some of your data is missing..

DROP TABLE IF EXISTS products_notifications;.

CREATE TABLE products_notifications (.

Products_id int NOT NULL,.

Customers_id int NOT NULL,.

Date_added datetime NOT NULL,.

PRIMARY KEY (products_id, customers_id).

);.

DROP TABLE IF EXISTS products_options;.

CREATE TABLE products_options (.

Products_options_id int NOT NULL default '0',.

Language_id int NOT NULL default '1',.

Products_options_name varchar(32) NOT NULL default '',.

PRIMARY KEY (products_options_id,language_id).

);.

DROP TABLE IF EXISTS products_options_values;.

CREATE TABLE products_options_values (.

Products_options_values_id int NOT NULL default '0',.

Language_id int NOT NULL default '1',.

Products_options_values_name varchar(64) NOT NULL default '',.

PRIMARY KEY (products_options_values_id,language_id).

);.

DROP TABLE IF EXISTS products_options_values_to_products_options;.

CREATE TABLE products_options_values_to_products_options (.

Products_options_values_to_products_options_id int NOT NULL auto_increment,.

Products_options_id int NOT NULL,.

Products_options_values_id int NOT NULL,.

PRIMARY KEY (products_options_values_to_products_options_id).

);.

DROP TABLE IF EXISTS products_to_categories;.

CREATE TABLE products_to_categories (.

Products_id int NOT NULL,.

Categories_id int NOT NULL,.

PRIMARY KEY (products_id,categories_id).

);.

DROP TABLE IF EXISTS reviews;.

CREATE TABLE reviews (.

Reviews_id int NOT NULL auto_increment,.

Products_id int NOT NULL,.

Customers_id int,.

Customers_name varchar(64) NOT NULL,.

Reviews_rating int(1),.

Date_added datetime,.

Last_modified datetime,.

Reviews_read int(5) NOT NULL default '0',.

PRIMARY KEY (reviews_id),.

KEY idx_reviews_products_id (products_id),.

KEY idx_reviews_customers_id (customers_id).

);.

DROP TABLE IF EXISTS reviews_description;.

CREATE TABLE reviews_description (.

Reviews_id int NOT NULL,.

Languages_id int NOT NULL,.

Reviews_text text NOT NULL,.

PRIMARY KEY (reviews_id, languages_id).

);.

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).

);.

DROP TABLE IF EXISTS specials;.

CREATE TABLE specials (.

Specials_id int NOT NULL auto_increment,.

Products_id int 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) NOT NULL DEFAULT '1',.

PRIMARY KEY (specials_id),.

KEY idx_specials_products_id (products_id).

);.

DROP TABLE IF EXISTS tax_class;.

CREATE TABLE tax_class (.

Tax_class_id int NOT NULL auto_increment,.

Tax_class_title varchar(32) NOT NULL,.

Tax_class_description varchar(255) NOT NULL,.

Last_modified datetime NULL,.

Date_added datetime NOT NULL,.

PRIMARY KEY (tax_class_id).

);.

DROP TABLE IF EXISTS tax_rates;.

CREATE TABLE tax_rates (.

Tax_rates_id int NOT NULL auto_increment,.

Tax_zone_id int NOT NULL,.

Tax_class_id int NOT NULL,.

Tax_priority int(5) DEFAULT 1,.

Tax_rate decimal(7,4) NOT NULL,.

Tax_description varchar(255) NOT NULL,.

Last_modified datetime NULL,.

Date_added datetime NOT NULL,.

PRIMARY KEY (tax_rates_id).

);.

DROP TABLE IF EXISTS geo_zones;.

CREATE TABLE geo_zones (.

Geo_zone_id int NOT NULL auto_increment,.

Geo_zone_name varchar(32) NOT NULL,.

Geo_zone_description varchar(255) NOT NULL,.

Last_modified datetime NULL,.

Date_added datetime NOT NULL,.

PRIMARY KEY (geo_zone_id).

);.

DROP TABLE IF EXISTS whos_online;.

CREATE TABLE whos_online (.

Customer_id int,.

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 text NOT NULL.

);.

DROP TABLE IF EXISTS zones;.

CREATE TABLE zones (.

Zone_id int NOT NULL auto_increment,.

Zone_country_id int NOT NULL,.

Zone_code varchar(32) NOT NULL,.

Zone_name varchar(32) NOT NULL,.

PRIMARY KEY (zone_id),.

KEY idx_zones_country_id (zone_country_id).

);.

DROP TABLE IF EXISTS zones_to_geo_zones;.

CREATE TABLE zones_to_geo_zones (.

Association_id int NOT NULL auto_increment,.

Zone_country_id int NOT NULL,.

Zone_id int NULL,.

Geo_zone_id int NULL,.

Last_modified datetime NULL,.

Date_added datetime NOT NULL,.

PRIMARY KEY (association_id),.

KEY idx_zones_to_geo_zones_country_id (zone_country_id).

);.

This post has been edited by.

Zeldaz.

: 16 January 2009, 00:16..

Comment #4

Your restore might be too big to complete in 1 go..

Create a copy of your backup..

Edit the backup, does it have drop and create statements for all tables?.

Split the file into several parts preferably starting each part with the.

If exists drop table command..

Import each one of the files..

Good luck.

G..

Comment #5

Thanks, again. Yeah, that's definitely what happened (somehow). I didn't do the restoration from phpMyAdmin, just used the backup database function in oscommerce admin. And then used the restore function in oscommerce admin. I just FTP'ed the backup out and am thinking that I can use that to restore everything. I need to know more SQL! Can I just import the backup (it seems complete)??..

Comment #6

Thanks. It's 940kb, so I think it should work in one go...

Comment #7

Thanks for all the help. I finally figured it out! For some reason, the restore was only partially successful and only restored 38 tables, then cut off the rest. I used the back up (Glad I did that!) and it restored everything. Pheeeeeeewww!..

Comment #8


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.