1054 - Unknown column 'p.products_id' in 'on clause'

[mrk6612]

Hello,

 

I purchased an ebook script package and set it up, then added a couple of boxes to the nav columns and some banners to the footer. It appeared to be working fine but when I click on any products in the browse box I get the following 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 = '10'"

 

Any ideas on how to fix this? Thanks in advance for your help.

 

mick

[Guest]

search the forum - this has been answered 1000s of times before - at least once in the last 24 hrs - so try to help yourself instead of expecting others to do it for you

[mrk6612]

Thanks for the smart ass reply. I did search for the answer to this and found nothing and that's why I posted. Perhaps you are so smart you have a link to an answer that I was unable to find?

[Guest]

Use Google to search the forum using the prefix site:www.oscommerce.com/forums and you'll get over 1000 answers to your problem (or look through some of the previous threads)

[mrk6612]

Use Google to search the forum using the prefix site:www.oscommerce.com/forums and you'll get over 1000 answers to your problem (or look through some of the previous threads)

 

Okay, thanks. I'll do that right away.

 

mick

[mrk6612]

I found this thread via Google which some might find helpful:

 

http://www.oscommerce.com/forums/index.php?showtopic=230304

 

In my case, I reverted to my previous index.php.

 

My problem came when I took a banner from the footer.php and moved it into the body table of the index.php file. That threw something out of whack so I reverted to the previous index.php file I had saved prior to the change and now it's back to working order. I will move the banner back to the footer which is where it was before. Glad I saved the original file before making the wrong edit.

 

Thanks, perfectpassion, for your assistance.