HELP!! 1054 - Unknown column 'p.products_mediumimage' in 'field list'

[leoaperez]

Hi community, i need help

I made an mistake and I cannot add new products

 

this is the problem:

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_mediumimage, p.products_largeimage, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

can anybody help me?

 

By the way.. sorry about my english

 

Leo.

[bienenf]

Hi community, i need help

I made an mistake and I cannot add new products

 

this is the problem:

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_mediumimage, p.products_largeimage, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

can anybody help me?

 

By the way.. sorry about my english

 

Leo.

 

Hello Leo,

 

This is something related to mysql 5 compatibility. Have a look on the oscommerce update 060817.

 

Regards.

[oschellas]

The fields p.products_mediumimage, p.products_largeimage are not part of the standard installation so you must have installed an images contribution.

 

That contribution probably has an sql file to alter the products table.

My guess is that you have not executed that sql file.

[leoaperez]

Hello Leo,

 

This is something related to mysql 5 compatibility. Have a look on the oscommerce update 060817.

 

Regards.

 

thanxs Bienenf already instaled update 060817 but I still have problems

now I can put new products but then I cannot see them

 

when i click in some image it happens the same error:

 

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

 

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_mediumimage, p.products_largeimage, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '1423' and pd.products_id = p.products_id and pd.language_id = '3'

 

plz if u want enter in http://sexapple.com.ar/shop/ and try to click in any product, u'll see.

 

Thanxs again

[♥Vger]

'p.products_mediumimage' is not a part of osCommerce

 

You have added an image contribution, but have not added the extra fields to the database.

 

There is a .sql file that came with the contribution and you must run that into your database via phpMyAdmin. The error will not go away until you do that.

 

Vger