Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1054 error?


Recommended Posts

I am making a new storefront, no fancy add-ons or modules. I add a new manufacturer, category and product with picture and description. When I go to the catalog site, and click on the category in the upper left corner,

I get this error message:


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




But if I click on the product image in the What's New area, the product comes up fine.

each time I go back to a category I get same error


What have I not done?


Link to comment
Share on other sites

What you have not done is you have not upgraded your store for PHP 5.0, which your host is using! It's okay .... Follow this link: http://www.oscommerce.com/community/contributions,4654/ and download that contribution, follow the instructions. You'll need to make a minor change to your catalog/index.php page, and some others. This might be an immediate fix. But ....


Additionally, however, you MUST download the 060817 update located here: http://www.oscommerce.com/solutions/downloads and this will update your OSC so it's current and ready for php 5.0.


Good luck.



Simple 1-2-3 Intructions on how to get, install and configure SSL


The Google Sandbox explained


Simple to follow instructions on how to change the look of your OSC


How To Make A Horrible OSC Website


my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP


my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...

Link to comment
Share on other sites


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

  • Create New...