I have an OS commerce shopping site that was started many months ago. This may only be a case of updating OS files. Customer is now ready to resume the build. There is an error in the script and I need someone to find and fix it! :)
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials_retail_prices 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 = '11'
26 freelancers are bidding on average $38 for this job
Serious php/mysql programmer with 3 years experience would like to fix your site. If accepted I would need access to mysql or phpmyadmin. Have a nice day!
This is a compatibility error in php. Your server will be on php5, where the oscommerce platform was based on php4. This error is quite easily fixed. Regards, Craig