Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

display productserror


xtreme-mobile

Recommended Posts

Posted

hey guys ive been having problems with going through the catelog menus and then getting the products page.

 

It always shows the following 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 = '4'

 

[TEP STOP]

 

 

even on a fresh install with no mods it does this,any ideas?

Visit my website in my profile for prices on woodburning stoves

Posted

Are you running on version 5 of mySQL.

 

The link below for solutions to loads of problems has the patches for mysql5.

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

Posted
Are you running on version 5 of mySQL.

 

The link below for solutions to loads of problems has the patches for mysql5.

 

hi just checked and got mysql version = 5.0.45-community-log

 

ill check out patch

 

cheers for that

Visit my website in my profile for prices on woodburning stoves

Archived

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

×
×
  • Create New...