Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP PLEASE - ERROR in categories - not showing products


scrapkats

Recommended Posts

Hi

 

Can anyone tell me what I have done - when I click on my categories that have products in them, this message appears:

 

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

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '19'

 

[TEP STOP]

 

 

Thank you

 

Regards

Kathryn

"Life is short, break the rules, forgive quickly, kiss slowly, love truly, laugh uncontrollably, and never regret anything that made you smile."

Link to comment
Share on other sites

Hi

 

My problem is now fixed - my host fixed it for me - apparently I "broke" my index :rolleyes:

 

Thank you

 

Regards

Kathryn

"Life is short, break the rules, forgive quickly, kiss slowly, love truly, laugh uncontrollably, and never regret anything that made you smile."

Link to comment
Share on other sites

Hi

 

My problem is now fixed - my host fixed it for me - apparently I "broke" my index :rolleyes:

 

Thank you

 

Regards

Kathryn

 

Hello,

I just moved my store to another host and now am experiencing the same problem. Do you know what the specific issue is?

Thanks.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...