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'
Bug after installation in osCommerce
Moderator: General Moderators
-
powervijay
- Forum Newbie
- Posts: 5
- Joined: Wed Aug 19, 2009 7:00 am
Re: Bug after installation in osCommerce
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
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
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...
suggest me some other active forums if this is not suitable for me...
Thanks in advance...
Re: Bug after installation in osCommerce
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"
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
Yes i found and posted there... sorry for the inconvenience...
Re: Bug after installation in osCommerce
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
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