Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


IMpure

Recommended Posts

Posted

I had a server shift. Transfer done by hosting guy but after the transfer, I start encountering this error:-

 

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

 

I have made these attempts:-

1.) Restored a previous backup

2.) myself created 'products_id' field in all product relevant tables where it seems missing

 

but nothing seems to work. Any suggestion?

To be or not to be, that is the question!

Posted

If someone could even explain me the error, I would be grateful

To be or not to be, that is the question!

Posted

p2c left join

 

I'm guessing your new server uses MySQL 5 and your osCommerce install is not MySQL 5 compliant. MySQL 5 handles 'joins' in a different way to MySQL 4.

 

Either downgrade to MySQL 4+ or else you'll have to update your shop to be MySQL 5 compliant.

 

Vger

Posted
p2c left join

 

I'm guessing your new server uses MySQL 5 and your osCommerce install is not MySQL 5 compliant. MySQL 5 handles 'joins' in a different way to MySQL 4.

 

Either downgrade to MySQL 4+ or else you'll have to update your shop to be MySQL 5 compliant.

 

Vger

 

updating my shop to MYSQL5 would cause configuration loss? or it is just like installing a patch and everything would start to work normally as it was previously doing. Any link containing info to update shop to MYSQL5? Is there any software which automatically converts MYSQL4 dbase to MYSQL5?

To be or not to be, that is the question!

Posted

There are other places where your shop will have to be patched to work with mysql5.

 

The patch link below is a good place to start.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

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

×
×
  • Create New...