Jump to content

baddog

Members
  • Content count

    1,150
  • Joined

  • Last visited

Everything posted by baddog

  1. baddog

    UPS ADDS 3 POUNDS Automatically in checkout

    For the benefit of those who see this thread and wonder how to fix their problem (assuming they have the same one), can you verify that the tare weight was set to 3 and the fix was to set it to 0?
  2. baddog

    UPS ADDS 3 POUNDS Automatically in checkout

    If you go to Admin and look under Configuration: Shipping/Packaging, what does it show for Package Tare Weight?
  3. baddog

    no gift in cat !?!?

    http://forums.oscommerce.com/index.php?showtopic=299553
  4. baddog

    Error processing credit card

    I doubt that authorize.net had anything to do with it. Somehow it looks like this contribution was coded into your file: http://www.oscommerce.com/community/contri...ns,5113/page,14
  5. baddog

    authorize.net ssl 3.0 upgrade concerns

    I don't know if it makes any difference at all, but you might try: curl_setopt ($ch, CURLOPT_SSLVERSION,3); See http://bluesunh.springnote.com/pages/1231596.xhtml (about half way down the page, look for CURLOPT_SSLVERSION). The only difference I can see is the elimination of one space and the addition of another.
  6. baddog

    Authorize.net SSL 3.0 Working?

    I think you should post this in the other thread because that's where the author posted the contribution link. http://forums.oscommerce.com/index.php?showtopic=328913
  7. baddog

    Authorize.net SSL 3.0 Working?

    I use this one: http://addons.oscommerce.com/info/4091 If the stock module works for you, it looks like there is only a very minor change made in the contribution mentioned earlier.
  8. baddog

    Authorize.net SSL 3.0 Working?

    See http://forums.oscommerce.com/index.php?showtopic=328913
  9. baddog

    Limit Best Sellers By Date

    Comparing the file that works with the new file (that generates the error), the only differences seem to be: Code in file that works: if (isset($current_category_id) && ($current_category_id > 0)) { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } else { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); Code in file that generates the error: if (isset($current_category_id) && ($current_category_id > 0)) { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op where p.products_status = '1' and p.products_ordered > 0 and op.products_quantity < 4 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '" . BESTSELLER_DAYS . "' group by p.products_id order by sum(op.products_quantity) desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS); } else { $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and op.orders_id = o.orders_id and op.products_quantity < 4 and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '" . BESTSELLER_DAYS . "' group by p.products_id order by sum(op.products_quantity) desc, pd.products_name limit ". MAX_DISPLAY_BESTSELLERS); According to the contributor of the most recent code (which generates the error), the clause {p.products_quantity = 1} was restricting the best sellers list to products whose stock quantity is equal to 1, the clause {p.products_quantity < 4} was measuring total stock, not quantity ordered for a given order, et cetera. Also, though the date range restriction was working, the quantity sold was taken as total quantity sold for all time, not the quantity sold during the date period of the date range restriction. Supposedly the new code fixes those problems, which is why I'm trying to find a fix for the new code. Any ideas?
  10. I tried using the 2 June 2008 version of best_sellers.php from this contribution: http://addons.oscommerce.com/info/1981 I got this error: 1111 - Invalid use of group function select distinct p.products_id, pd.products_name from products p, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_quantity < 4 and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '60' group by p.products_id order by sum(op.products_quantity) desc, pd.products_name limit 10 [TEP STOP] Can anybody spot the problem and suggest a solution? BTW, I get no errors using the changes to best_sellers.php contained in the 11 June 2005 posting (did not use the 8 Jan 2007 post). Also, I'm only using/testing the part of the contribution relating to best sellers. I am not using/testing the new products part. Thanks!
  11. baddog

    URGENT HELP NEEDED!

    If she can't direct you to a place where you can download the original files, try looking here: http://addons.oscommerce.com/category?search=mp3 and here: http://addons.oscommerce.com/category?search=text+editor
  12. baddog

    Error processing credit card

    Have you checked your settings using your authorize.net control panel? Look under Account. Go to Receipt Page. Click on Receipt Method. Look at Default Receipt Link (mine shows the full path to checkout_process.php) and Receipt Method (mine shows Post).
  13. baddog

    catagory accept only 4 character

    You should be able to modify the settings in the sql database.
  14. Try this: http://www.oscommerce.com/community/contributions,4091
  15. How about this one? http://addons.oscommerce.com/info/952
  16. baddog

    authorize.net ssl 3.0 upgrade concerns

    BTW, my Server Info shows: Registered Stream Socket Transports tcp,udp,unix,udg,ssl,sslv3,sslv2,tls So, I'm going to guess that I'm okay (since sslv3 is listed) and that I don't need to modify authorizenet_aim.php............can anyone who knows more about this than I do (probably most of you) verify that?
  17. baddog

    authorize.net ssl 3.0 upgrade concerns

    To fix authorizenet_cc_aim.php, it looks like all you have to do is find this (around line 342): curl_setopt($curl, CURLOPT_HEADER, 0); and insert the following as a new line below that: curl_setopt($ch, CURLOPT_SSLVERSION, 3); Has anyone looked at authorizenet_aim.php (from Vger's contribution) to see what changes are needed? The CURL code is: $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_VERBOSE, 0); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); $authorize = curl_exec($ch); curl_close ($ch);
  18. baddog

    Authorize.net not pulling sales tax

    My guess is that you didn't do it right. There is more than one step required. Can you describe in a little more detail what you did? Do you have a tax zone set up? How about a Tax Class? Did you set up the tax rate? Are your product listings set up correctly (correct tax class selected)?
  19. baddog

    Authorize.net not pulling sales tax

    My guess would be that the problem is not Authorize.net-related but rather a configuration issue on your site. What steps have you taken to set up the CA tax?
  20. baddog

    $2,000 sale shipped without payment!

    You might have found the problem...................
  21. Have you tried this module? http://addons.oscommerce.com/info/4091
  22. baddog

    Dynamic SiteMap

    A quick-n-dirty fix would be to modify the database entry.
  23. If it was working and suddenly stopped working, you need to figure out what changed in order to figure out why it stopped working and how to fix it. Did your host change something? Did you change something?
  24. I never took the time to try to figure out how to fix the stock module (which did not work for me) simply because I installed this module and it worked. It would be nice if the developers would address this issue.
  25. Try setting Receipt / Relay URLs to https://'secure.bluehost.com/~fantasu6'/enter_correct_path/checkout_process.php
×