I am looking for someone to move my oscommerce based website to a new server. I tried doing it myself however I have encountered a few problems with regard to the move. I think the issues I am having are due to the fact that the original server was based on a different version of MySql.(I am not opposed to just installing another version of MySql as well) Anyway, if you are able to do this and the project goes well I also need some help with developing the backend of the website. I would like to integrate it with Ebay and add product feeds to the comparison shopping engines etc. I would also like to develop the database as well. However, this project is just for switching the website over to the new server. Let me know if I left out anything.
Here is the error code I am getting and I am sure someone who is experienced could make the changes relatively easily. But I am basically done with trying to do it myself.
1054 - Unknown column 'p.products_id' in 'on clause'
select count(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 = '30'