33 replies to this topic

[Barcelona]

Got a little error that is coming up with my USPS     

An error occured with the USPS shipping calculations.
If you prefer to use USPS as your shipping method, please contact the store owner.

any ideas what I need to do?   look here   http://www.winecoat.com/shop

[Wallyr41]

Glad you asked this question, I too have the same problem and was about to post the same.
Wallyr41

[apollowear]

Me too, it seems the USPS site is down for calculating postage.

[blunt]

I have been having the same problem for a while, calculations work perfectly for certain adresses (United states) but I get:

United States Postal Service United States Postal Service  
An error occured with the USPS shipping calculations.

Whenever I fill in other foreign addresses (testing south african adresses, all give me that error)

does anyone know what this is from? need to get this fixed asap.

[stsbutch]

apollowear, on May 28 2007, 11:44 AM, said:

Me too, it seems the USPS site is down for calculating postage.

Call 1-800-344-7779 and ask them to switch you to te production server and you will be up and running in minutes

[Wallyr41]

Wallyr41, on May 28 2007, 01:38 AM, said:

Glad you asked this question, I too have the same problem and was about to post the same.
Wallyr41

First, go on line and get a USPS Account at USPS.com. Call USPS (1-800-344-7779 and asked them to be switched, tell them that you have a oscommerce website and you want your account moved from test to the production server. They will ask you for your USPS account number. It will take them a couple minutes to complete the process. After they give you the ok you will have to enter a postal code in the
admin->configuration->Shipping/Packaging. Be sure to switch the test module to production; enter the word "password" in the password location. All done. Good Luck.
Wallyr41

[pederb]

For us who already have a USPS account and get the same messages

[Barcelona]

Usps Module is GREAT!!!!

[blunt]

http://www.oscommerce.com/community/contributions,487

my problem was that I hadn't done the necessary changes for international shipping

the url above has the new version of the module if yours is old

[n2advnture]

I have been on the production server for about a year and half with no problem and using the standard OSC USPS shipping module.  I have been getting this same error for orders outside of the US for about a week now.

Something has definitely changed on the USPS end and my OSC is fairly unmodified with add-ons and I haven't touched it.

~Mark

[Exzakt]

I updated the USPS Methods and still most of my customers are getting error messages therefore unable to order.

This must be a major problem for others out there besdies myself.

[candleman]

Exzakt, on Jun 8 2007, 08:06 PM, said:

I updated the USPS Methods and still most of my customers are getting error messages therefore unable to order.

This must be a major problem for others out there besdies myself.

Mine has been working fine up to a few days ago and I'm getting the same error now.  If your using the USPS Methods you can uncomment a certain line and have the XML reponse Emailed to you.  I did and it says that the username/password is incorrect.  Been using the same one for over a year with no problmes and suddenly it's incorrect.

I emailed tech support at USPS, still waiting back to hear, but from what I can tell they don't use passwords anymore and the contrib is trying to send one.

Will post back when I hear from them.

[notubes_pete]

I to am having the problem. A few weeks ago i upgraded for the new rates and sometimes Friday or over the weekend it went down.

I am on hold with USPS right now.

[notubes_pete]

i had to change what server is used to $usps_server = 'production.shippingapis.com';

[candleman]

candleman, on Jun 11 2007, 08:18 AM, said:

Mine has been working fine up to a few days ago and I'm getting the same error now.  If your using the USPS Methods you can uncomment a certain line and have the XML reponse Emailed to you.  I did and it says that the username/password is incorrect.  Been using the same one for over a year with no problmes and suddenly it's incorrect.

I emailed tech support at USPS, still waiting back to hear, but from what I can tell they don't use passwords anymore and the contrib is trying to send one.

Will post back when I hear from them.

I had to change my password to "password" and change the production server to $usps_server = 'production.shippingapis.com';

It seems they changed things again.

[kdogg]

candleman, on Jun 11 2007, 11:05 AM, said:

I had to change my password to "password" and change the production server to $usps_server = 'production.shippingapis.com';

It seems they changed things again.

Tried that, didnt work for me.

Still get the error for international shipping.

Also, yes, I called them a year ago and got changed to the production server.

Seems what fixes this error for some people, doesnt for others.

[notubes_pete]

did you update the shipping method name for international shipments? They changed the names of the method.

[n2advnture]

Ok...I decided to re-install the "USPS Methods_2.8d" & "USPS Methods Update for Postal Rates & Services Changes 5.14.07"

1.) Turn off ("remove") the USPS shipping module in your admin first (be sure to save all your USPS server login / password info first)

2.) Install "USPS Methods_2.8d" per the instructions

http://www.oscommerce.com/community/contri...ch,usps+methods

3.) Install "USPS Methods Update for Postal Rates & Services Changes 5.14.07" per the instructions

4.) In PHPAdmin, run the SQL queries.

5.) In OSC Admin, re-install the USPS shipping module and edit the info for you server login/password and make sure you're on the "production" server.

Works like a charm now. I believe the the error is caused by an improper installation during the editing of the USPS.php file. Instead of replacing code, comment out the old code by placing a /* before and a */ after the old code. Then paste in the new code.

Here's my tip - go slow...some the code that needs to be replaced in the USPS.php file looks the same in 5 places but read CAREFULLY and make sure you are replacing the EXACT same code. Not sure if this was my problem but it's working now, so I am pretty sure that's what occurred.

Either that or I ran the first SQL query and didn't run BOTH SQL queries

Good luck!

~Mark

[esilk]

I have tried to follow the installation procedures many times, and each time I get the same error when I go to edit the usps in the admin where everything shows up except the list of checkboxes for international options:

Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /home/hsphere/local/home/esilk/thepicturemug.com/admin/modules.php(216) : eval()'d code on line 1

Also, when I tried to run the sql command:
ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
I got an sql error:
#1074 - Too big column length for column 'set_function' (max = 255). Use BLOB instead

I tried changing it from 555 to 255, but then got the error:
#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 'COLLATE latin1_swedish_ci NULL DEFAULT NULL' at line 1

Before I do the USPS51407RateServiceChangeUpdates.zip, the parse error does not show, but of course I get the usps error when trying to checkout from the store.

The parse error also does not appear if the only things I DON'T do are changing the "tep_db_query("insert into..." statement in the /catalog/modules/shipping/usps.php file AND don't run the sql queries.

It seems so straightforward but I'm very confused since I've repeated the steps so many times and still no go.

Any ideas where I'm going wrong with this?

Thanks!

[esilk]

OK...Nevermind. I found the problem is that my server is running MySQL v4.0.26

I changed the first MySQL command to:

ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT

instead of:

ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

and everything worked fine.

I'm going to see if I can update the USPSMethods_2.8d Updates for May 14 Rates & Service Changes (minor correction) contribution with the requirements for servers with MySQL below version 5.0.3

cheers!