help please!

[Guest]

Hi,

 

I have been using an old version of oscommerce for about a year, just recently we had some security breaches and it was recommended I upgrade my oscommerce.

 

Fair enough; upload the new files, configure it, upload the images from the current shop to the new images folder, all was going well until i came to the db side of things.

 

Comparing the old db to the new oscommerce v2.2 db, some tables/fields seem different... the problem is, i need to transfer 2000+ customers, 300+ products, and i would like to migrate the admin stats, etc.

 

Is there an easy way to do this? or will i have to try and bodge the SQL code and manually insert all the customers some how?

 

Here is a snipit of the old SQL db code

 

 

CREATE TABLE `address_book` (
`customers_id` int(11) NOT NULL default '0',
`address_book_id` int(11) NOT NULL default '1',
`entry_gender` char(1) NOT NULL default '',
`entry_company` varchar(32) default NULL,
`entry_firstname` varchar(32) NOT NULL default '',
`entry_lastname` varchar(32) NOT NULL default '',
`entry_street_address` varchar(64) NOT NULL default '',
`entry_suburb` varchar(32) default NULL,
`entry_postcode` varchar(10) NOT NULL default '',
`entry_city` varchar(32) NOT NULL default '',
`entry_state` varchar(32) default NULL,
`entry_country_id` int(11) NOT NULL default '0',
`entry_zone_id` int(11) NOT NULL default '0',
PRIMARY KEY  (`address_book_id`,`customers_id`),
KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM;

 

 

 

and here is a new code snipet from the new db

 

 

CREATE TABLE `address_book` (
`address_book_id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL default '0',
`entry_gender` char(1) NOT NULL default '',
`entry_company` varchar(32) default NULL,
`entry_firstname` varchar(32) NOT NULL default '',
`entry_lastname` varchar(32) NOT NULL default '',
`entry_street_address` varchar(64) NOT NULL default '',
`entry_suburb` varchar(32) default NULL,
`entry_postcode` varchar(10) NOT NULL default '',
`entry_city` varchar(32) NOT NULL default '',
`entry_state` varchar(32) default NULL,
`entry_country_id` int(11) NOT NULL default '0',
`entry_zone_id` int(11) NOT NULL default '0',
PRIMARY KEY  (`address_book_id`),
KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

 

 

 

this example was taken from the customer table, just to see if i would be able to insert all the old data into the new db.

 

Thanks to anyone who can help me!

 

Dave

[Guest]

You do not mention what (old) version you are using but, if you look in the 2.2MS2 zip file there is a folder called extra

Look in there for the mysql diff

 

HTH

The_Bear

[Zartanex]

I have the same problem and it seems that there is nobody able to fix it. In my case i want to transfer the customers data from the old oscommerce to my new installation. The question is simple:

 

How to transfer customers data from and old address_book and customers tables to the new ones? :huh: