Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ADD UPC Mod


mateo107

Recommended Posts

I've just installed the mods, and i think i did everything right, however, i get this error message, when trying to view products (in full) , or when trying to add new products:

 

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

 

select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_upc, p.products_image, 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 = '29'

 

[TEP STOP]

 

Any idea what i did wrong, and / or how to fix it? Thank yOU!

Link to comment
Share on other sites

The instructions had you add the field product_upc to the database instead of products_upc.

 

Rename the field to plural or drop the current product_upc field and add the correct version to the database.

Link to comment
Share on other sites

The instructions had you add the field product_upc to the database instead of products_upc.

 

Rename the field to plural or drop the current product_upc field and add the correct version to the database.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...