Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

nealc

Pioneers
  • Posts

    181
  • Joined

  • Last visited

Everything 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. Great, Thank you. I will install these contributions and see how they work for me.
  5. 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?
  6. 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.
  7. 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);
  8. 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.
  9. 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
  10. Just got finished editing the paypal module to include the item when submitting the order to paypal

  11. 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 //-->
  12. 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!
  13. Could you post your cc_validation.php code?
  14. 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.
  15. Jon, What did you guys change that worked for this? I am going crazy trying to fix this!! Thanks, Neal
  16. 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.
  17. 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
  18. 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.
  19. 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.
  20. 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?
  21. 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.
  22. Did you double check that you created the table coupons?
  23. Can't seem to find where this if ($action == 'install') { is called in admin/configuration.php, used the search function to try to find this and it says that is cannot be found. Checked all other areas where configuration.php is located and none have that bit of code. Any help?
×
×
  • Create New...