gilesw's barcode mod for milestone2 oscommerce

[zaps]

Gilesw's barcode mod for milestone2 oscommerce seems to be a very useful contrib. But I am unable to install it.

 

http://www.oscommerce.com/community/contributions,1819

 

 

I always get the following error :

 

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

 

select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id , p.products_barcode from products p, products_description pd where p.products_id = '26' and p.products_id = pd.products_id and pd.language_id = '1'

 

[TEP STOP]

 

Anybody help me ?

[Almirena]

Take a look at my own reply to my problem here (also about 1054, but for comments field).

 

The solution should work for your problem, too, I believe, but in your case, the table is probably "products", not "orders".

[zaps]

Thanks Ingrid . It worked. I still have to test the module with a barcode.

but you have been very helpful.

[Almirena]

It's a pleasure - good luck with the barcoding.