Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Please Help! Error


rumahdesigns

Recommended Posts

Posted

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!

Posted

Google Search Box, input:

 

1054 - Unknown column 'p.products_id' in 'on clause' site:www.oscommerce.com/forums

 

Vger

Posted
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:

Posted
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.

Posted
....

.....

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.

Posted
Its a template

 

 

OK, but, how do I do that?

 

Sorry, very very new to this stuff.

Posted

www.templatemonster.com

 

but be careful, as many of their templates use old and outdated osCommerce code.

 

Vger

Posted
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 !

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...