jsummers Posted June 26, 2008 Share Posted June 26, 2008 Can anyone tell me why I get this when I click on the catagories? Let's See What We Have Here 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21' another problem I'm having.. why, when a usps shipping method is selected, no matter which method is selected, it returns, without exception, the "express" option on the confirmation page? (That's the first one) This must be a really tough one cuz I've seen this problem or a variation of it mentioned several times but no responses... hmmm.. and.. why do images (I'm talking about the same product image, not different ones) show in some parts of the catalog and not others? Most notably in the new products section in the left column. On some pages the image displays and others its the red "X" error several other problems I've been able to fix, I've managed some page format changes, but I'm just a humble merchant, not a programmer... so can someone please help? I've only got about 10 weeks to target date and any help will be VERY much appreciated! jes.. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.