ozEworks

We has an issue with the Admin Approve process. Warning: Error while sending QUERY packet. PID=21752 in /home/ozeworks/public_html/support/xxxxxx/admin/includes/functions/database.php on line 53 2006 - MySQL server has gone away update fraudlabs_pro set fraudlabspro_status='APPROVE' where order_id = '5144' [TEP STOP] 2006 - MySQL server has gone away select 1 from sessions where sesskey = '0bc4c6a91bbfca74f41060b7986defdc' [TEP STOP] Updating max_allowed_packet to 1GB did not fix. Looking at the https://apps.oscommerce.com/HboCa V 1.3.5 must be out of date. Attached is our patched version. Tested on Fraudlabs Pro osCommerce 2.3. FraudLabsPro_ozeworks_update.zip

The bottom lins is Authroize.net wants people to move to their new API and I believe the core of that relates to recurring billing and customer records etc. to be PCI compliant both ends (site and authorize.net). They are not going to let you use methods that violate PCI on their end. If you do recurring billing and/or use CIM, you will probably end up with a problem. So at some stage the team need to develop a new Authorize.net module based on the new API.

Authorize.net have announced AIM and SIM have reached end of life. They will no longer be supported but you will be able to keep using them.. Specifically their APIs will remain available but not be upgraded. If any PCI compliance changes occur in the future (simple for example you had to collect Card Type as part of the transaction) these APIs will not meet them and you therefore would be not compliant if you continued to used them. Read full notice here https://support.authorize.net/s/article/Recurring-Billing-Flag-Rebill-Feature-End-of-Life-Overview There is new API available. See https://developer.authorize.net/api/ and osCOmmerce will need to work to provide a module to use with MS 2.2/2.3. So bottom line there is no date associated with this. Your payment modules will continue to work. If/when an osCommerce Add On is released using the new API you should upgrade to it.

For anyone using International Checkout (or thinking to) they have gone out of business. You will just get a 404 page not found when you try and use it. https://www.internationalcheckout.com/cart.php When queried about the error, they stated:

I want to clarify where we can download "PayPal Payments Pro Hosted Solution Payflow Edition" which you need for PayPal Advanced accounts. Can someone tell me?

Suren are you trying to use Sandbox mode?

Do you still support osCommerce? I don't see any reference to it on your actual site.

Just a note for people use the older MS2.2 / Rc2a USPS V4 module there are service name changes to Domestic you will need to make changing Standard Post to Retail Ground. It will be in several places in the code. Also the name changes from being Registered Mark to a Trademark. 'USPS Retail Ground tradmrk' => 'USPS Retail Ground tradmrk', Uninstall and reinstall to test. Don't forget to keep your USPS ID to add back when you reinstall. See https://www.usps.com...lease-notes.rtf Other changes (Flat Rate boxes as a container) do not seem to impact the old module. Switch your current module to $usps_server = 'stg-production.shippingapis.com' to test impact

Sorry I will

Just a note for people use the older MS2.2 / Rc2a USPS V4 module there are service name changes to Domestic you will need to make changing Standard Post to Retail Ground. It will be in several places in the code. Uninstall and reinstall to test. Don't forget to keep your USPS ID to add back when you reinstall. See https://www.usps.com/business/web-tools-apis/2016-jan-webtools-release-notes.rtf Other changes (Flat Rate boxes as a container) do not seem to impact the old module. Switch your current module to $usps_server = 'stg-production.shippingapis.com' to test impact

OK we will test it out on Rc2a site and let you know.

As usual with the USPS upgrade it is not just a rate change. There are service names changes as well. Is anyone looking at updating the Add On?

It would be good to get an official response from the osCommerce team but this will largely depend on what version of osCommerce you are running. the PayPal module you are using and your hosting environment. Over at Zencart (an old osCommerce clone) they say it won't effect the code but they have advised FOR THE TECHNICALLY-INTERESTED: PayPal's update is occurring in 2 stages: A VeriSign G2-to-G5 Root Certificate Upgrade, and then a SHA-256 SSL certificate. And, strictly speaking, those changes have NO IMPACT on the PHP code used in Zen Cart. But they do affect underlying server technologies used on your webserver. 1. VeriSign Root Certificate Upgrade: We've already tested Zen Cart against the PayPal sandbox, which is already using the Verisign G5 Root Certificate, and it works fine. But that's because the webservers we tested on already have the Verisign G5 Root Certificate authority files installed. Your host can help you with this. See the link below. 2. SHA-256 SSL certificate PayPal isn't updating the "api-3t.paypal.com" endpoint (used in Zen Cart v1.3.x and v1.5.x) until June 2016 (and sandbox too, so we can't test that just yet; nevertheless, it's a server config thing, not a Zen Cart thing). But in 2015 there is a big push for all webservers to start using SHA-256 SSL certificate chains. As such, you should ensure that your hosting company properly updates your server's SSL certificate store. a) PayPal offers some advice for your hosting company here: https://ppmts.custhelp.com/ci/fattac...20English).pdf b) And you can also ask your hosting company to fix any SSL problems reported for your site as mentioned in #3 above.

We have successfully implemented UPS dimensional shipping. It does require some fine tuning in terms of product dimensions and box sizes to get it to calculate correctly but that effort is largely on the user side although we did have to add a debugger to see what was being sent to UPS so we could then match rates with their site.

I can see a new version is being worked on. Has anyone noticed issues with existing/older versions due to the Sept 8 2014 changes 1. Domestic Signature Confirmation Charge not being added 2. International First Class letters Service not being offered