nilla Posted August 14, 2010 Posted August 14, 2010 Hi, To get rid of all spams I have created a new mysql database in PhpMyAdmin and in this imported my old database. Then, I installed all the files in version 2.2a in a new folder and in the config I entered the new database login information. I have also uploaded my old Swedish language files in the new folder. I have thus got a new shop with my Swedish subtitles, but my products, special offers, reviews, and orders are superseded by all sorts of computer accessories. It seems that the new installation overwrote the entire database. When I changed the configure.php to the old database name I got the following error: "Copying files to remote side failed. Can not Open That File: Permission denied" And when I tried to update the new database with a stored copy of the old, I got the following error: "Error SQL query: - - Data in table "address_book` - INSERT INTO `address_book` (`address_book_id", "customers_id", "entry_gender", "entry_company", "entry_firstname", "entry_lastname", "entry_street_address", "entry_suburb"; "entry_postcode", "entry_city", "entry_state", "entry_country_id", "entry_zone_id`) VALUES (9, 9, 'f','', 'Karin', 'Ragnar', 'Sönagsv 46', NULL, '12360 ',' Farsta ', NULL, 203, 0), (8, 8,' m ','',' rock ',' Brattberg ',' Winter Brink path 15 ', NULL, '13332', 'Saltsjöbaden', NULL, 203, 0), (7, 7, 'f', 'Värkstaden GB AB "," Gunilla "," Brattberg', 'Bergsgatan 12', NULL, '11223 ',' Stockholm ', NULL, 203, 0); (6, 6, 'f', 'Värkstaden GB AB "," Gunilla "," Brattberg', 'Bergsgatan 12', NULL, '11223 ',' Stockholm ', NULL, 203, 0), (10, 10, 'f', 'western physical therapy', 'Katarina', 'bivstedt', 'nälsta hagv 12', NULL, '16347 ',' Spånga ', NULL, 203, 0), (11, 11,' f ',' Värkstaden GB AB "," Gunilla "," Brattberg ',' Bergsgatan 12 ', NULL, '11223', 'Stockholm', NULL, 203, 0), (12, 12, 'f','',[... ] MySQL said: # 1062 - Duplicate entry '9 'for key 1 " How do I do to get the new version of OsCommerce to work with my old database? Gunilla
Guest Posted August 20, 2010 Posted August 20, 2010 Gunilla, Change the Key to another value and try running it again. The error occurs when you have two identical keys which are unique to the table created. Chris
Recommended Posts
Archived
This topic is now archived and is closed to further replies.