Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Guest

Recommended Posts

Posted

Help please - my shop is broken and I can't work out why!

 

The error I am getting is this:

 

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

 

To the best of my knowledge, I haven't changed anything except the text on the index page. I have restored the old index page (yes, I did do a backup!) and it is still broken.

 

Can anyone help please?

 

Thanks

 

Tim

Posted
Help please - my shop is broken and I can't work out why!

 

The error I am getting is this:

To the best of my knowledge, I haven't changed anything except the text on the index page. I have restored the old index page (yes, I did do a backup!) and it is still broken.

 

Can anyone help please?

 

Thanks

 

Tim

 

OK - don't bother with for the moment, I am fairly certain that the problem is caused by my hosting company changing the MySQL to version 5.

 

Tim

  • 2 weeks later...
Posted
OK - don't bother with for the moment, I am fairly certain that the problem is caused by my hosting company changing the MySQL to version 5.

 

Tim

 

 

Tim did fix your problem? what did you have to do as im having the same problem with one of my stores at the moment!

Posted

Just download the latest osc version it includes these mods for mysql5.x

Posted

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

 

The bolded portion is not correct.

Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Archived

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

×
×
  • Create New...