Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error Upon Install of Simple Multi Image Add-on


Recommended Posts

I recently installed this contribution.



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'






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.

Link to comment
Share on other sites




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




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...