chrometweaks.org

Do iPage charge any cancelation fees for cancelling a hosting account?

Click Here To View All Answers...


My question is Do iPage charge any cancelation fees for cancelling a hosting account? Looking forward for any answer. Second question of mine... My shopping cart is a work in progress. When I post a review, it is viewable through the following.

Link.

..

But then, when I visit the following.

Link.

For the Review, I am getting "by T". I've tried multiple times, and I get other letters like "By A" , "By Y"..

What is going on? Any help is appreciated...

Comments (78)

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

Comment #1

I am having the same problem, I checked the database and it looks just how you said it should (64).....

Comment #2

Same here,.

Customers_name is set to varchar(64) and is not null..

Any other idea what the problem might be?..

Comment #3

What if you browse the 'Reviews' table?.

Does it show the full name, or just the first four characters?..

Comment #4

When I browse the reviews table, it shows the full name in 'customer name' field..

I also checked the reviews_description, and it is storing the review just fine. However, it can't display it well..

Here is the code for my product_reviews_info.php , for reference to find any potential errors..

<?php.

/*.

 $Id: product_reviews_info.php,v 1.50 2003/06/20 14:25:58 hpdl Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2003 osCommerce.

 Released under the GNU General Public License.

*/.

 require('includes/application_top.php');.

 if (isset($HTTP_GET_VARS['reviews_id']) && tep_not_null($HTTP_GET_VARS['reviews_id']) && isset($HTTP_GET_VARS['products_id']) && tep_not_null($HTTP_GET_VARS['products_id'])) {.

   $review_check_query = tep_db_query("select count(*) as total from "TABLE_REVIEWS" r, "TABLE_REVIEWS_DESCRIPTION" rd where r.reviews_id = '"(int)$HTTP_GET_VARS['reviews_id']"' and r.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and r.reviews_id = rd.reviews_id and rd.languages_id = '"(int)$languages_id"'");.

   $review_check = tep_db_fetch_array($review_check_query);.

   if ($review_check['total'] < 1) {.

     tep_redirect(tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params(array('reviews_id'))));.

   }.

 } else {.

   tep_redirect(tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params(array('reviews_id'))));.

 }.

 tep_db_query("update "TABLE_REVIEWS" set reviews_read = reviews_read+1 where reviews_id = '"(int)$HTTP_GET_VARS['reviews_id']"'");.

 $review_query = tep_db_query("select rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name, r.date_added, r.reviews_read, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, p.products_model, pd.products_name from "TABLE_REVIEWS" r, "TABLE_REVIEWS_DESCRIPTION" rd, "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where r.reviews_id = '"(int)$HTTP_GET_VARS['reviews_id']"' and r.reviews_id = rd.reviews_id and rd.languages_id = '"(int)$languages_id"' and r.products_id = p.products_id and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '". (int)$languages_id"'");.

 $review = tep_db_fetch_array($review_query);.

 if ($new_price = tep_get_products_special_price($review['products_id'])) {.

   $products_price = '<s>'$currencies->display_price($review['products_price'], tep_get_tax_rate($review['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($review['products_tax_class_id']))'</span>';.

 } else {.

   $products_price = $currencies->display_price($review['products_price'], tep_get_tax_rate($review['products_tax_class_id']));.

 }.

 if (tep_not_null($review['products_model'])) {.

   $products_name = $review['products_name']'<br><span class="smallText">['$review['products_model']']</span>';.

 } else {.

   $products_name = $review['products_name'];.

 }.

 require(DIR_WS_LANGUAGES$language'/'FILENAME_PRODUCT_REVIEWS_INFO);.

 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()));.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER)DIR_WS_CATALOG; ?>">.

<link rel="stylesheet" type="text/css" href="stylesheet.css">.

<script language="javascript"><!.

Function popupWindow(url) {.

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizab.

Le=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=1.

50').

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">.

<! header //>.

<?php.

#require(DIR_WS_INCLUDES'header.php');.

Require"/home/volvotun/public_html/g/head.shtml".

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="3" cellpadding="3">.

 <tr>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

   </table></td>.

<! body_text //>.

   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

     <tr>.

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>.

           <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

                 <tr>.

                   <td class="main"><?php echo '<b>'sprintf(TEXT_REVIEW_BY, tep_output_string_protected($review['customers_name']))'</b>'; ?></td>.

                   <td class="smallText" align="right"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($review['date_added'])); ?></td>.

                 </tr>.

               </table></td>.

             </tr>.

             <tr>.

               <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

                 <tr class="infoBoxContents">.

                   <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

                     <tr>.

                       <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

                       <td valign="top" class="main"><?php echo tep_break_string(nl2br(tep_output_string_protected($review['reviews_text'])), 60, '-<br>')'<br><br><i>'sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES'stars_'$review['reviews_rating']'.gif', sprintf(TEXT_OF_5_STARS, $review['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $review['reviews_rating']))'</i>'; ?></td>.

                       <td width="10" align="right"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

                     </tr>.

                   </table></td>.

                 </tr>.

               </table></td>.

             </tr>.

             <tr>.

               <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

             </tr>.

             <tr>.

               <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

                     <tr>.

                       <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

                       <td class="main"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params(array('reviews_id')))'">'tep_image_button('button_back.gif', IMAGE_BUTTON_BACK)'</a>'; ?></td>.

                       <td class="main" align="right"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params(array('reviews_id')))'">'tep_image_button('button_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW)'</a>'; ?></td>.

                       <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

                     </tr>.

                   </table></td>.

             </tr>.

           </table></td>.

           <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" align="right" valign="top"><table border="0" cellspacing="0" cellpadding="2">.

             <tr>.

               <td align="center" class="smallText">.

<?php.

 if (tep_not_null($review['products_image'])) {.

?>.

<script language="javascript"><!.

Document.write('<?php echo '<a href="javascript:popupWindow(''tep_href_link(FILENAME_POPUP_IMAGE, 'pID='$review['products_id'])'')">'tep_image(DIR_WS_IMAGES$review['products_image'], addslashes($review['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>');.

//></script>.

<noscript>.

<?php echo '<a href="'tep_href_link(DIR_WS_IMAGES$review['products_image'])'" target="_blank">'tep_image(DIR_WS_IMAGES$review['products_image'], $review['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>.

</noscript>.

<?php.

 }.

 echo '<p><a href="'tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action'))'action=buy_now')'">'tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART)'</a></p>';.

?>.

               </td>.

             </tr>.

           </table>.

         </td>.

       </table></td>.

     </tr>.

   </table></td>.

<! body_text_eof //>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! right_navigation //>.

<?php #require(DIR_WS_INCLUDES'column_right.php'); ?>.

<! right_navigation_eof //>.

   </table></td>.

 </tr>.

</table>.

<! body_eof //>.

<! footer //>.

<?php #require(DIR_WS_INCLUDES'footer.php'); ?>.

<! footer_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>..

Comment #5

I'm having the same problem as well. currently working on a solution.....

Comment #6

Yes, my reviews are in the left column and the fix is listed in this bug report..

Http://www.oscommerc.../search,reviews.

That post solved my problem...

Comment #7

My shopping cart is a work in progress. When I post a review, it is viewable through the following.

Link.

..

But then, when I visit the following.

Link.

For the Review, I am getting "by T". I've tried multiple times, and I get other letters like "By A" , "By Y"..

What is going on? Any help is appreciated...

Comment #8

Have a look at the "Reviews" table in your database..

Find 'customers_name':.

It should be set to 'varchar(64)' by the looks of it, it's set to 'varchar(4)' instead..

HTH,.

Tony..

Comment #9


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