When im found this problem on my online store as:

 

And how to fix this error? Please following step by step in there:

At first time please to trying this:

products_to_categories p2c left join specials s on p.products_id = s.products_id

Change to:

products_to_categories p2c left join specials s on p2c.products_id = s.products_id

 

This is solved my problem, and if your problem can't fix please read the following step in there:
Find this...
 
 
// show the products of a specified manufacturer
   if (isset($HTTP_GET_VARS['manufacturers_id'])) {
     if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
       $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
     } else {
// We show them all
       $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_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 = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
     }
   } else {
// show the products in a given categorie
     if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
       $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
     } else {
// We show them all
       $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_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 = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
     }
   }
-------------------------------------
 
and replace with this
 
// show the products of a specified manufacturer
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_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 = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
}
} else {
// show the products in a given categorie
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_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 = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
}
}
 
-------------------------------------------------------------------
In catalog/advanced_search_result.php 
 
Find this
 
 
$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";
 
----------------------------------------
and replace with this
 
 
$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

Comments

Add New Search RSS

tommy_cacing  - music     |118.136.142.xxx |17-03-2010 20:15:30 very good a code.. thk's Reply | Quote 0   0 dsaf   |222.174.116.xxx |28-04-2010 07:38:30 Christian Louboutin Shoes can be a good gift for you to send to your wife or girlfriend when her birthday comes.It is also a good idea to select a suit of Herve Leger Dress to go with the shoes.The Spring is a good season for you to wear our MBT Shoes to relax your feet after an exhausting day of work.Many people say,the American pilots like wearing Ugg Boots in winter as to keep their feet warm.Meanwhile,it is also the time for rock climbing with Vibram Five Fingers around your feet..Wearing Links of London or Tiffany Jewelry will reflect you great femininity and noblity.And the Wholesale DVD will be a good choice for you to see some classic films at home. Christian Lo... Reply | Quote 0   0 zjf   |125.70.59.xxx |04-05-2010 10:45:29 A lot of wow gold people have been working wow gold in labs, biotechs cheap wow gold and pharma companies buy wow gold looking for a proof buy cheap wow gold of principle，that buy wow gold cheap immunotherapy works wow gold cheap against cancer, said cheapest wow gold ever Dr. David I. Quinn, medical tbc gold director of the wow gold guide USC Norris Cancer wow gold cheap Hospital. "This is gold for wow the proof of wow gold prices principle."Patient wow gold hacks advocates who have make wow gold been fighting for wow power leveling Provenge's approval wow powerleveling since the FDA initially rejected wow cd key the drug in 2007 were overjoyed. Reply | Quote 0   0 liping   |125.70.57.xxx |05-05-2010 08:47:16 It is difficult to think ofwow gold a figure of the international staturewow gold and reputationcheap wow goldof Richard Goldstone, with buy wow goldhis rich experience asbuy cheap wow gold an international buy wow gold cheapcriminal prosecutor wow gold cheapand investigator of cheapest wow gold everhuman rights situations, tbc goldas being naive or unrealisticwow gold guide. It is all the morewow gold cheap difficult therefore, gold for wowto fathom the wow gold pricescurious justificationswow gold hacks that he proffers for make wow goldthe very one-sided andwow power leveling critical report issued wow powerlevelingin his name by thewow cd key United Nations. Reply | Quote 0   0 Anonymous   |125.70.59.xxx |07-05-2010 08:16:54 When GHD we GHDS reached ghd hair the Ghd Straighteners Hall buy ghd,Sir ghd iv styler Henry GHD Dark was pink ghd straighteners very GHD Purple pleased pink ghd to Oakley Sunglasses see Oakley Sunglasses Sale Holmes Oakley Sport Sunglasses.But mens oakley sunglasses he oakley whisker was oakley juliet sunglasses surprised sports sunglasses that sunglasses Holmes oakley had fake oakley no Ray Ban sunglasses luggage aviator sunglasses and ray ban wayfarer that Ray Ban he Ray Ban Aviator appeared ray ban wayfarer sunglasses so Chanel Sunglasses unexpectedly Chanel Sunglasses On Sale.I replica chanel sunglasses had discount chanel sunglasses the chanel sunglasses online unhappy discount chanel sunglasses job womens sunglasses of designer su... Reply | Quote 0   0 yang  - 1   |125.70.59.xxx |07-05-2010 12:36:07 When GHD we GHDS reached ghd hair the Ghd Straighteners Hall buy ghd,Sir ghd iv styler Henry GHD Dark was pink ghd straighteners very GHD Purple pleased pink ghd to Oakley Sunglasses see Oakley Sunglasses Sale Holmes Oakley Sport Sunglasses.But mens oakley sunglasses he oakley whisker was oakley juliet sunglasses surprised sports sunglasses that sunglasses Holmes oakley had fake oakley no Ray Ban sunglasses luggage aviator sunglasses and ray ban wayfarer that Ray Ban he Ray Ban Aviator appeared ray ban wayfarer sunglasses so Chanel Sunglasses unexpectedly Chanel Sunglasses On Sale.I replica chanel sunglasses had discount chanel sunglasses the chanel sunglasses online unhappy discount chanel sunglasses job womens sunglasses of designer su... Reply | Quote 0   0 wd   |118.116.99.xxx |11-05-2010 09:55:50 The moment, how[URL=http://www.webtemplatess.com] Reply | Quote 0   0 swb  - look   |125.70.57.xxx |17-05-2010 12:36:57 All Yves Saint Laurent Shoesthe YSL Shoestime, everyYSL Shoes young YSL Slipperslady YSL Pumpsfeels YSL Sandalsthat YSL Bootsthere Manolo Blahnik Shoesstill Buy Manolo Blahnik ShoeslackManolo Blahnik Pumpsnew Manolo Blahnik Sandalsclothes Manolo Blahnik Short Boots in Manolo Blahnik Bootstheir Oakley Sunglassescloth Oakley Sunglasses Discountcabinet. From Buy Oakley Sunglasses Onlinethe football jerseysreality, we soccer jerseyscan Liverpool Jerseysunderstand Arsenal Jerseysthat AC Milan Jerseysevery Juventus Jerseysyoung Buy Designer Handbagslady Prada Handbagswants to Gucci Walletbecome Fendi Handbagsmore LV Bagsbeautiful. They Christian Louboutinspare no effort to dress up themselves to aim a common target. That Reply | Quote 0   0 swb  - look   |125.70.57.xxx |17-05-2010 12:41:24 There YSL Shoes is Yves Saint Laurent Shoesno YSL Pumpsdoubt Buy YSL Pumpsthat YSL Sandalsyouth YSL Short Bootsis YSL Slippersalimitless. Manolo BlahnikThe Discount Manolo Blahnik Shoesfashion Manolo Blahnik shoe salearea Manolo Blahnik Pumpsconstantly Buy Manolo Blahnik Sandalsdraws Manolo Blahnik Sandalspeople Reply | Quote 0   0 swb   |125.70.57.xxx |17-05-2010 12:42:58 When Focus Shoesmany Discount Shoesyounger Jimmy Choo Shoespeople Chanel Shoestake Christian Louboutin ShoesCoach Fendi ShoesFashion Ferragamo ShoesHandbags , Gucci Shoesthey Manolo Blahnik Shoesalways Buy Lanvin Shoescollect Louis Vuitton Shoesenvious Miu Miu Shoesattention.Balmain Shoes No Chanel Ballet Shoesmatter Christian Louboutin Pumpsthe Christian Dior Shoesmaterial, Giuseppe Zanotti Shoescolor, juicy couturestyles, juicy couture salesales, juicy couture shoes profession juicy couture handbagslevel and so on. louboutin sale The louboutin shoescoach christian louboutin Shoesfashion christian sandalshandbags louboutin pumpsalways Pandora Jewelryrank Pandora Charmsthe Pandora Jewelry Storenumber Pandora Braceletsone Pandora Necklacesin... Reply | Quote 0   0 air max 90  - uggboots     |59.60.119.xxx |05-06-2010 09:17:32 After you pay for lots of money on ugg boots,ugg Classic Tall the next step is to clean and maintain them to make sure that they will be worn long time.wholesale handbags uk buy gucci handbag arrival ugg boots Timberland Boots on sale buy NFL Jerseys buy Gucci Bikinis men Shox R4 cheap ugg boots oil arts Cheap air max 89 buy air max 90 buy ghd straightener Levi's Jeans ugg boots uk buy Christian Louboutin boots women air max 90 buy paul smith women air max 97 uk tiffany jewellery white D&G Handbags Cartier watches sale ugg boot sale from web link: http://www.fbib2b.com Reply | Quote 0   0 watches  - louis vuitton     |219.136.171.xxx |29-06-2010 15:30:20 I believe many people from the advertising or other means to have understanding omega watches is the first only to watches the moon, which replica iwc watches adds to omega a mysterious audemars piguet watches attraction. 1848 Louis founded by the OMEGA is today one of the most famous Swiss replica audemars piguet manufacturers that it's the Speedmaster miuseries was miu bags born in 1957, is both durable and clear miu miu bags reading characteristics of watches. As the rotating Speedmaster style clasp design of eight from the Seamaster (hippocampus) series. Therefore Speedmaster end table design is a sign the hippocampus. The surface of the world in super Omega Speedmaster Watch... Reply | Quote 0   0 ads  - cff   |125.69.136.xxx |19-07-2010 13:30:31 i believe you are a good writer, but have you erver thought to write some special artcals for peopel who likes shopping very much. for exaple, the artical aboutreplica louis vuitton bags orvibram,ghd flat iron orchristian shoes,cheap ugg bootsand replica watches swiss made as well asjordan shoes salechi flat iron,discount nfl team apparel, t shirts. i think more and more people would comr to read your blogs. air jordan 12 air jordan xii air jordan retro 12 air jordan retro xii air jordan 11 air jordan xi air jordan retro 11 air jordan retro xi air jordan 3 air jordan iii air jordan retro 3 air jordan retro iii air jordan 12 air jordan xii air jordan retro 12 air jordan retro xii air jordan 13 air jordan xiii Reply | Quote 0   0 yuyangguoji  - lw   |222.174.116.xxx |20-07-2010 11:26:49 I firmly believe you need the Action Adventure with reasonable price that with the high quality,and we will let your dream come true,a bloody cool boy is born with our mbt boots in the crowd.So don't hesitate,just come to our online shop to catch the opportunity once in the blue moon,to pick up and buy our workout dvd,a wide range from mbt boots,sport shoes and wholesale mbt to p90x fitness.Of course we are sure you will not miss our fantasy cheap video. Men MBT M.Walk shoes,cheap MBT M.Walk shoes,cheap Women MBT M.Walk shoes,cheap Men MBT M.Walk shoes,MBT Lami shoes,cheap MBT Lami shoes,MBT Lami shoes sale,MBT Lami shoes for sale,cheap MBT Lami shoes sale,MBT Sport Shoes,cheap MBT Sport Shoes,MBT Spor... Reply | Quote 0   0 yuyangguoji  - lw   |222.174.116.xxx |20-07-2010 12:21:46 I firmly believe you need the Action Adventure with reasonable price that with the high quality,and we will let your dream come true,a bloody cool boy is born with our mbt boots in the crowd.So don't hesitate,just come to our online shop to catch the opportunity once in the blue moon,to pick up and buy our workout dvd,a wide range from mbt boots,sport shoes and wholesale mbt to p90x fitness.Of course we are sure you will not miss our fantasy cheap video. Men MBT M.Walk shoes,cheap MBT M.Walk shoes,cheap Women MBT M.Walk shoes,cheap Men MBT M.Walk shoes,MBT Lami shoes,cheap MBT Lami shoes,MBT Lami shoes sale,MBT Lami shoes for sale,cheap MBT Lami shoes sale,MBT Sport Shoes,cheap MBT Sport Shoes,MBT Spor... Reply | Quote 0   0 yuyangguoji  - lw   |222.174.116.xxx |20-07-2010 12:47:36 I firmly believe you need the Action Adventure with reasonable price that with the high quality,and we will let your dream come true,a bloody cool boy is born with our mbt boots in the crowd.So don't hesitate,just come to our online shop to catch the opportunity once in the blue moon,to pick up and buy our workout dvd,a wide range from mbt boots,sport shoes and wholesale mbt to p90x fitness.Of course we are sure you will not miss our fantasy cheap video. Men MBT M.Walk shoes,cheap MBT M.Walk shoes,cheap Women MBT M.Walk shoes,cheap Men MBT M.Walk shoes,MBT Lami shoes,cheap MBT Lami shoes,MBT Lami shoes sale,MBT Lami shoes for sale,cheap MBT Lami shoes sale,MBT Sport Shoes,cheap MBT Sport Shoes,MBT Spor... Reply | Quote 0   0 babydoll     |120.36.36.xxx |20-07-2010 13:20:58 Now lots of people buy adult *** product to improve *** life high stocking,we supply all kinds of adult *** product Long Lady Stocking,because we are manufacture and have our factory women stocking,our product are all safe and wholesale wife babydoll,welcome to visit our store pijamas,all kinds of adult *** product for female and male open bust babydoll, you will buy your love *** product from our store Strap on dildos,adult *** product will greatly improve the quality of your *** life stocking online,*** life is very important baby doll nighties,*** life is harmonious babydoll costumes,the life is happies Wholesale Long Stocking,you can introduce your family and friend to visit our store Finger vibrators,best wi... Reply | Quote 0   0 Muslim Items   |61.154.6.xxx |29-07-2010 16:17:13 298274818336917502974 From the official Muslim Abaya website of anticipated Muslim Items Star Wars The Muslim hijab Old Republic comes Islamic abaya this new video where the Muslim scarf game designers Buy Muslim Abaya tell us a little about Cheap Muslim Abaya the 2 different Buy Muslim Items classes find Sith characters Cheap Muslim Items in the game, The Islamic hijab Inquisitor Sith Islamic scarf and Sith Warrior. They explain a lot of Islamic Items pictures as designed Muslim wear these characters and Muslim clothing their characteristics Muslim wear Pas Cher one more devoted Muslim wear to the use of force Muslim clothing powers and one more Muslim Items For Sale dedicated to close combat. Reply | Quote 0   0 Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."