usps.com Click-n-ship AutoFill Button Contrib

ses707:

MySQL is being really helpful here, simply remove the line ```
ALTER TABLE orders DROP total_weight;

Tried that. It ran, but error:
 9 statements processed.
 ERROR: Cannot ADD column total_weight because it already exists.
 Note: 1 statements ignored. See "upgrade_exceptions" table for additional details

Still no configuration settings.

sailsport1:

Tried that. It ran, but error:
9 statements processed.
ERROR: Cannot ADD column total_weight because it already exists.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details

Still no configuration settings.
Not sure what version of ZC/PHP/MySQL you are on but sounds like ZC 1.5? If it only processed 9 statements then you probably used the install-1.3.9, the install-1.5.0 includes an additional 4 statements which register the addon in admin access control.

@ses707:

I've posted your latest version, just in case someone clicks my link. Thanks for removing all the 'Return' items from SQL. Would you be so kind as to double-check the Page Registration? This process is new as of v1.5, and I haven't found much documentation for correct syntax.

@SPembleton:

Did you try the latest version by ses707? And, did you hit refresh while you were on that error page, or after you clicked the back button?

I think the error appears when there are residual configurations left from failed installations of this module. An alternative is to go into your admin_pages table, delete any rows for USPS AutoFill, and it might be a good idea to do the same in configuration table. Then install fresh files and run the latest SQL for your version of Zen Cart (click ses707's link above).

ses707:

Not sure what version of ZC/PHP/MySQL you are on but sounds like ZC 1.5? If it only processed 9 statements then you probably used the install-1.3.9, the install-1.5.0 includes an additional 4 statements which register the addon in admin access control.

I'm using ZC 1.3.9h
mySQL 5.1.52-cll
PHP 5.3.6

@sailsport:

Try going into your database and manually remove any rows that reference USPS in the configuration and configuration_group tables.

It may be useful to use your browser's "search" function to easily find USPS on the page.

Then, download ses707's copy of the SQL and try running it again.

jackie.taferner:

@sailsport:

Try going into your database and manually remove any rows that reference USPS in the configuration and configuration_group tables.

It may be useful to use your browser's "search" function to easily find USPS on the page.

Then, download ses707's copy of the SQL and try running it again.

Tried that again. Still no luck.
I do have Super Orders installed and I'm thinking that may be the problem?

sailsport1:

Tried that again. Still no luck.
I do have Super Orders installed and I'm thinking that may be the problem?
Nope, issue was the SQL, please download and run this one. This includes SQL updates for 1.3.9 and 1.5.

sailsport1:

Tried that again. Still no luck.
I do have Super Orders installed and I'm thinking that may be the problem?

Try this so you will know what/where mod files are installed.

Step 1 --- Make backups of your database and shopping cart and download to your computer.
Step 2 -- Using Beyond Compare or equal load your shopping cart into Right Side and load the latest version of USPS Click-n-Ship into the Left side.
Step 3 --- Click on "Select all" then "Compare contents" then "Expand all"
Step 4 --- All files should be "=" except maybe the "order.php" if you have FEC installed or other mod that is sharing this file then it will be "Not=". If you see any files that are blue in color (orphan file) that means you do not have it installed in the correct place, so you need to find where you installed that file and remove it. Then install the orphan file.
Step 5 --- Open your Database and scroll down to "configuration_group", look in main body for "configuration_group_id" number for "USPS Auto-Fill Config"
Step 6 --- Click on "configuration" in main body delete all entry's with that "configuration_group_id" number. May be on the last page. After removing all the "usps.sql" entry's go back to "configuration_group"
Step 7 Click on "configuration_group" in main body scroll down to "USPS Auto-Fill Config" and Delete this entry.
Step 8 Upload the Shopping cart back to your server.
Step 9 --- Now install the USPS "install-1.3.9.sql" file.
Now it should work

ses707:

Nope, issue was the SQL, please download and run this one. This includes SQL updates for 1.3.9 and 1.5.

OK That one ran, but it only gives me 9 configuration settings - and there is no USPS autofill button on the orders page anymore.

That patch only had a blank line added different than the one I ran before.

sailsport1:

OK That one ran, but it only gives me 9 configuration settings - and there is no USPS autofill button on the orders page anymore.

That patch only had a blank line added different than the one I ran before.
The key differences are the addition of ; on the last line before the ```
ALTER TABLE orders DROP total_weight;
ALTER TABLE orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';

And the alters lost the '
Can you confirm those items are different in the sql you are running?
And 9 statements is correct for a 1.3.9, only 1.5 requires additional statements.

ses707:

The key differences are the addition of ; on the last line before the ```
ALTER TABLE orders DROP total_weight;
ALTER TABLE orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';

> And the alters lost the '
> Can you confirm those items are different in the sql you are running?
> And 9 statements is correct for a 1.3.9, only 1.5 requires additional statements.

Yes those items are in the code that I have.
I still have no button for autofill though.

@sailsport

You will need to upload the new orders.php file to see the button. If you have Super Orders installed, you will need to merge the changes with your existing file.

Use a program such as winmail.dat to compare and copy over the Auto-fill code to your orders.php file.

jackie.taferner:

@sailsport

You will need to upload the new orders.php file to see the button. If you have Super Orders installed, you will need to merge the changes with your existing file.

Use a program such as winmail.dat to compare and copy over the Auto-fill code to your orders.php file.Not an easy task.. Though the super_orders.php file is BASED on the default orders.php, the differences are still fairly vast and trying to do a file comparison between the two is NOT for the faint of heart.

This and many other reasons is why in the v1.5 compatible version of Super Orders the Super Orders specific mods will be integrated into the default orders.php versus continuing to maintain all those Super Orders "cousin" files (as I call them :laugh:).. That said integration with the v1.3.9 version of Super Order will be a bit of a challenge, but integration with the v1.5 compatible version of Super Orders should present less challenges..

sailsport1:

Yes those items are in the code that I have.
I still have no button for autofill though.
Well that would be the order.php page not in the right spot, not related to install sql. I thought you were missing the settings under configuration. For ZC 1.5 the last update did not include a required file to show settings under configuration (though they are not really needed as the defaults are now much better). In the latest attached version I have also removed the return e-mail as it is now a required part of the usps profile.

No responses on this for a week now, can I assume all bugs have been flushed and this is ready to be finalized and added to the contrib download page?

Everything is working perfectly for me. Again, thank you very much for all of your help!!

There is 1 bug. Special characters are not sent to the USPS page correctly. I ship a lot of overseas packages and any name or address with a non-english letter or accent for example ø ç å ß ˚ œ ¨ will break the USPS page. This used to work on the old AutoFill Button contrib.

spurs2:

There is 1 bug. Special characters are not sent to the USPS page correctly. I ship a lot of overseas packages and any name or address with a non-english letter or accent for example ø ç å ß ˚ œ ¨ will break the USPS page. This used to work on the old AutoFill Button contrib.

That is on the USPS side. Back a few threads I explained what their support said.

Thank you for this fix! You made my wife, who puts her heart into running her small business, very happy.

Wm

I just upgraded my site to 1.5.0

After trying to run the SQL I did not get any menu's

When do I do now?

Milo