UltraPics and Lightbox Mod

[Guest]

Hiya, After much browsing for extra images etc, i came across lightbox. this was easy to install and worked fine!

 

Then i found the ultraPics and Lightbox contribution version '2.04'. after install and running the script(which was successful),

 

i got the following error on clicking on an image;

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

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, 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, 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 = '28' and pd.products_id = p.products_id and pd.language_id = '1'

[TEP STOP]

 

anyone got any ideas what i need to do?

all the best!

[Guest]

Ok.... All sorted! cant believe the answer was so simple!

 

checked the database and found that i had run the script in the wrong place and the extra image fields were not located in the 'products field!

 

Just a case of running the script in the right place and hey presto!