Need Help!!

[Guest]

:'(

 

1062 - Duplicate entry '1-1641' for key 1

 

insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id) values ('1641', 'James', 'Granger', 'Sterrepad 64', '5571EK', 'Bergeijk', '150')

 

[TEP STOP]

 

 

We moved the shop from 1 server to another. Now we get this error.

 

We get this error in checkout_shipping_address.php

 

Basically it says that userd on't have a current shipping adres:

 

Shipping Address

 

This is the currently selected shipping address where the items in this order will be delivered to. Shipping Address:

 

 

,

 

 

We get the error when we fill in the adres details and press contine.

 

Please help!

 

Thanks for your time.

 

Sam Granger

[Guest]

Also get this error:

 

1054 - Unknown column 'customers_company' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('1282', 'Silvano Surano', 'Alfa Romeo 156 GTA', 'B?nzweg 10', '', 'Waltenschwil', '5622', 'Aargau', 'Switzerland', '0041 56 622 57 36', '[email protected]', '1', 'Silvano Surano', 'Alfa Romeo 156 GTA', 'B?nzweg 10', '', 'Waltenschwil', '5622', 'Aargau', 'Switzerland', '1', 'Silvano Surano', 'Alfa Romeo 156 GTA', 'B?nzweg 10', '', 'Waltenschwil', '5622', 'Aargau', 'Switzerland', '1', '', '', '', '', '', now(), '2', 'GBP', '1.00000000')

[♥Vger]

Well, I bet your customer would be happy to know that you have posted his name, address, zip code, e-mail address, and telephone number on a public forum!!!

 

Vger

[Guest]

Yes, i noticed but i can't edit the post :\

[ozcsys]

Yes, i noticed but i can't edit the post :\

<{POST_SNAPBACK}>

 

You might want to email one of the team members so they can do it.

[ozcsys]

Back to your problem, How did you go about moving the site? It seems like there is a mis-match between your files and your database.

[Guest]

basically, my brother redesigned a site and the sites host also moved along. I tried to move the shop but this didn't go smooth. I tried to install a newer version of oscommerce and use the old database but this probably created this error. Now looking for oscommerce v1.247

[ozcsys]

basically, my brother redesigned a site and the sites host also moved along.  I tried to move the shop but this didn't go smooth.  I tried to install a newer version of oscommerce and use the old database but this probably created this error.  Now looking for oscommerce v1.247

<{POST_SNAPBACK}>

 

You are correct that matching the old database and the new site caused the problems but you can match up the info you need to bring over. All you are talking about is your product, order, and customer info. I have not done this from an old site to a new one but I have transferred the info from sites with different mods and contributions added. If you have phpmyadmin you should be able to do it in an hour or two. First take the copy of your database with the info in it and strip all the unneeded tables keeping just the ones with info you need to keep. Then match each table to the new one adding any needed fields. Then once each table structure is the same as the ingoing database you can export the info and import it to your new store.