Community Add-Ons

//--------------------------------
//-----Fix for Image Catalog v1.33
//--------------------------------
//-----dotWdot--30-08-07----.W.---


I was having problems with this contribution producing this error:

Unknown column 'p.products_bsubimage1' in 'field list' (along with a load more txt.)


//--------------------------------
//--------------------------------

The basic problem was that the text included in the install (french) misses one line of SQL.
So the database cant find the field and crys about it.

//--------------------------------
//--------------------------------

To fix: Use phpmyadmin or such to perform the following sqL:

//--------------------------------

ALTER TABLE `products` ADD `products_bsubimage1` VARCHAR(64) AFTER `products_subimage1`;

//--------------------------------

I can confirm that with the header text contribution installed, along with the file from below and my above line of sql fix, that this mod works well!

to see an example go to : http://www.wheels-near-u.co.uk

To use this contribution you have to install also contribution http://www.oscommerce.com/community/contributions,207

Fix the bug.

Before installation compare your code.
This add has in more header tag and html editor (not included in this packqage)

This add add on allow to insert 9 images in the product description.
small image
big image
image deleted.

To do : Delete the name of the image when this image is deleted.

This add on work after the 29/06/2003.