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

[adidaxx]

Hi to all,

 

when I whant to edit my products from Categories/Subcategories' I get this error:

 

 

1054 - Unknown column 'p.product_image_2' 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.product_image_2, p.product_image_3, p.product_image_4, p.product_image_5, p.product_image_6, 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 from products p, products_description pd where p.products_id = '20' and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]

 

I need urgent help for this error;

Please, I put 300 products, and now i can't edit/change/update anyone;

I have installed extra_fields_v2_0j_1_2_3, Ultra Pics 2.07.01 - incl. STS + CCGV + LightBox;

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

[web-project]

very easy to fix, simply add the product_image_2 filed to products table

[adidaxx]

k..thx..

I made what U tell me, but now:

 

1054 - Unknown column 'p.product_image_3' 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.product_image_2, p.product_image_3, p.product_image_4, p.product_image_5, p.product_image_6, 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 from products p, products_description pd where p.products_id = '15' and p.products_id = pd.products_id and pd.language_id = '1'

[TEP STOP]

 

so, i have to add to database all of that fields?

[web-project]

it seems to me you have skipped one of installation step from Ultra Pics 2.07.01 contribution

[satish]

probably a multi image contrib was added and You skipped running its alt table script.

 

 

Satish

[adidaxx]

I just finish to compare with Total Commander file by content, all php file what was in UltraPics and what I have on server...and are the same...anyway..if i put on the database all that fields, U think will be k?

[adidaxx]

txs ... its work fine now ...i just finis to update the database with all of thats fields "product_image_2-6", and now I can edit/update the products....

thx web-project and satish for yours post..