PDA

View Full Version : Image Catalog v1.32



michael_s
08-30-2007, 08:50 AM
//--------------------------------
//-----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


More... (http://www.oscommerce.com/community/contributions,1327)