Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Product trouble


Recommended Posts

Hi there I was copying my sql info from an old site to a new one,now I get theres problems


When I try to view the site

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

select customers_selected_template as template_selected from customers where customers_id = ''



When I try to view my products through the shopping cart

1054 - Unknown column 'p.products_image_med' in 'field list'

select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '421'



there are probably more problems but I havnt come across them yet.


What to do

Link to comment
Share on other sites

Looks like a page is calling for information from your database that is not there, for 2 different contributions.


Have you recently added contributions to your new store?

Wendy James


Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

my new store has some different contributions on there.

How can I transfer the info over to my new site without the contributions not getting in the way.

Link to comment
Share on other sites


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

  • Create New...