@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).
@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.
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
The key differences are the addition of ; on the last line before theAnd the alters lost the 'Code:ALTER TABLE orders DROP total_weight; ALTER TABLE orders ADD total_weight FLOAT NOT NULL DEFAULT '-1';
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.
Bookmarks