Help needed {mysql error on page oscommerce}

We have upgraded to mysql 5, now we have an error on the index page.

We have lots of modifications in it, like featured sets, but really don't know how to fix this


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([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], 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 = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '4' and m.manufacturer_featured = '1' order by m.manufacturers_id DESC limit 2


This has to do with Mysql ,i already looked at oscommerce forums, but the given details to fix it, are too much for me.

Habilidades: PHP

Veja mais: this error, products manufacturers, manufacturers products, help fix it, fix page, fix it help, fix help, error on page fix, error pages oscommerce, error 0, mysql 5.1, oscommerce help, null, mysql index, mysql error, error, error php, desc, status page, select page, php mysql error unknown column, 1054 unknown column select, 1054 php, 1054 unknown, 1054

Acerca do Empregador:
( 330 comentários ) Sluis, Netherlands

ID do Projeto: #182940

Concedido a:


Hello sir i have solved such an issue before to lot many clients.. i had even solved this for one in GAF too.. we can complete the work in 2 hrs.. Please check PMB for more details.. Regards Harishyam

$30 USD em 0 dias
(1 Comentário)

3 freelancers are bidding on average $30 for this job


We can solve that immediately, please check my PM.

$30 USD in 0 dias
(8 Comentários)

Please check my PM

$30 USD in 0 dias
(3 Comentários)