In Progress

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.

Skills: PHP

See more: this error, products manufacturers, manufacturers products, fix page, fix help, error pages oscommerce, error 0, oscommerce help, null, mysql index, mysql error, error, error php, desc, status page, select page, 1054 unknown column select, 1054 php, 1054 unknown, 1054, help mysql, oscommerce tep stop error, unknown column php, php tep stop, tep stop oscommerce

About the Employer:
( 330 reviews ) Sluis, Netherlands

Project ID: #182940

Awarded to:


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 in 0 days
(1 Review)

3 freelancers are bidding on average $30 for this job


We can solve that immediately, please check my PM.

$30 USD in 0 days
(8 Reviews)

Please check my PM

$30 USD in 0 days
(3 Reviews)