tranfer shop

[jimakos]

i try to transer my shop from a server that runs fantastico (for install oscom) to a server not runs fantastico. i make a backup from phpadmin and put in new server.

But not working all ok, not show orders, appears a message "invalid field comments" also in my shop config appears "php script error .... "

 

Please advise :(

[ozcsys]

i try to transer my shop from a server that runs fantastico (for install oscom) to a server not runs fantastico. i make a backup from phpadmin and put in new server.

But not working all ok, not show orders, appears a message "invalid field comments" also in my shop config appears "php script error .... "

 

Please advise :(

You can not transfer the database information to a new shop unless the versions are exactly the same. If there are any contributions or site changes that involved the database on one site that is not on another you will get errors. When I transfer a shop from one place to another I do the following.

 

Transfer Steps

[jimakos]

the version are the same 2.2

the only diference is that the one istall from fantastico script

and the other from cgi adons

 

this is the message in orders edit

 

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

 

select 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, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '197'

 

[TEP STOP]

[ozcsys]

the version are the same 2.2

the only diference is that the one istall from fantastico script

and the other from cgi adons

 

this is the message in orders edit

 

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

 

select 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, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '197'

 

[TEP STOP]

Version is not the only issue. If there are any differences in the databases between the two it will not work. They obviously do not match or you would not bet getting the error message you are getting. What you need to do is follow the directions in my previous post and you will be up and running in no time at all. The files and database must match and the way to do this is copy the old site and ftp it to the new one instead of doing a fresh install.

[jimakos]

i try to transfer all the catalog from old to new ..... but sql error

i think no hope