genome Posted February 23, 2007 Share Posted February 23, 2007 I just moved host and after restoring my backups for the home direcory and databases i now get this for most, but not all, of the categories: 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 = '87' [TEP STOP] need help urgently as i have just had ads sent out. Link to comment Share on other sites More sharing options...
genome Posted February 23, 2007 Author Share Posted February 23, 2007 website is www.allsextoys4u.com Link to comment Share on other sites More sharing options...
genome Posted February 23, 2007 Author Share Posted February 23, 2007 it hapends on all categories that have items in them. doesnt happen if it only has subcategories. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.