Error Upon Install of Simple Multi Image Add-on

[beebee99]

I recently installed this contribution.

http://www.oscommerce.com/community/contributions,7008/category,all/search,product+info

 

I followed everything exactly, however when I click on an image to see it larger, I get the following error:

 

#######

1054 - Unknown column 'p.products_image_array' 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_array, 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 = '16' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

######

 

Here is precisely what I did with the fresh install of OSC vs 2.2rc2a:

1. Uploaded the php and js files into their respective folder based on the contri. instructions.

2. Opened PHPmyAdmin, found db, clicked on it, then clicked SQL, pasted SQL file #1 (SQL v1 to v1.1) successful ok, then went back into db, clicked SQL and pasted SQL file (SQL v1.1) successfully ok, then went back into db clicked SQL and pasted (Uninstall SQL) successful ok.

 

But 1054 error appears above. Is there anything else that needs to be done to make this work? It seemed really easy and straight forward but it doesn't work, please help!

 

Here are a couple of notes about the site:

 

> The entire install is in a folder called /shop/ not /catalog/. Would this make a difference?

> I don't see the extra attributes referred too in the install instructions. In particular the thread says to set "Additional Images" parameters but this doesn't show in admin --> config --> images. This makes me think the SQL didn't run properly.

 

Please help as I run the queries several times and it has not fixed the problem.

[Guest]

Bill,

 

 

Why did you run the UNINSTALL SQL ? The UNINSTALL.......REMOVES the required SQL statements from the database and is only intended for use when you want to REMOVE the Multi Image Add on from your store.

 

 

Run just the SQL V1.1 file using myphpadmin

 

 

Chris