snubbr.com

Advantages and disadvantages of verisign?

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...
Quick question... Advantages and disadvantages of verisign? Hoping for any answer. Second question.. Hello,.

I purchased an ebook script package and set it up, then added a couple of boxes to the nav columns and some banners to the footer. It appeared to be working fine but when I click on any products in the browse box I get the following error message:.

"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 = '10'".

Any ideas on how to fix this? Thanks in advance for your help..

Mick..

Comments (48)

I would like to know the answer too. Anyone here know what is the right answer to your question. I'll do some Googling and get back to you if I got an answer. You should email the people at Verisign as they probably could give you help..

Comment #1

Thanks for the smart ass reply. I did search for the answer to this and found nothing and that's why I posted. Perhaps you are so smart you have a link to an answer that I was unable to find?..

Comment #2

Use.

Google.

To search the forum using the prefix site:forums.oscommerce.com and you'll get over 1000 answers to your problem (or look through some of the previous threads)..

Comment #3

I found this thread via Google which some might find helpful:.

Http://forums.oscomm...howtopic=230304.

In my case, I reverted to my previous index.php..

My problem came when I took a banner from the footer.php and moved it into the body table of the index.php file. That threw something out of whack so I reverted to the previous index.php file I had saved prior to the change and now it's back to working order. I will move the banner back to the footer which is where it was before. Glad I saved the original file before making the wrong edit..

Thanks, perfectpassion, for your assistance...

Comment #4

Hello,.

I purchased an ebook script package and set it up, then added a couple of boxes to the nav columns and some banners to the footer. It appeared to be working fine but when I click on any products in the browse box I get the following error message:.

"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 = '10'".

Any ideas on how to fix this? Thanks in advance for your help..

Mick..

Comment #5

Search the forum - this has been answered 1000s of times before - at least once in the last 24 hrs - so try to help yourself instead of expecting others to do it for you..

Comment #6


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.