Bug after installation in osCommerce

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
powervijay
Forum Newbie
Posts: 5
Joined: Wed Aug 19, 2009 7:00 am

Bug after installation in osCommerce

Post by powervijay »

I have installed the osc successfully but there is a major issue im facing now... while clicking the left category i got these error instead of the corresponding products...

If anybody have came across these bug or anybody know how to fix this bug plz give me a solution...


This is the error i got...

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 = '48'
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Bug after installation in osCommerce

Post by Eran »

a) this is not an osCommerce support forum, you should try asking there
b) why did you post the same message 4 times? that is not an acceptable practice here
powervijay
Forum Newbie
Posts: 5
Joined: Wed Aug 19, 2009 7:00 am

Re: Bug after installation in osCommerce

Post by powervijay »

I dont know which is the category that my topic comes thats y...
suggest me some other active forums if this is not suitable for me...
Thanks in advance...
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Bug after installation in osCommerce

Post by Eran »

http://forums.oscommerce.com/
Please make the minimal effort to find out those things. I got there from the first result for a google search on "oscommerce"
powervijay
Forum Newbie
Posts: 5
Joined: Wed Aug 19, 2009 7:00 am

Re: Bug after installation in osCommerce

Post by powervijay »

Yes i found and posted there... sorry for the inconvenience...
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: Bug after installation in osCommerce

Post by Darhazer »

I bet you are using MySQL 5
In MySQL 5, the explicit joins (that which have the JOIN keyword, and not just a comma) are with higher priority than implicit ones and this changes the order tables are joined
Rewriting the implicit ones as explicit should resolve the issue
Post Reply