usps.com Click-n-ship AutoFill Button Contrib

[10000cranes]

I've read through the posts and can't quite find the answer ...

Problem:
I don't have the Autofill Button on the Admin > orders page.

I want to believe that I uploaded everything appropriately ... I probably didn't.
I did the over ride thing on the admin> orders ... I copied the orders.USPS and pasted that over the original admin>orders . Is that correct? I saw a line about "remove excess" and don't know what that means.
Any help is appreciated.
Thanks

[qhome]

I've read through the posts and can't quite find the answer ...

Problem:
I don't have the Autofill Button on the Admin > orders page.

I want to believe that I uploaded everything appropriately ... I probably didn't.
I did the over ride thing on the admin> orders ... I copied the orders.USPS and pasted that over the original admin>orders . Is that correct? I saw a line about "remove excess" and don't know what that means.
Any help is appreciated.
Thanks

Remove excess means to change the name from "orders.php_usps_only" to "orders.php" then overwrite your existing admin/orders.php file.

That alone should add the physical button. Now make sure that there is a file at admin/includes/modules/usps_autofill_button.php

[andrewmp]

Hey,
I'm trying to use this mod but I'm having trouble setting it up. When i run the sql command i get this error:

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I'm not sure if this problem has already been addressed. Has this already been fixed or do you have any suggestions?

Andrew

[qhome]

Hey,
I'm trying to use this mod but I'm having trouble setting it up. When i run the sql command i get this error:

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I'm not sure if this problem has already been addressed. Has this already been fixed or do you have any suggestions?

Andrew

Are you using a prefix on your database tables? If you are you need to edit the sql file and add the prefix to each table call (IIRC)

so

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

would become:

INSERT INTO prefix_configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

Same with the other insert command. Possibly even the update commands and from commands.

[andrewmp]

Are you using a prefix on your database tables? If you are you need to edit the sql file and add the prefix to each table call

No, I don't have a prefix. But I seemed to have fixed the problem.

I changed one value in one of the inserts.

Was

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

changed the first set of empty '' to

INSERT INTO configuration_group VALUES ('NULL', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

That NULL seemed to have done the trick. I'm not sure why that is. I'm using Zen Cart 1.3.8a and PHP Version 5.1.6.

Andrew

[qhome]

No, I don't have a prefix. But I seemed to have fixed the problem.

I changed one value in one of the inserts.

Was

INSERT INTO configuration_group VALUES ('', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

changed the first set of empty '' to

INSERT INTO configuration_group VALUES ('NULL', 'USPS Auto-Fill Config', 'USPS Auto-Fill Config', '1', '1');

Andrew

Ahh yes. I never updated the sql to be MySql 5 compliant. '' has been replaced by NULL for MySql5. Good find.

[ts232]

As of this morning, clicking on the USPS Autofill number sends me to the USPS website where I just get "Error 500". I haven't made any changes to it.

Is it still working for everyone else?

[milobloom]

Yes!

GASP!!! Whats going On!

[ts232]

Yes!

GASP!!! Whats going On!

Yes it still works for you, or yes it is broken for you?

On a hunch, I went to the config tools and changed the 'X' value for shipping weight ounces that was used to make it work in the past. No difference in the result however.

[ewodzien]

I've got the same problem. It actually started last night. Nothing obvious is standing out. I think that USPS changed something on their end.

If I can help the author test anything, please let me know.

-Ed