Posts Tagged ‘ecommerce’

osCommerce Errors

Saturday, September 19th, 2009

With new requirements for server security, many older osCommerce stores are not able to run with the new settings. A common error seen in these older stores is:

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 = ’85′

[TEP STOP]

What to do? Chances are, you probably paid for a nice template and spent lots of time adding your products and building a customer base over the years. The simplest solution is to have us upgrade your store to the latest version of osCommerce, keeping the look and feel, as well as your products and customers intact. We write custom code for your template, then move your products and other pertinent information over to the new store.

Ready to get started? Contact us by email, or give us a call at (814) 723-4105 to receive a custom quote on your store.

We also build new osCommerce sites from scratch, to your specifications!