Tcatomon Posted July 2, 2010 Posted July 2, 2010 I'm about on my last nerve with Netfirms and Oscommerce this week. I backed up my database both on my PC and on the server and upgraded to the newest version. When I try to restore from the onlinestore/admin/backups/ folder I get the error below. When I try to install the file from my desktop nothing happens at all. 1066 - Not unique table/alias: 'your' drop table if exists address_book, address_format, banners, banners_history, categories, categories_description, configuration, configuration_group, counter, counter_history, countries, currencies, customers, customers_basket, customers_basket_attributes, customers_info, geo_zones, languages, manufacturers, manufacturers_info, newsletters, orders, orders_products, orders_products_attributes, orders_products_download, orders_status, orders_status_history, orders_total, products, products_attributes, products_attributes_download, products_description, your, your, your, products_notifications, products_options, products_options_values, products_options_values_to_products_options, products_stock, products_to_categories, reviews, reviews_description, sessions, specials, tax_class, tax_rates, whos_online, zones, zones_to_geo_zones [TEP STOP] I'm about at wits end with this software. I'm scared all my product is gone! ...Have you tried turning it off and on again?
Jan Zonjee Posted July 2, 2010 Posted July 2, 2010 When I try to restore from the onlinestore/admin/backups/ folder I get the error below. How did this happen: products_description, your, your, your, products_notifications, Three database tables called "your" ? And do they exist in the backup file too? Sql backups are text files by the way (might be zipped or gzipped but they are still text files).
Tcatomon Posted July 2, 2010 Author Posted July 2, 2010 I have no idea to be honest. I just saved it out as it told me to. It's just a straight SQL file, not zipped or anything. It's the same file in both the backup on my PC and on the server. But can it be fixed...? ...Have you tried turning it off and on again?
Jan Zonjee Posted July 2, 2010 Posted July 2, 2010 I have no idea to be honest. I just saved it out as it told me to. It's just a straight SQL file, not zipped or anything. It's the same file in both the backup on my PC and on the server. But can it be fixed...? Since SQL files are text files it can be fixed since you can edit text files. For starters you could search the sql file for table products_description and then look further to see what the heck this table "your" is.
Tcatomon Posted July 3, 2010 Author Posted July 3, 2010 What.. exactly am I looking for once I find it? I don't know a thing about SQL files. Would it be possible if I uploaded it you could help? ...Have you tried turning it off and on again?
Jan Zonjee Posted July 3, 2010 Posted July 3, 2010 What.. exactly am I looking for once I find it? For the table products_descriptions you are looking for (this is the start of the backup for that table): drop table if exists products_description; create table products_description ( products_id int(11) not null auto_increment, language_id int(11) default '1' not null , products_name varchar(64) not null , products_description text , products_url varchar(255) , products_viewed int(5) default '0' , PRIMARY KEY (products_id, language_id), KEY products_name (products_name) ); insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('1', '1', 'Matrox G200 MMS', 'Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.<br><br>With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br><br>Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.', 'www.matrox.com/mga/products/g200_mms/home.cfm', '0'); So you could also look for a line like this: drop table if exists your; Although the strange thing is that osCommerce does not backup databases including this line: drop table if exists address_book, address_format, banners, banners_history, categories, categories_description, configuration, configuration_group, counter, counter_history, countries, currencies, customers, customers_basket, customers_basket_attributes, customers_info, geo_zones, languages, manufacturers, manufacturers_info, newsletters, orders, orders_products, orders_products_attributes, orders_products_download, orders_status, orders_status_history, orders_total, products, products_attributes, products_attributes_download, products_description, your, your, your, products_notifications, products_options, products_options_values, products_options_values_to_products_options, products_stock, products_to_categories, reviews, reviews_description, sessions, specials, tax_class, tax_rates, whos_online, zones, zones_to_geo_zones It does the "drop table" statement right before a "create table" and the "insert into" statetements that build up the table again.
Tcatomon Posted July 7, 2010 Author Posted July 7, 2010 Sorry, long holiday here, haven't had a chance to look into anything. The only thing I don't see anywhere in the file is "drop table if exists your;", everything shows up exactly like you have it. ...Have you tried turning it off and on again?
Tcatomon Posted July 7, 2010 Author Posted July 7, 2010 Well, after contacting Netfirms about this apparently the OsMax version is unable to talk to whatever version of the database this happens to be. Way to program your software, guys. e_e Considering OsCommerce has NEVER been user friendly and there's no way to get active tech support I think at this point I'm just going to look into other shopping cart options. Thank you for your time, Jan, I really appreciate it none the less. ...Have you tried turning it off and on again?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.