rumahdesigns Posted July 23, 2008 Share Posted July 23, 2008 Hello guys! please help me..I have problem with my site, the installation is complete..i create categories, sub categories and i input some products on it, but when i click the sub-categories to show the list of products on front-end they said error: 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 = '69' [TEP STOP] you can check to this site: http://sugahnspice.com/index.php?cPath=62_69 please help me... Thanks! Link to comment Share on other sites More sharing options...
♥Vger Posted July 23, 2008 Share Posted July 23, 2008 Google Search Box, input: 1054 - Unknown column 'p.products_id' in 'on clause' site:www.oscommerce.com/forums Vger Link to comment Share on other sites More sharing options...
rumahdesigns Posted July 23, 2008 Author Share Posted July 23, 2008 Google Search Box, input: 1054 - Unknown column 'p.products_id' in 'on clause' site:www.oscommerce.com/forums Vger Thank you very much! I resolve the problem...! thanks! :thumbsup: Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2008 Share Posted July 23, 2008 Hello guys! please help me..I have problem with my site, the installation is complete..i create categories, sub categories and i input some products on it, but when i click the sub-categories to show the list of products on front-end they said error: 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 = '69' [TEP STOP] you can check to this site: http://sugahnspice.com/index.php?cPath=62_69 please help me... Thanks! Cannot help you with your problem, but can add to it for you! Opened your shop, clicked on all 3 of the categories and none of them do anything, the screen does not change so cannot see sub-categories you mention above! Your tailoring of the OSC pages is excellent, so, A few questions for you, I would like to have paypal as the main payment option; How did you install the paypal payment option? I have downloaded paypal IPN, but unsure how to implement it, if you can advise that would be a great help. I would like sub-categories but cannot find anything in admin to set it up, any ideas? Noticed you have completely changed the look of the shop, I too would like to do this. It it easy to change the layout from standard? What file/line changes the background colour? Thanks in advance for your help P.S. Our shop is Here Not yet live and only 3 items. Link to comment Share on other sites More sharing options...
♥FIMBLE Posted July 23, 2008 Share Posted July 23, 2008 Its a template Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2008 Share Posted July 23, 2008 ......... I would like sub-categories but cannot find anything in admin to set it up, any ideas? .... .... Cracked that one, so easy when you see it. Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2008 Share Posted July 23, 2008 Its a template OK, but, how do I do that? Sorry, very very new to this stuff. Link to comment Share on other sites More sharing options...
♥Vger Posted July 23, 2008 Share Posted July 23, 2008 www.templatemonster.com but be careful, as many of their templates use old and outdated osCommerce code. Vger Link to comment Share on other sites More sharing options...
rumahdesigns Posted July 24, 2008 Author Share Posted July 24, 2008 www.templatemonster.com but be careful, as many of their templates use old and outdated osCommerce code. Vger Hello Vger Thank you for your help! okay i have new problem...I want to setup my categories not in alphabetic..i want to arrange it like i want, basically not in alpahbetic (A,B,C,D) thanks b 4 ! 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.