Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error when clicking on side menu

Suzanne Bradley

Recommended Posts

I have recently installed OScommerce via Fantastico on my new webspace. It was 'populated' from a backup of my databases etc from my old ISP websites.


However, even thought he front page seems to workok, as do one or to other bits. All I seem to get are errors :-


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 = '73'




Can anyone advise what went wrong with the installation?


The website is at http://andibradley.com/store/index.php if you would like to look and see the error fo yourself.


Here's hoping



Link to comment
Share on other sites

Your new server is MySQL v5, and the old installation was MySQL v4. See http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors for (a start on) code changes you need to make to any version of osC to make it MySQL 5 compatible.



I think I just lost all my faith in OScommerce. I guess my shop will remain offline until someone puts out a suitable OScommerce for MySQL 5. I really shouldn't have to mess with code in programs, especially when I have absolutely no idea what I am doing.



Thanks for the help folks.



Link to comment
Share on other sites

  • 2 weeks later...

Well I had a look for something else to run my shop on, didn't like them at all, guess I like OS Commerce too much.


I bit the bullet, and after two aborted attempts, I now think I had a 'servicable' shop.



I think it fixed mine, but then, mine was a vanilla install.




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...