Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Jenica77

Pioneers
  • Posts

    39
  • Joined

  • Last visited

Posts posted by Jenica77

  1. There is an IPN file in this Module.

    It is to process the backend IPN post.

    The code of that files feels that there is something wrong in the order placed and the IPN recd so it results in invalid IPN.

     

    You need to debug that file.

     

    Satish

     

    OK, well I haven't changed anything in the ipn.php file that came with the package so I'm not too cure where to start. I do have two e-mail addresses associated with my paypal account. The business one and a personal one. I made the business one the primary. I saw that someone earlier was having some issue with having multiple email addresses so I'm not sure if I need to do anything different.

     

    Should I post the code from the ipn.php file here? Like I said, its the standard one that came with the package 2.3.4.7

  2. I have been searching this thread for four hours, I hope someone can help me out!! I installed 2.3.4.7 which appears to me to be the last english version. I've been testing it and here's what I'm getting:

     

    Orders do show up in Admin

    Payment does show up in Paypal, I get normal confirmation email from Paypal

     

    I never get a confirmation email (as the customer or the shop owner)

    I get error emails from Paypal:

    PayPal IPN Invalid Process

    $_POST:

     

    mc_gross=15.00

    invoice=6

     

    protection_eligibility=Eligible

    address_status=confirmed

    payer_id=xxxxxxxxxx

    tax=0.00

    address_street=xxxxxxxxxx

    payment_date=15:31:28 Apr 04 2010 PDT

     

    payment_status=Completed

    charset=windows-1252

    address_zip=xxxxx

    first_name=xxxxxxxxxx

    mc_fee=0.74

     

    address_country_code=US

    address_name=xxxxxxxxxx

    notify_version=2.9

    custom=11

    payer_status=unverified

    [email protected]

    address_country=United States

    address_city=xxxxxxxxxx

    quantity=1

    verify_sign=AiPC9BjkCyDFQXbSkoZcgqH3hpacADv1CkHIOzo0KxRXyF2ihQ4mcB0a

     

    payer_email=xxxxxxxxxx

    txn_id=7VS675029S402735C

     

    payment_type=instant

    last_name=xxxxxxxxxx

    address_state=TX

    receiver_email=xxxxxxxxxx

    payment_fee=0.74

     

    receiver_id=L8ME2KBYBXW2S

    txn_type=web_accept

    item_name=xxxxxxxxxx

    mc_currency=USD

    item_number=

    residence_country=US

    receipt_id=1952-8478-1360-1838

     

    handling_amount=0.00

    transaction_subject=11

    payment_gross=15.00

     

    When I look at the order in Admin, It shows as pending and when I click on it, I see this in the status: PayPal IPN Invalid [Completed]

     

    There is also a big red X next to the customer notified box.

     

    In my IPN settings in Paypal, I've tried having no URL, mysite.com/ext/modules/payment/paypal_ipn/ipn.php and mysite.com/includes/modules/payment/paypal_ipn.php None of them seem to make a difference.

     

    Can anyone please help me?? TIA

  3.  

    I'm assuming you meant this post:

    OK, for further reference, I found the prob. I had an error in the database upload, verified the DB and everything is ok now. Not to say that thats the case for every foreach error, but its a place to start !

     

    I looked at the database and the only thing I can tell that might be wrong is that the customers_wishlist table has no index defined. I loaded the wishlist.sql that came with the add-on and it tells me that customers_wishlist already exists. Is there something else I should look at in that table? Thanks for your time.

  4. I'm getting an error when I try to send my wishlist to someone. It says wishlist sent, but gives this error and the email never shows up.

     

    Warning: Invalid argument supplied for foreach() in /hsphere/local/home/kikicann/pumpkinsboutique.com/catalog/wishlist.php on line 132

     

    Warning: Invalid argument supplied for foreach() in /hsphere/local/home/kikicann/pumpkinsboutique.com/catalog/wishlist.php on line 160

     

    I saw earlier in the thread where someone said they had to change some code to add some returns, I looked and that is not my problem.

     

    Here is what is in my wishlist.php file. Can anyone help please? Thanks.

    (line 132=$z = 0;)

    (line 160=$error = true;)

     

    <?php
    /*
     $Id: wishlist.php,v 3.0  2005/04/20 Dennis Blake
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Released under the GNU General Public License
    */
    // This version, removes the product when adding to a cart now, replaced all of the  HTTP_POST_VARS for $_POST
    
     require('includes/application_top.php');
     require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_WISHLIST);
    
    /*******************************************************************
    ******* ADD PRODUCT TO WISHLIST IF PRODUCT ID IS REGISTERED ********
    *******************************************************************/
    
     if(tep_session_is_registered('wishlist_id')) {
    $wishList->add_wishlist($wishlist_id, $attributes_id);
    /*******************************************************************
    ******* CREATES COOKIE TO STORE WISHLIST ON LOCAL COMPUTER  ********
    ********************************************************************
    ******* TO CHANGE THE LENGTH OF TIME THE COOKIE IS STORED:  ********
    *******                                                     ********
    ******* EDIT THE "DAYS" VARIABLE BELOW.  THIS VARIABLE IS   ********
    ******* THE NUMBER OF DAYS THE COOKIE IS STORED.            ********
    *******************************************************************/	
    //	$days = 30;																															
    //	$time = time() + (3600 * 24 * $days);
    // 	$cook_id = serialize($wishList->wishID);
    //	tep_setcookie('wish', $cook_id , $time);
    /***********************END CHANGE*********************************/
    
    if(WISHLIST_REDIRECT == 'Yes') {
    	tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id));
    } else {
    	tep_session_unregister('wishlist_id');
    }
     }
    
    
    /*******************************************************************
    ****************** ADD PRODUCT TO SHOPPING CART ********************
    *******************************************************************/
    
     if (isset($_POST['add_wishprod'])) {
    if(isset($_POST['add_prod_x'])) {
    	foreach ($_POST['add_wishprod'] as $value) {
    		$product_id = tep_get_prid($value);
    		$cart->add_cart($product_id, $cart->get_quantity(tep_get_uprid($product_id, $_POST['id'][$value]))+1, $_POST['id'][$value]);
    		$wishList->remove($value);
    		}
    	}
    }
    
    
    
    /*******************************************************************
    ****************** DELETE PRODUCT FROM WISHLIST ********************
    *******************************************************************/
    
     if (isset($_POST['add_wishprod'])) {
    if(isset($_POST['delete_prod_x'])) {
    	foreach ($_POST['add_wishprod'] as $value) {
    		$wishList->remove($value);
    	}
    }
     }
    
    
    /*******************************************************************
    ************* EMAIL THE WISHLIST TO MULTIPLE FRIENDS ***************
    *******************************************************************/
    
     if (isset($_POST['email_prod_x'])) {
    
    	$errors = false;
    	$guest_errors = "";
    	$email_errors = "";
    	$message_error = "";
    
    	if(strlen($_POST['message']) < '1') {
    		$error = true;
    		$message_error .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_MESSAGE . "</div>";
    	}			
    
     		if(tep_session_is_registered('customer_id')) {
    		$customer_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
      		$customer = tep_db_fetch_array($customer_query);
    
    		$from_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
    		$from_email = $customer['customers_email_address'];
    		$subject = $customer['customers_firstname'] . ' ' . WISHLIST_EMAIL_SUBJECT;
    		$link = HTTP_SERVER . DIR_WS_CATALOG . FILENAME_WISHLIST_PUBLIC . "?public_id=" . $customer_id;
    
    	//REPLACE VARIABLES FROM DEFINE
    		$arr1 = array('$from_name', '$link');
    		$arr2 = array($from_name, $link);
    		$replace = str_replace($arr1, $arr2, WISHLIST_EMAIL_LINK);
    		$message = tep_db_prepare_input($_POST['message']);
    		$body = $message . $replace;
    	} else {
    		if(strlen($_POST['your_name']) < '1') {
    			$error = true;
    			$guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_YOUR_NAME . "</div>";
    		}
    		if(strlen($_POST['your_email']) < '1') {
    			$error = true;
    			$guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " .ERROR_YOUR_EMAIL . "</div>";
    		} elseif(!tep_validate_email($_POST['your_email'])) {
    			$error = true;
    			$guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>";
    		}
    
    		$from_name = stripslashes($_POST['your_name']);
    		$from_email = $_POST['your_email'];
    		$subject = $from_name . ' ' . WISHLIST_EMAIL_SUBJECT;
    		$message = stripslashes($_POST['message']);
    
    		$z = 0;
    		$prods = "";
    		foreach($_POST['prod_name'] as $name) {
    			$prods .= stripslashes($name) . "  " . stripslashes($_POST['prod_att'][$z]) . "\n" . $_POST['prod_link'][$z] . "\n\n";
    			$z++;
    		}
    		$body = $message . "\n\n" . $prods . "\n\n" . WISHLIST_EMAIL_GUEST;
      	}
    
    	//Check each posted name => email for errors.
    	$j = 0;
         $email = $_POST['email'];
    	foreach($_POST['friend'] as $friendx) {
    		if($j == 0) {
    			if($friend[0] == '' && $email[0] == '') {
    				$error = true;
    				$email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ONE_EMAIL . "</div>";
    			}
    		}
    
    		if(isset($friendx) && $friendx != '') {
    			if(strlen($email[$j]) < '1') {
    				$error = true;
    				$email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_EMAIL . "</div>";
    			} elseif(!tep_validate_email($email[$j])) {
    				$error = true;
    				$email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>";
    			}
    		}
    
    		if(isset($email[$j]) && $email[$j] != '') {
    			if(strlen($friendx) < '1') {
    				$error = true;
    				$email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_NAME . "</div>";
    			}
    		}
    		$j++;
    	}
    	if($error == false) {
    		$j = 0;
    		foreach($_POST['friend'] as $friendx) {
    			if($friendx != '') {
    				tep_mail($friendx, $email[$j], $subject, $friendx . ",\n\n" . $body, $from_name, $from_email);
    			}
    
    		//Clear Values
    			$friend[$j] = "";
    			$email[$j] = "";
    			$message = "";
    
    			$j++;
    		}
    
           	$messageStack->add('wishlist', WISHLIST_SENT, 'success');
    	}
     }
    
    
    $breadcrumb->add(NAVBAR_TITLE_WISHLIST, tep_href_link(FILENAME_WISHLIST, '', 'SSL'));
    ?>
    <!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 (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- 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"><?php echo tep_draw_form('wishlist_form', tep_href_link(FILENAME_WISHLIST)); ?>
      <table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td>
    	  <table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr>
               <td class="pageHeading" colspan="3"><?php echo HEADING_TITLE; ?></td>
               <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_wishlist.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
             </tr>
             </table>
    	</td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
    
    <?php
     if ($messageStack->size('wishlist') > 0) {
    ?>
         <tr>
           <td><?php echo $messageStack->output('wishlist'); ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
    <?php
     }
    
    
    if (is_array($wishList->wishID) && !empty($wishList->wishID)) {
    reset($wishList->wishID);
    
    ?>
      <tr>
    	<td>
    	<table border="0" width="100%" cellspacing="0" cellpadding="3" class="productListing">
    	  <tr>
    			<td class="productListing-heading"><?php echo BOX_TEXT_IMAGE; ?></td>
    			<td class="productListing-heading"><?php echo BOX_TEXT_PRODUCT; ?></td>
    			<td class="productListing-heading"><?php echo BOX_TEXT_PRICE; ?></td>
    			<td class="productListing-heading" align="center"><?php echo BOX_TEXT_SELECT; ?></td>
    	  </tr>
    
    <?php
    	$i = 0;
    	while (list($wishlist_id, ) = each($wishList->wishID)) {
    
    		$product_id = tep_get_prid($wishlist_id);
    
    	    $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, 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 ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name");
    		$products = tep_db_fetch_array($products_query);
    
    	      if (($i/2) == floor($i/2)) {
    	        $class = "productListing-even";
    	      } else {
    	        $class = "productListing-odd";
    	      }
    
    ?>
    			  <tr class="<?php echo $class; ?>">
    				<td valign="top" class="productListing-data" align="left"><?php if($products['products_status'] == 0) {
    			   			 echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); 
    			   			}
                               else
                               {
    						?>
    			   <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?></a>
                      <?php } ?>
    
    				<td valign="top" class="productListing-data" align="left" class="main"><b><?php if($products['products_status'] == 0) {
    				echo $products['products_name']; 
    				}
    				else {
    				?>
                       <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo $products['products_name']; ?></a>
                       <?php } ?></b>
    				<input type="hidden" name="prod_link[]" value="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>" />
    				<input type="hidden" name="prod_name[]" value="<?php echo $products['products_name']; ?>" />
    <?php
    
    
    
    /*******************************************************************
    ******** THIS IS THE WISHLIST CODE FOR PRODUCT ATTRIBUTES  *********
    *******************************************************************/
    
                     $attributes_addon_price = 0;
    
                     // Now get and populate product attributes
    				$att_name = "";
    				if (isset($wishList->wishID[$wishlist_id]['attributes'])) {
    					while (list($option, $value) = each($wishList->wishID[$wishlist_id]['attributes'])) {
                         		echo tep_draw_hidden_field('id[' . $wishlist_id . '][' . $option . ']', $value);
    
            					$attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                         from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
                                         where pa.products_id = '" . $wishlist_id . "'
                                          and pa.options_id = '" . $option . "'
                                          and pa.options_id = popt.products_options_id
                                          and pa.options_values_id = '" . $value . "'
                                          and pa.options_values_id = poval.products_options_values_id
                                          and popt.language_id = '" . $languages_id . "'
                                          and poval.language_id = '" . $languages_id . "'");
    						$attributes_values = tep_db_fetch_array($attributes);
    
                          		if ($attributes_values['price_prefix'] == '+') {
    							$attributes_addon_price += $attributes_values['options_values_price'];
                          		} else if($attributes_values['price_prefix'] == '-') {
                            		$attributes_addon_price -= $attributes_values['options_values_price'];
    						}
    						$att_name .= " (" . $attributes_values['products_options_name'] . ": " . $attributes_values['products_options_values_name'] . ") ";
                          		echo '<br /><small><i> ' . $attributes_values['products_options_name'] . ': ' . $attributes_values['products_options_values_name'] . '</i></small>';
                       	} // end while attributes for product
    
    				}
    
    				echo '<input type="hidden" name="prod_att[]" value="' . $att_name . '" />';
    
                      	if (tep_not_null($products['specials_new_products_price'])) {
                      		$products_price = '<s>' . $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($products['specials_new_products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</span>';
                      	} else {
                          	$products_price = $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id']));
                       }
    
    /*******************************************************************
    ******* CHECK TO SEE IF PRODUCT HAS BEEN ADDED TO THEIR CART *******
    *******************************************************************/
    
    		if($cart->in_cart($wishlist_id)) {
    			echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_IN_CART . '</b></font>';
    		}
    
    /*******************************************************************
    ********** CHECK TO SEE IF PRODUCT IS NO LONGER AVAILABLE **********
    *******************************************************************/
    
      			if($products['products_status'] == 0) {
      				echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_NOT_AVAILABLE . '</b></font>';
     			}
    
    		$i++;
    ?>
    		</td>
    		<td valign="top" class="productListing-data"><?php echo $products_price; ?></td>
    		<td valign="top" class="productListing-data" align="center">
    <?php
    
    /*******************************************************************
    * PREVENT THE ITEM FROM BEING ADDED TO CART IF NO LONGER AVAILABLE *
    *******************************************************************/
    
    		if($products['products_status'] != 0) {
    			echo tep_draw_checkbox_field('add_wishprod[]',$wishlist_id);
    		}
    ?>
    		</td>
    	  </tr>
    
    <?php
    	}
    ?>
    	</table>
    	</td>
      </tr>
      <tr>
    	<td align="right"><br /><?php echo tep_image_submit('button_delete.gif', 'Delete From Wishlist', 'name="delete_prod" value="delete_prod"') . " " . tep_image_submit('button_in_cart.gif', 'Add to Cart', 'name="add_prod" value="add_prod"'); ?></td>
    	  </tr>
    </table>
    <?php
    
    /*******************************************************************
    *********** CODE TO SPECIFY HOW MANY EMAILS TO DISPLAY *************
    *******************************************************************/
    
    
    if(!tep_session_is_registered('customer_id')) {
    
    ?>
    <table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
      <tr>
    	<td class="main"><?php echo WISHLIST_EMAIL_TEXT_GUEST; ?></td>
      </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
      <tr>
           <td align="center">
    		<table border="0" width="400px" cellspacing="0" cellpadding="2">
    		  <tr>
    			<td class="main" colspan="2"><table cellpadding="2" cellspacing="0">
    			  <tr>
    				<td colspan="2"><?php echo $guest_errors; ?></td>
    			  </tr>
    			  <tr>
    				<td class="main"><?php echo TEXT_YOUR_NAME; ?></td>
    				<td class="main"><?php echo tep_draw_input_field('your_name', $your_name); ?></td>
    		  	  </tr>
    		  	  <tr>
    				<td class="main"><?php echo TEXT_YOUR_EMAIL; ?></td>
    				<td class="main"><?php echo tep_draw_input_field('your_email', $your_email); ?></td>
    		  	  </tr>
    			</table></td>
    		  </tr>
    	      <tr>
    	        <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    	      </tr>
    	      <tr>
    	        <td colspan="2"><?php echo tep_draw_separator('pixel_black.gif', '100%', '1'); ?></td>
    	      </tr>
    	      <tr>
    	        <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    	      </tr>
    <?php 
    
    } else {
    
    ?>
    
    <table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
      <tr>
    	<td class="main"><?php echo WISHLIST_EMAIL_TEXT; ?></td>
      </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
      <tr>
           <td align="center">
    		<table border="0" width="400px" cellspacing="0" cellpadding="2">
    
    <?php
    
    }
    
    ?>
    		  <tr>
    			<td colspan="2"><?php echo $email_errors; ?></td>
    		  </tr>
    <?php
    
    $email_counter = 0;
    while($email_counter < DISPLAY_WISHLIST_EMAILS) {
    ?>
    		  <tr>
    			<td class="main"><?php echo TEXT_NAME; ?>  <?php echo tep_draw_input_field('friend[]', $friend[$email_counter]); ?></td>
    			<td class="main"><?php echo TEXT_EMAIL; ?>  <?php echo tep_draw_input_field('email[]', $email[$email_counter]); ?></td>
    		  </tr>
    <?php
    $email_counter++;
    }
    ?>
    		  <tr>
    			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    		  </tr>
    		  <tr>
    			<td colspan="2"><?php echo $message_error; ?></td>
    		  </tr>
    		  <tr>
    			<td colspan="2" class="main"><?php echo TEXT_MESSAGE .  tep_draw_textarea_field('message', 'soft', 45, 5); ?></td>
    		  </tr>
    		  <tr>
    			<td colspan="2" align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE, 'name="email_prod" value="email_prod"'); ?></td>
    
    		  </tr>
    		</table>
    	</td>
      </tr>
    </table>
    </form>
    <?php
    
    } else { // Nothing in the customers wishlist
    
    ?>
     <tr>
    <td>
    <table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
    	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
    	  <tr>
    		<td class="main"><?php echo BOX_TEXT_NO_ITEMS;?></td>
    	  </tr>
    	</table>
    	</td>
      </tr>
    </table>
    </td>
     </tr>
    </table>
    </form>
    
    <?php 
    }
    ?>
    <!-- customer_wishlist_eof //-->
    </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'); ?>

  5. I used your second suggestion and sorted it on the options name and it worked perfectly! Thanks so much for your help!

     

    Unfortunately, Attribute sort order plugin doesn't have functionality to change sort order of existing options. You may sort options only if you create them throug AJAX AM contrib.

    If you want to change order of existing options use phpMyAdmin or something like that and post this query to each option you change:

    UPDATE `products_options` SET `products_options_sort_order` = '<YOUR SORT ORDER>' WHERE `products_options_id` =<OPTION ID TO CHANGE> AND `language_id` =<YOUR LANGUAGE>;

     

    <YOUR SORT ORDER> - number (only!) of sort order you want to give

    <OPTION ID TO CHANGE> - number (only!) of options you want to set new sort order

    <YOUR LANGUAGE> - number (only!) of language for such an option

     

    Also, check catalog\product_info.php for code:

     

    $products_options_name_query = tep_db_query("select distinct popt.products_options_id .......... order by popt.products_options_sort_order ......

    I don't remeber exactly, cause QTPro and I changed this. "popt.products_options_sort_order" in "order by" clause of this query solve your issue completely.

  6. Does anyone know how I sort the options? Not the attributes. I have the AJAX Attribute Manager as well as the Attribute sort with clone add-ons installed. I can sort the attributes, but on the page the OPTIONS are in a funky order. They are not in alphabetical order nor are they even in the order I added them! Where do I sort those?

     

    For example, I have:

     

    Option A

    Option 1

    Option 2

    Option 3

     

    I added them in that order. It is also alphabetical order. Option 1, 2 & 3 each have 91 attributes, which are in the correct order. Option A has 5 attributes, also in the correct order.

     

    However, they are showing up this way:

     

    Option 1

    Option A

    Option 2

    Option 3

     

    I have tried everything I can think of, Searched in every way I can think of through the forums, etc. anyone have an idea how to fix this? It looks bad on the client side. Thanks.

  7. Jenica,

     

    you don't need to install QT Pro. In the latest version this plugin is tutned on by default. So, simple disable it by do following:

     

    find catalog\admin\attributeManager\classes\attributeManagerConfig.class.php and edit line 65 "AM_USE_QT_PRO", set it to "false".

     

    That worked, thanks!!

  8. Jenica,,, what browser are you using? FireFox 3.6?

     

    I tried everything to fix my issue, When I went in using IE 6.0 Everything started working fine..

     

    Give it a trie and let me know.

     

    I uninstalled it for now, but yes I'm using Firefox. My IE has some bug. When I get time, I'll re-install the add-on and fix my IE and try it there. Thanks for letting me know!

  9. I've just installed this contrib and I'm getting errors. It wants to track stock of the attributes. I haven't installed any add-ons to do that , so its giving me errors. On my product info page, when I'm inserting a new product's attributes, I get this error:

    1054 - Unknown column 'products_options_track_stock' in 'field list'

     

    insert into products_options (products_options_id, language_id, products_options_name, products_options_sort_order, products_options_track_stock) values ('25', '1', 'White', '1', '0')

     

    [TEP STOP]

     

    1054 - Unknown column 'products_options.products_options_track_stock' in 'where clause'

     

    select products_name, products_options_name as _option, products_attributes.options_id as _option_id, products_options_values_name as _value, products_attributes.options_values_id as _value_id from products_description, products_attributes, products_options, products_options_values where products_attributes.products_id = products_description.products_id and products_attributes.products_id = '63' and products_attributes.options_id = products_options.products_options_id and products_attributes.options_values_id = products_options_values.products_options_values_id and products_description.language_id = 1 and products_options_values.language_id = 1 and products_options.products_options_track_stock = 1 and products_options.language_id = 1 order by products_attributes.options_id, products_attributes.options_values_id

     

    [TEP STOP]

    Its trying to access a column that is not there. No where in the installation instructions does it tell me to do anything to my database. From my searches of the forums, I'm thinking this has something to do with the QT Pro, which I have never installed. Do I need to add this column to the db? If so, I don't know how to write that code, and I'm wondering why this package didn't come with it. Or, do I have to have this QT pro installed?

     

    There are no references to the column in any of the files I edited, only in the attribute manager files.

     

    Can anyone help? I'd like to be able to use this add on! Thanks!

  10. Server Info

     

    Its been there since at least MS2, hopefully u have nothing ealier, you said u have a number of sites on the server, try on one of the others.

     

    Somehow that file must have been deleted. I did a backup and a restore and found this:

     

    SCRIPT_FILENAME /hsphere/local/home/myname/mysite.com/admin/server_info.php

     

    Same string as I had posted before.

     

    (In order to fix this little error, do I need more than the tools.php and server_info.php files? Plus I see I need to add a define to the filenames.php)

     

    Anyway, back to the original topic, I am using Commerce 2.2-MS2, PHP Version 4.4.9.

     

    It looks like I'm getting that same string everywhere I look. "/hsphere/local/home/myname/mysite.com" so should it be:

     

    $Config['UserFilesAbsolutePath'] = '/hsphere/local/home/myname/mysite.com/catalog/userfiles/' ;

     

    My host is Host Excellence. My system says Linux, Server API is CGI/FastCGI. Any other information you need?

  11. What sort of server/hosting do u have? Is it a windows server by any chance (not the best choice)!!

     

    in admin->tools, select server info, look down the list to Environment what does it show for SCRIPT_FILENAME ?

     

    I don't have server info. I have:

     

    Tools

    Database Backup

    Banner Manager

    Cache Control

    Send Email

    Newsletter Manager

    Who's Online

     

    And I'm thinking I used to have something like that. So I don't know if it disappeared somehow. I looked in my tools.php is shows this:

     

    if ($selected_box == 'tools') {
       $contents[] = array('text'  => '<a href="' . tep_href_link(FILENAME_BACKUP) . '" class="menuBoxContentLink">' . BOX_TOOLS_BACKUP . '</a><br>' .
                                      '<a href="' . tep_href_link(FILENAME_BANNER_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_BANNER_MANAGER . '</a><br>' .
                                      '<a href="' . tep_href_link(FILENAME_CACHE) . '" class="menuBoxContentLink">' . BOX_TOOLS_CACHE . '</a><br>' .
                                      '<a href="' . tep_href_link(FILENAME_MAIL) . '" class="menuBoxContentLink">' . BOX_TOOLS_MAIL . '</a><br>' .
                                      '<a href="' . tep_href_link(FILENAME_NEWSLETTERS) . '" class="menuBoxContentLink">' . BOX_TOOLS_NEWSLETTER_MANAGER . '</a><br>' .
                                      '<a href="' . tep_href_link(FILENAME_WHOS_ONLINE) . '" class="menuBoxContentLink">' . BOX_TOOLS_WHOS_ONLINE . '</a>');
     }

     

    Is there supposed to be a line for server info?

  12. I posted this in another thread, but I also wanted to post it here. Can anyone help?

     

    When I go into the program phpMyAdmin (provided by my hosting company) I see the table visitors is set up. This is what it shows when I click on it.

     

    databaseinfo2.jpg

     

    databaseinfo.jpg

     

    So it appears I've created the table. Why am I still getting this error?

     

    Fatal error: Cannot redeclare tep_db_connect() (previously declared in /hsphere/local/home/myname/mysite.com/catalog/includes/functions/database.php:13) in /hsphere/local/home/myname/mysite.com/catalog/includes/functions/database.php  on line 13

  13. When I go into the program phpMyAdmin (provided by my hosting company) I see the table visitors is set up. This is what it shows when I click on it.

     

    databaseinfo2.jpg

     

    databaseinfo.jpg

     

    So it appears I've created the table. Why am I still getting this error?

    Fatal error: Cannot redeclare tep_db_connect() (previously declared in /hsphere/local/home/myname/mysite.com/catalog/includes/functions/database.php:13) in /hsphere/local/home/myname/mysite.com/catalog/includes/functions/database.php  on line 13

  14. Please bear with me, I am very new!

     

    I have been installing this add-on and I get to this step:

     

    6.	Added to SQL_Db
    
    
    CREATE TABLE `visitors` (
    `email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    PRIMARY KEY ( `email` )
    ) ENGINE = MYISAM ;

     

    I have been searching for 45 min and I do not know where the SQL_Db is. I looked through my PHP Admin provided by my host, but I don't even know where to start there. Can anyone help? Thanks!

     

    I still haven't been able to finish this step. Can anyone help me? Is it something in my FTP program? I don't know where to see the databases.

  15. NO, neads to be

     

    $Config['UserFilesAbsolutePath'] = '/home/mysite/public_html/catalog/userfiles/' ;

     

     

     

     

    Nearly every site has public_html as their root folder (the folder below which there is no public access) I suspect you do have a public_html folder, u just don't know.

     

     

    The path detailed is an absolute path, that means the path on the server, these are always of the form: '/home/servername/public_html/catalog/'

     

     

    Look in your configure.php you will find: define('DIR_FS_CATALOG', '/home/servername/public_html/catalog/');

     

     

    If you still don't understand, ask your host or find someone that can explain the basics to you.

     

    I looked in my configure.php and it says this:

      define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/');

     

    I did see somewhere someone said to look in the backup under tools and mine says:

    /hsphere/local/home/myname/mysite.com//myadmin/backups/

     

    So I tried that (with the correct info and not the backups portion) and it still doesn't work.

     

    We have six websites on our account (which the hosting company calls "myname" - see above). When I look in the folders under my website, that's where I load straight html pages and where I see my catalog and admin folders. There is an images folder (for my html pages) and a bunch of folders that the hosting company put there. I looked through all of them and I have nothing titled public_html or anything close.

     

    Sorry, but this is all very new to me. I'm of a technical/computer background, but in a totally different area! Thanks so much for all of your help!

  16. Is this code correct? It seems very confusing to me what I'm supposed to put here.

     

    $Config['UserFilesAbsolutePath'] = '/home/mysite.com/catalog/userfiles/' ;

     

    I put the userfiles folder (that I created) under my catalog folder which is under my site name. Do I need the "root"? Or do I need "home"? In the instructions it says:

    /home/mysite/public_html/catalog/userfiles/

     

    I don't have anything called public_html. But then I also don't have anything titled home or root either. I know next to no programming, so forgive my ignorance please.

  17.  

    2.7's been the latest one for a while, I think they renamed FCK Editor to CKEditor or somethin, but anyway,

     

    Yes, there is a CKeditor download as well as a FCKeditor download. I downloaded the other first and when I went to follow the instructions in the contribution, there are completely different files inside that download. So I went back and downloaded the FCKeditor.

     

    Yep, not the autoinstaller but the last manual one. Its dated 27 June 2008.

     

    Check your "images" directory permissions are set to 777,

    Yep, it is 777.

     

    Check fck's config.php file, (Elmer Fudd Voice) <- This is veeeery importan, I'd start here.

    OK, I'll start with this one and go back through it again with a fine tooth comb.

     

    Make sure it's in "catalog/admin/fckeditor" and remember to change your admin folder later for security,

    The way my site it set up its mysite.com/catalog and mysite.com/admin (yes its renamed). So I put the fckeditor folder under admin, not catalog. Is this correct? Should I move my admin folder inside my catalog folder?

     

    Alter "/admin/categories.php" to change the Textarea

    Yes, I altered that one plus mail.php and categories.php and now none of them have a text area. I cannot make any changes or add new products right now. I'll look at them all again, but I'm suspicious that since its happened to all of them exactly the same that there s an error somewhere else. I'm not that good to create the same mistake exactly the same three times ;).

     

    Check /admin/includes/functions/html_output.php

    OK, I'll check that one 2nd.

     

    and the tips:

    in catalog/admin/fckeditor/fckconfig.js

     

    change line 153 from:

    FCKConfig.FontSizes = 'smaller;larger;xx-small;x-small;small;medium;large;x-large;xx-large' ;

    To:

    FCKConfig.FontSizes = '8;10;12;14;16;18;20;24;28;32;36;42;50;58;66;smaller;larger;xx-small;x-small;small;medium;large;x-large;xx-large' ;

     

    To add extra, but still standard fonts, change line 152 from:

    FCKConfig.FontNames = 'Arial;Comic Sans MS;Courier New;Tahoma;Times New Roman;Verdana' ;

    To:

    FCKConfig.FontNames = 'Arial;Arial Black;Comic Sans MS;Courier New;Tahoma;Times New Roman;Verdana;Georgia;Impact;Palatino Linotype;Trebuchet MS' ;

    I did both of these changes as well. Are you saying I should check those for the mistake? OR are you saying that I should do those tips if I hadn't already?

     

    Thanks so much for your help, I've been installing, uninstalling, re-installing and staring at the code for four days straight now. I'm tired of this add-on, lol!! My shop isn't live yet and I have more products to load. I'll have to take this down if I can't get it to work. I was just trying to do it before I opened so that my emails would have html for my customers. I've already been using html in my product description boxes to add additional pictures.

  18. OK, I've read through all 23 pages. Fun times. I'm trying to install FCKeditor2.6.5 (the latest version) that I downloaded from fckeditor.net. I'm not sure if I have php5 (I don't think I do), so I want to do it manually. I downloaded from here: http://addons.oscommerce.com/info/2900 the version that says 27 Jun 2008.

     

    I've completely installed it twice and both times I get the same result. No message box at all. When I go to write an email or edit/add a product, the box where you enter your information is just gone.

     

    Is it something to do with the version 2.6.5 vs the 2.6.2 that this install was written for? If it hadn't ended up with the exact same result for me both times, I would figure it was some tiny error. But I get no actual errors/warnings, just no box showing.

     

    Can anyone make a suggestion as to what this might be? Should I download the older version of the fckeditor? Or which file should I look into for an error?

     

    Thanks so much for any help!

  19. Please bear with me, I am very new!

     

    I have been installing this add-on and I get to this step:

     

    6.	Added to SQL_Db
    
    
    CREATE TABLE `visitors` (
    `email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    PRIMARY KEY ( `email` )
    ) ENGINE = MYISAM ;

     

    I have been searching for 45 min and I do not know where the SQL_Db is. I looked through my PHP Admin provided by my host, but I don't even know where to start there. Can anyone help? Thanks!

×
×
  • Create New...