Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Jetjumper

Archived
  • Posts

    5
  • Joined

  • Last visited

Everything posted by Jetjumper

  1. Having some troubles and Can't figure it out at all. I read through all the posts, and so far I can't seem to find anyone else with this issue. Here is all the information: I Install a fresh copy of osC. All goes well, so I Back up that just so I can keep a backup of a fresh install. Now, I import the SQL Data for the BTS. All goes well. Now I copy over the BTS Files/Patches, and this is where I have troubles. It will copy, everything seems to be working great. I can see all the templates and what not. BUT, what I am having trouble with is when you go to a Category, it will go to that fine, Then when you go to a SubCat, All Hell breaks loose. For the life of me I cannot figure out why. It works fine before I install BTS, but as soon as its installed, it freaks out. Here is the Error Code I get: File: index.php Shown CSS id's and classes may be different for other templates! Let's See What We Have Here 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 = '18' [TEP STOP] I have no Idea why this is doing this and if anyone can give me a hand, it would be greatly appreciated. Also might be helpful is what I am running this on. MySQL Version: 5.0.18 Apache Version: 2.2.0
×
×
  • Create New...