snubbr.com

Hwo is the closest competitor to 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...
Question I have... Hwo is the closest competitor to verisign? Looking forward for any answer. Second question.. Hi All.

We tried the 1050 fixes for Mysql V5 but no good. (index.php and advanced_search.php).

When we click the link below we still get the 1050 error.

Anyone have a fix for this please?.

Thanks.

Ggntt.

Http://www.cellbusters.com/product_info.ph...;products_id=28.

Select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri.

Ce4_qty, p.products_qty_blocks, 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 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 = '28' and pd.products_id = '28' and pd.language_id = '1'..

Comments (78)

That's a good question. I'm not sure what is the answer. I'll do some poking around and get back to you if I discover an useful answer. You should email the people at Verisign as they probably know..

Comment #1

Hi guys,.

Thats for the posts.

I must be missing something..

The products_id field is already in the products table..

I have applied the mysql5 fixes (as far as I understand) (i.e. made the change to index.php and advance_search_results.php).

Any ideas (please be as detailed as you can with the answers, I have not been on the forums for a long time and not familiar with everything).

Thanks.

G..

Comment #2

Please anyone know how to fix this ? Verisign site is down a few days now and our Verisign hosting provider are not offering much help..

Thanks.

G..

Comment #3

Try this (backup first cause i'm far from an expert with this):.

Select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri.

Ce4_qty, p.products_qty_blocks, 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 ((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 = '28' and pd.products_id = '28' and pd.language_id = '1'..

Comment #4

Thanks Ian..

Which file / part of the file are you referring to ? .

I am less of an expert than you are..

Comment #5

I am into this problem too. I have replace the Ian's code to product_info.php in the area of,.

} else {.

$product_info_query = tep_db_query("I PUT THE CODE HERE"TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

$product_info = tep_db_fetch_array($product_info_query);.

But the problem still the same. Take a look at my shop.

Http://www.sultrysut...php?cPath=30_36.

Thanks...

Comment #6

The 1054 PHP5/MySQL5 issue has been solved many a times in forum try to search forums before posting.

Try searching 1054 in forum...

Comment #7

Hi All.

We tried the 1050 fixes for Mysql V5 but no good. (index.php and advanced_search.php).

When we click the link below we still get the 1050 error.

Anyone have a fix for this please?.

Thanks.

Ggntt.

Http://www.cellbusters.com/product_info.ph...;products_id=28.

Select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri.

Ce4_qty, p.products_qty_blocks, 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 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 = '28' and pd.products_id = '28' and pd.language_id = '1'..

Comment #8

Very easy to fix, add the products_id to products table...

Comment #9


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.