cieto Featured and mysql5

[kluczus]

after upgrade mysql to version 5 I have error message

 

1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by m.manufacturers_id DESC limit 2

Im found some information about changes to apply in index.php and advanced_search_results.php (all done), but I also have a problem with featured.

Im using cieto Featured Products 2.5 MS2, is anyone can help me ??

Please my shop is not working :(

[♥bruyndoncx]

after upgrade mysql to version 5 I have error message

 

1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by m.manufacturers_id DESC limit 2

Im found some information about changes to apply in index.php and advanced_search_results.php (all done), but I also have a problem with featured.

Im using cieto Featured Products 2.5 MS2, is anyone can help me ??

Please my shop is not working :(

In the tips and tricks section on this forum I've posted the explanation of what is happening and possible ways to solve this.

 

In the above code, the easiest fix is to switch the placement of "products p" with "manufacturers_info mi"

and everything should be runnnign smoothly again.