snubbr.com

Smtp error port 465 Verisign SSL no error 10053 x 800cccof?

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: Smtp error port 465 Verisign SSL no error 10053 x 800cccof? Hoping for any answer or 2. Another question... Hello Forum,.

I transfered my Verisign website from one Verisign hosting to another, from servagen.net to hostmonster.com.

But I encountered the problem,.

Error # 1.

Http://gbn.ge/newsde...php?newsPath=66.

(this happens when I try to go newsdesk items listed on the left top).

Error # 2.

Http://gbn.ge/pollcollect.php.

(this appears when I try to vote in poll).

Please can you help me why it happens..

Comments (118)

I would like to know the answer too. Anyone here know what is the answer to that question. I'll do some investigation and get back to you if I find an decent answer. You should email the people at Verisign as they probably can help you..

Comment #1

Regarding your #1 problem, look at this.

1054 error.

As geoffrey said, this is a classic symptom of moving to server with a newer mysql edition...

Comment #2

OK thanks guys, so what you recommend is to upgrade contributions?..

Comment #3

Well I saw the error # 1 but am not as good to understan what to do.

Well error 1054 can be fixed if it is in index.php like that.

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"'";.

}.

}.

IS PLACED.

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"'";.

}.

}.

I think I must do the same with newsdesk_index.php, but there the code is little different than in index.php there IT IS.

// show the products of a specified manufacturer.

If ($HTTP_GET_VARS['manufacturers_id']) {.

If ($HTTP_GET_VARS['filter_id']) {.

} else {.

// We show them all.

$listing_sql = "select "$select_column_list" p.newsdesk_id, p.newsdesk_status, p.newsdesk_date_added, pd.newsdesk_article_name, pd.newsdesk_article_shorttext,.

Pd.newsdesk_article_description, pd.newsdesk_article_url, pd.newsdesk_article_url_name, p.newsdesk_image, p.newsdesk_image_two, p.newsdesk_image_three,.

IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,.

IF(s.status, s.specials_new_products_price, NULL) as final_price from ".

TABLE_NEWSDESK" p), ".

TABLE_NEWSDESK_DESCRIPTION" pd, ".

TABLE_MANUFACTURERS ..

" m left join ".

TABLE_SPECIALS" s.

On p.newsdesk_id = s.products_id where p.newsdesk_status = '1' and pd.newsdesk_id = p.newsdesk_id.

And pd.language_id = '"$languages_id"' and m.manufacturers_id = '".

$HTTP_GET_VARS['manufacturers_id']"'";.

}.

Can you reccomend me what to do\.

Thanks..

Comment #4

Yes but did not understand it.

So search for contribution which helps to upgrade to mysql5?..

Comment #5

Help bad English guy or explain a bit clearer..

Comment #6

The link in post 3 explains how to correct this problem whereever it happens..

You just need to follow the instructions..

G..

Comment #7

You don't need to update anything..

All you need to do is change some piece of code in 2 files, as explained in the above-mentioned posts by me and geoffrey..

Just download the contribution (s) and do exactly what the readme files say..

Good luck...

Comment #8

Thanks for help.

Newsdesk problem was fixed 100%.

The problem was solved very simply I just overwrote files to existing files at ftp.

Also I fixed poll problem, but when I try to vote, it rally appears in results, but on the top of index page appears:.

//function to check that there is no HTML in the comment field. function screenForm($field_value){ $stripped = strip_tags($field_value); if($field_value!=$stripped) { // something in the field value was HTML return false; } else return true; }.

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home1/forexthi/public_html/gbn.ge/pollbooth.php:11) in /home1/forexthi/public_html/gbn.ge/includes/functions/sessions.php on line 97.

This post has been edited by.

Fxtrader777.

: 01 January 2009, 09:52..

Comment #9

Try google on.

Site:forums.oscommerce.com "Cannot send session cache limiter - headers already sent"..

Comment #10

Found one way to solve to change in admin session folder to tmp, but did not help..

Comment #11

Hello Forum,.

I transfered my Verisign website from one Verisign hosting to another, from servagen.net to hostmonster.com.

But I encountered the problem,.

Error # 1.

Http://gbn.ge/newsde...php?newsPath=66.

(this happens when I try to go newsdesk items listed on the left top).

Error # 2.

Http://gbn.ge/pollcollect.php.

(this appears when I try to vote in poll).

Please can you help me why it happens..

Comment #12

Looks like a classic symptom of moving from a server running v4 of mysql to v5..

Search the contributions for a solution, there is a general one there..

Then in might be nice to update the contribution for those that follow...

Comment #13


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.