We have a live clothing/garments osCommerce website with extensive customisations.
When we add Special prices the disable checkbox doesn't work.
Search by Size and Search by Description display disabled products and they should ignore disabled product including disabled special prices and categories.
Disabled categories need to disable all "child" products and categories - doesn't do this.
We are also trying to move the site to a new server that has MySQL 5, live server has MySQL 4. Most pages seem to work OK but we have one page (product listing) that is displaying the error message below - the column is definitely in the table - otherwise the other pages wouldn't work.
1054 - Unknown column 'p.products_id' in 'on clause'
select count(distinct 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 = '464'and p.master_product='1'
Please only bid if you have the experience and the time available to get these issues fixed quickly.
12 freelancers are bidding on average $217 for this job
I have no rating on this site yet, so my bid is low. I worked with osc and it's modifications many times. I can fix your problem with mysql5 within 10 minutes. 5 days maximum for whole project