Help Required : SPPC Contrib

[Krustacean]

Looking for a shining Knight ( or Knightress )

 

I bought a template and made some mods all working fine.

Then added the SPPC Contrib and it caused problems.

My template layout has changed with the original OSC TEXT PAGE now in the middle of my page.

Column widths also changed.

 

And secondly ... when selecting Manufacturers get 1054 error ...1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '16'

 

I'm sure the first one is something simple ... but as you gathered I am a bit of a novice. (with PHP)

 

I can email the URL to any willing helpers.

 

Tks,

[djmonkey1]

Try a shining JanZ:

http://www.oscommerce.com/forums/index.php?showtopic=53436