Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


heebeha

Recommended Posts

I know this is a common issue. Who, how this being fixed. HELP> I am bleeding money due to this error.

 

You can see it here: http://nosharleyparts.com/index.php?cPath=24

 

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

 

[TEP STOP]

Link to comment
Share on other sites

If you get this message it is probably due to your server upgrading to php5 or MySQL5

 

Update your version with the required php5/mysql5 code snippets

 

http://www.oscommerce.com/community/contributions,4654

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

That worked but now i have header isues. Any insight into thsi problem?

 

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/noshar/public_html/index.php:1) in /home/noshar/public_html/includes/functions/sessions.php on line 68

 

 

You can see it here:

http://nosharleyparts.com/index.php

 

Thanks.

Jeff

Link to comment
Share on other sites

How did you edit your page, error is most likely whitespace at start/end of documents.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...