Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSSamm

Pioneers
  • Posts

    40
  • Joined

  • Last visited

Posts posted by OSSamm

  1. I have been getting emails from maxmind that say 

     

     

    Dear MaxMind Customer,

     

     

     

    You are receiving this email because you use our deprecated /app/ws_ipaddr web service endpoint. This endpoint returns a list of IP addresses for use when making minFraud or GeoIP web service requests to MaxMind servers.

     

     

     

    The endpoint /app/ws_ipaddr will be deactivated on April 28th, 2015. As a result, you need to take action in order to continue accessing MaxMind services. Please switch and make requests using theminfraud.maxmind.com hostname for minFraud web service requests and geoip.maxmind.com for GeoIP web

    service requests.

     

     

    If you use a minFraud client API provided by MaxMind, please update to the latest API, available on http://dev.maxmind.com/minfraud/. Our newest API versions use hostnames instead of /app/ws_ipaddr.

     

     

     

    If you use a third-party plugin that makes requests to MaxMind web services, you may need to update it.

     

    I have upgraded to the latest version of Maxmind and it appears the function  function readIpAddressFromWeb() in HTTPBase is still using http://www.maxmind.com/app/ws_ipaddrany plan to update this?

     

    So I realize I am chatting with myself, but it may be of some help to others. It looks like there is all the logic there to use the DNS and the new minfraud servers. 

     

    If you look at   HTTPBASE everything switches on   var $useDNS; however that is does not appear to be set anywhere. Setting it appears to resolve the issue. Atleast with the maxtest page. @@nrlatsha can you shed any light on this?

  2. I have been getting emails from maxmind that say 


    Dear MaxMind Customer,

     

    You are receiving this email because you use our deprecated /app/ws_ipaddr web service endpoint. This endpoint returns a list of IP addresses for use when making minFraud or GeoIP web service requests to MaxMind servers.

     

    The endpoint /app/ws_ipaddr will be deactivated on April 28th, 2015. As a result, you need to take action in order to continue accessing MaxMind services. Please switch and make requests using theminfraud.maxmind.com hostname for minFraud web service requests and geoip.maxmind.com for GeoIP web
    service requests.
     

    If you use a minFraud client API provided by MaxMind, please update to the latest API, available on http://dev.maxmind.com/minfraud/. Our newest API versions use hostnames instead of /app/ws_ipaddr.

     

    If you use a third-party plugin that makes requests to MaxMind web services, you may need to update it.

     

    I have upgraded to the latest version of Maxmind and it appears the function  function readIpAddressFromWeb() in HTTPBase is still using http://www.maxmind.com/app/ws_ipaddrany plan to update this?

  3. Any update on the missing Bank Info and Bin information. I am also running into this. 

     

    My gateway is First Data Global Gateway

     

    It does appear fine in the test page. Any idea where I may start looking?

     

    Ok I ended up figuring it out. It was actually the fact that we had recently switched payment processors. The new Payment addin was not setting the first 6 digits of the credit card on the order.

     

    Since maxmind.php actually uses the first 6 of the credit card for the bin query you can see that in maxmind.php at the line

     

    $h["bin"] = $cc;

     

    Unfortunately  I think this varies from payment system to payment system.

  4. When I go to recover cart stats page I get the following error.

     

    Working... 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ':1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and
    
    select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 817 OR o.customers_email_address like "" OR o.customers_name like "**********") and o.orders_status > a:1:{i:0;s:1:"0";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100103" and ot.class = "ot_total"
    
    
    

     

    and when I look in the file I see

     

    $orders_query_raw = "select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ') and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';
    	$orders_query = tep_db_query($orders_query_raw);
    	$orders = tep_db_fetch_array($orders_query);
    

     

    any suggestions

×
×
  • Create New...