Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

nealc

Pioneers
  • Posts

    181
  • Joined

  • Last visited

Posts posted by nealc

  1. I have just signed up for the Fraud Detection Suite with Authorize.net but now none of the orders submitted by my customers go to the success page, in which case my customers do not ever know that their order went through which I have lost some sales due to this. Has anyone ever got this to work properly with Oscommerce?

  2. I don't know if this is the area to be posting this, but I have just installed Ajax Single Page Checkout and am trying to install Discount Coupons with this but am unable to get it to work or even show up in the checkout area. Is there anyone that has successfully installed these two contributions that may be able to assist me?

     

    Thank you.

  3. Are there other pages that I need to edit in order to get other contributions to work with STS? I am currently trying to add Ajax Buy Now and Ajax Shopping Cart to my site. I have installed them both via the install instructions, both do not work. I click to add a product to my cart it takes me right to the shopping cart page, and the Ajax Shopping Cart, well it never takes me to the shopping cart I get a 403 error you don't have permission to access /ajax_checkout.php on this server. Thinking this had to do with permissions I changed the permissions which did not work.

     

    I uploaded my site to here if anyone wanted to take a look and see the error: My Site

  4. Thanks Spooks, yeah the error is actually on my local server where i test all changes prior to uploading them to my live site. I've been messing around with the code but nothing I do changes the errors, but I will certainly check out that contribution. Do you know off the top of your head if you can use HTML with that contrib?

  5. Yeah...while that sounds nice and all, I still don't like just having products show up in each of the categories main page, I want more information for the customers with some idea as to the types of products we sell and then we can add some featured products for that category as well.

  6. Ya know I really do not know why either, all I am truly trying to do is change each of the category pages to look a bit different by adding some html to each, rather than the new products that gets a bit boring after a while.

     

    I am guessing that my error has to do with this bit of code here:

     

    if ($category_depth == 'nested') {

    $category_query = tep_db_query("select cd.categories_name, cd.categories_description, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

    $category = tep_db_fetch_array($category_query);

  7. I believe you are most correct.

     

    My categories_description table shows these as the column headers: categories_id, language_id, categories_name, categories_description, categories_seo_url. I believe categories_description was added to this table, this is the sql that needed to be injected into my database: ALTER TABLE categories_description ADD categories_description text NULL AFTER categories_name;.

     

    I am still a bit lost as to what I should change to make this contrib work.

  8. Hello,

     

    I am receiving an error whenever I try to open any category, the error is:

     

    1054 - Unknown column 'cd.categories_description' in 'field list'

     

    select cd.categories_description from categories c, categories_description cd where c.categories_id = '59' and cd.categories_id = '59' and cd.language_id = '1'

     

    [TEP STOP]

     

    I have tried "googling" this particular error but nothing relevant showed up that would help me out, so I am turning to you guys. The contrib I used is: http://addons.oscommerce.com/info/6250

  9. I just recently installed an Ajax Shopping Cart to my site. Basically, it all works the way I want it to with the exception of a few things. What I would like to have is in the shopping cart box instead of having the default Oscommerce view cart image, I would like to add my own image, which I tried but whenever I added a new item to the cart it would take me to the shopping cart and the image would not load, what loaded instead was the default oscommerce image. Now I cannot for the life of me figure out why it is doing that when I removed all calls for that default image in includes/boxes/shopping_cart.php. If anyone can help me out I would really appreciate it. Here is the code for both:

     

    This is what I am using currently:

    <?php
    /*
     $Id: shopping_cart.php 1739 2007-12-20 00:52:16Z hpdl $
    
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Copyright (c) 2003 osCommerce
    
     Released under the GNU General Public License
    */
    ?>
    <!-- shopping_cart //-->
             <tr>
               <td id="shopping-basket-text">
    <?php
     $info_box_contents = array();
     $info_box_contents[] = array('text' => BOX_HEADING_SHOPPING_CART);
    
     new infoBoxHeading($info_box_contents, false, true, tep_href_link(FILENAME_SHOPPING_CART));
    
     $cart_contents_string = '';
     if ($cart->count_contents() > 0) {
       $cart_contents_string = '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
       $products = $cart->get_products();
       for ($i=0, $n=sizeof($products); $i<$n; $i++) {
         $cart_contents_string .= '<tr><td align="right" valign="top" class="infoBoxContents">';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           $cart_contents_string .= '<span class="newItemInCart">';
         } else {
           $cart_contents_string .= '<span class="infoBoxContents">';
         }
    
         $cart_contents_string .= $products[$i]['quantity'] . ' x </span></td><td valign="top" class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           $cart_contents_string .= '<span class="newItemInCart">';
         } else {
           $cart_contents_string .= '<span class="infoBoxContents">';
         }
    
         $cart_contents_string .= $products[$i]['name'] . '</span></a></td></tr>';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           tep_session_unregister('new_products_id_in_cart');
         }
       }
       $cart_contents_string .= '</table>';
     } else {
       $cart_contents_string .= BOX_SHOPPING_CART_EMPTY;
     }
    
     $info_box_contents = array();
     $info_box_contents[] = array('text' => $cart_contents_string);
    
     if ($cart->count_contents() > 0) {
       $info_box_contents[] = array('text' => tep_draw_separator());
       $info_box_contents[] = array('align' => 'right',
                                    'text' => $currencies->format($cart->show_total()));
     }
    
     new infoBox($info_box_contents);
    ?>
               </td>
             </tr>
    <!-- shopping_cart_eof //-->

     

    This is what I would like to use: Obviously something is wrong

    <?php
    /*
     $Id: shopping_cart.php,v 1.18 2003/02/10 22:31:06 hpdl Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Copyright (c) 2003 osCommerce
    
     Released under the GNU General Public License
    */
    ?>
    <!-- shopping_cart //-->
               <tr>
               <td id="shopping-basket-text">
    <?php
     $info_box_contents = array();
     $info_box_contents[] = array('text' => BOX_HEADING_SHOPPING_CART);
    
     //new infoBoxHeading($info_box_contents, false, true, tep_href_link(FILENAME_SHOPPING_CART));
    
     $cart_contents_string = '';
      if ($cart->count_contents() > 0) {
       $cart_contents_string = '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
       $products = $cart->get_products();
       for ($i=0, $n=sizeof($products); $i<$n; $i++) {
         $cart_contents_string .= '<tr><td align="right" valign="top" class="infoBoxContents">';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           $cart_contents_string .= '<span class="newItemInCart">';
         } else {
           $cart_contents_string .= '<span class="infoBoxContents">';
         }
    
         $cart_contents_string .= $products[$i]['quantity'] . ' x </span></td><td valign="top" class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           $cart_contents_string .= '<span class="newItemInCart">';
         } else {
           $cart_contents_string .= '<span class="infoBoxContents">';
         }
    
         $cart_contents_string .= $products[$i]['name'] . '</span></a></td></tr>';
    
         if ((tep_session_is_registered('new_products_id_in_cart')) && ($new_products_id_in_cart == $products[$i]['id'])) {
           tep_session_unregister('new_products_id_in_cart');
         }
       }
       $cart_contents_string .= '</table>';
     } else {
       $cart_contents_string .= BOX_SHOPPING_CART_EMPTY;
     }
    
    $cart_contents_string .= '<a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><img alt="" src="images/blue-view-cart.gif" width="135" height="35" border="0" hspace="5"></a><span class="ShoppingCart">' . BOX_HEADING_SHOPPING_CART . '</span><a href="' . tep_href_link('shopping_cart.php'). '" class="null"><span class="null"> ' . $cart->count_contents() . '</span></a>';
    
     $info_box_contents = array();
     $info_box_contents[] = array('text' => $cart_contents_string);
    
     if ($cart->count_contents() > 0) {
       $info_box_contents[] = array('text' => tep_draw_separator());
       $info_box_contents[] = array('align' => 'right',
                                    'text' => $currencies->format($cart->show_total()));
     }
    
     new infoBox($info_box_contents);
    ?>
                </td>
             </tr>
    <!-- shopping_cart_eof //-->

  10. I just installed the latest Authorize.net AIM from http://addons.oscommerce.com/info/4091 and I'm getting the same thing, invoice number is always 1, instead of using the order number.

     

    Is there a quick and dirty way to fix this?

     

    Change this:

    // Calculate the next expected order id
    		$last_order_id = tep_db_query("select * from " . TABLE_ORDERS . " order by orders_id desc limit 1");
    		$new_order_id = $last_order_id->fields['orders_id'];
    	 //$new_order_id = ($new_order_id + 1);

    And comment out like this:

    // Calculate the next expected order id
    	 //$last_order_id = tep_db_query("select * from " . TABLE_ORDERS . " order by orders_id desc limit 1");
    	 //$new_order_id = $last_order_id->fields['orders_id'];
    	//$new_order_id = ($new_order_id + 1);

    Add this code just below the above code:

    // A.NET INVOICE NUMBER FIX
    	// find the next order_id to pass as x_Invoice_Num
    	$next_inv = '';
    	$inv_id = tep_db_query("select orders_id from " . TABLE_ORDERS . " order by orders_id DESC limit 1");
    	$last_inv = tep_db_fetch_array($inv_id);
    	$next_inv = $last_inv['orders_id']+1;
    	// END A.NET INVOICE NUMBER FIX

    And change this here:

    'x_invoice_num'		 => $new_order_id,

    To this:

    'x_invoice_num'		 => $next_inv,

     

    You will then see the invoice number attached to your order in Authorize.net!

  11. I have been having tremendous issues with authorize.net Here is the error message I'm getting

     

    Parse error: syntax error, unexpected $end in /home/trendyfa/public_html/includes/classes/cc_validation.php on line 95

     

     

    Anybody might have a clue whats wrong? Thanks

    Could you post your cc_validation.php code?

  12. Hello,

     

    I currently use 2 checkout.com for my sales, and want to switch to authorize.net. If I install the module from my admin and put in all required info will it work? Im not technical is why I am asking. I need to know if I will need contributions to make it work.

    Thank you for all replies.

    Sam

    Hey, I just recently switched from 2 checkout to authorize.net about a week ago. It took a few adjustments but I was finally able to get authorize.net to work for me. I had to add a new authorize.net (aim) module from the contribs section to get it to work, this may not be the case for you. If you have authorize.net set up in your payment modules section you should just be able to plug in the information you obtain from authorize.net and it should work, really no other "configuring" needed on your end unless something goes awry.

  13. Jeff,

     

    I spent hours trying to get this module working. Changing the checkout_confirmation.php code as you suggested worked perfectly and did not mess up any of my other payment modules. Thank you so much for posting this fix and the logger as well! I wish there was an update on the module download page for this I can only imagine how many others are having this issue and the time being wasted.

     

    Thanks again!

     

    Jon

    Jon,

     

    What did you guys change that worked for this? I am going crazy trying to fix this!!

     

    Thanks,

     

    Neal

  14. Sounds similar to a problem I had a couple of months ago. Ended up being a security upgrade to our website. Something has changed if it just stopped working.

     

    Have you install any contributions recently? If you haven't changed anything on your site, check with your hosting company, have they recently done any upgrades or changes on the host computer?

     

    Ask them to check the firewall on the host computer, make sure port 443 is open and https://secure.authorize.net is not being blocked.

     

    Authorize.Net is a great company, but they will not admit if anything goes wrong on their end. Just keep looking for anything that may have changed with your setup.

     

    Frank

    Hey, did you ever get this resolved? I am running into the same error and i see no error codes whatsoever so Authorize.net cannot help me. I even tried installing another contrib for authorize.net, which worked in test mode, took it right out of test mode and placed into live mode and i immediately get redirected to the checkout_payment page with the same error as with the old contrib. Should I call go daddy again and see if they have port 443 open, which i would assume would be because I have SSL installed.

  15. Hi all i would like to add the lightbox to my website, i don't want to have the pop up page to be open if the customers will click to see the image, i think it's more classic or impresive to have the lightbox software .

    iam not a programer i have basic knowledge with programming, so any body can tell me please how to download the program (light box) and the most important how to install it to my website step by step ...!!

     

     

    Kind Regards,

    Hey....it's actually really simple. Just download lightbox here: http://www.huddletogether.com/projects/lightbox/

     

    The install is really simple. All you have to do install the javascript on your site, I believe that link I gave you gives you step by step instructions.

     

    Better yet, use this: http://addons.oscommerce.com/info/6517

  16. i also found the same code to amend in other payment modules as it says to amend for paypal

     

    Problem is I do not find that code at all in my module. But after testing it again it went right to 2checkout. Now I must test it fully by actually placing an order and seeing if it redirects me back to my site.

  17. have you added any html tags in you lincludes/anguages/xxxx/modules/payment/2checkout.php in the defines or in lincludes/anguages/xxxx/2checkout.php

     

    as that can cause it not to direct to payment merchant also double check you didnt miss anything on the install

    No, I didn't touch that at all. I will check that out. I am sure that is the only step I bypassed for the install as I thought it was only meant for paypal only.

  18. Install firefox fiebug addon, now enable one page checkout, where the top bar should be right click on it, select view element and look to see what image and path it is calling, now simply see if it is correct ie you have that image in images folder if not make one

    Thank you, I was able to get the checkout to display correctly. Now, I do not use paypal but 2checkout. I am not being redirected to the 2checkout portal page, is that because I am missing something in the install?

  19. I am currently having display issues, where the product description etc. should be shown I get no bar running across the top, basically all it shows are the corner gif's, very odd to me. I have this turned off right now as I try to resolve this issue. But if anyone can help that would be appreciated.

  20. I have now run the sql code successfully on my phpmyadmin tool. Never done that before!

     

    I still have this checkout error:

     

    "

    1146 - Table 'planetprim1.TABLE_COUPONS' doesn't exist

     

    select count(*) as total from TABLE_COUPONS where coupon_status = '1'

     

    [TEP STOP]"

    Did you double check that you created the table coupons?

×
×
  • Create New...