Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Upgrading problems


nilla

Recommended Posts

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...