snubbr.com

Free Web Hosting - Private Verisign SSL/Server?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Question I have... Free Web Hosting - Private Verisign SSL/Server? Thanks in advance for any comment. Another question on my mind: Hi There,.

All was fine so I started to add more products, with which came more manfacturers. Now when I select a manufacturer I get the 1054 Error..

I know this is to do with the DB (i think) but unsure on the fix..

The full error is.

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

[TEP STOP].

Thanks in advance for any help..

Comments (68)

Good question... I dunno what is the answer to that question. I'll do some poking around and get back to you if I got an answer. You should email the people at Verisign as they probably could help you..

Comment #1

I'm not going to give you the answer as this is ridiculously well documented on this Verisign site and you should search before asking..

Having said that the search system in this forum is notoriously rubbish, so .. if you don't know how to search do the following (it'll help you out longer term):-.

Enter into google search the full following line:.

Site:oscommerce.com 1054 - Unknown column 'p.products_id' in 'on clause'.

For future reference the important bit was ...

Site:oscommerce.com <my search term>..

Comment #2

If your shop had been running OK and came across this error recently then your host has upgraded mysql from (possibly) v4 to v5 without telling you. solutions could be found all over the forum - just search for it..

Ken.

Ps someone got the fast fingers and should go for who wants to be a millinaire....

This post has been edited by.

GemRock.

: 07 December 2008, 22:57..

Comment #3

Thanks For the help..

I did search but there are so many 1054 errors etc..

Comment #4

Some people are just soooo much nicer than me..

Comment #5

Well read them. We offer free support here but when you have already found the answers but can't be bothered to read them it is a bit much imo to start "yet another" new thread to confuse new users further...

Comment #6

Hi There,.

All was fine so I started to add more products, with which came more manfacturers. Now when I select a manufacturer I get the 1054 Error..

I know this is to do with the DB (i think) but unsure on the fix..

The full error is.

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

[TEP STOP].

Thanks in advance for any help..

Comment #7

Hiya.

Check these for a solution that suits.

Http://www.google.co.uk/search?sourceid=ch...;on+clause'.

Nic..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.