usps.com Click-n-ship AutoFill Button Contrib

[Varisha]

Webtools is completely separate from click-n-ship. You need a clicknship account

Thanks again qhome :) I got to thinking on my drive to work and thought that be the case I can't wait for my first order that I get to use this new tool on!

[flightoffancy]

I just installed this mod and have a problem. When I click the Auto Fill button it takes me to USPS login page and I login with no problems. After login I get taken to https://sss-web.usps.com/cns/labelInformation.do which is the page asking which destination I want to ship to. In the upper left corner of that page there is an error in bold red that says

Internal Error : We've experienced an unexpected condition.
Error Tracking Number : 1233640623439

The page still loaded even with the error so I chose United States and clicked Go. The next page is where all of the shipping information should be prefilled, well it isn't. My return address is filled in with my click-n-ship account info (not what I have set in my Zen admin) and the delivery address fields are all blank.

I downloaded and installed the newest version from the downloads section and have went through the installation 3 times. All of the files are in the proper places and I renamed the orders.php file so I have no clue what to try next.

Any ideas?

[barco57]

yes in the admin setup page for the mod goto Delivery: Default Weight (Pounds) and set it to a letter instead of a number.
You need to throw an error on the page for it to load correctly. There was a conversation about this farther back in the thread. Some people throw the error in the email but I find it easier to throw the error in the weight since I have to change it anyway.

[flightoffancy]

yes in the admin setup page for the mod goto Delivery: Default Weight (Pounds) and set it to a letter instead of a number.
You need to throw an error on the page for it to load correctly. There was a conversation about this farther back in the thread. Some people throw the error in the email but I find it easier to throw the error in the weight since I have to change it anyway.

Thank you so much! I read back 5 or 6 pages and either missed the discussion or didn't go far enough back. It's working great now, thanks again!

[chriskelm]

I am receiving the following errors on the USERSIDE of my store, making my site unusable!! Please Help!

Like a complete idiot, I did not back up my sql database prior to applying the sql patch. Which what I beleive the problem to be. Is there a uninstall sql patch available?

I am using Zen 1.3.6 on www.bellirosa.com. I am getting the following errors on the store front page:
Warning: Variable passed to each() is not an array or object in /home/####/public_html/store/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/wicked8/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/####/public_html/store/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /home/wicked8/public_html/store/includes/classes/db/mysql/query_factory.php:114) in /home/####/public_html/store/includes/init_includes/init_templates.php on line 78

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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLA
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20090207 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

PLEASE HELP!

[chriskelm]

Wow, I think I fixed it in some adhoc way. I am not even sure how I did it.

I put the store in maintenance mode, ran a SQL database check on it from MySQL, I re-ran the SQL patch from the store admin just incase I missed something when copying and pasting, I took it out of matenance mode... Whalla. WEIRD.

Oddly enough, when I go to the config for the mod, not all the fields are present. Only the first five fields...

wish I could get this to work....

Strange, it worked fine in the admin side but not on the user side.

[qhome]

Wow, I think I fixed it in some adhoc way. I am not even sure how I did it.

I put the store in maintenance mode, ran a SQL database check on it from MySQL, I re-ran the SQL patch from the store admin just incase I missed something when copying and pasting, I took it out of matenance mode... Whalla. WEIRD.

Oddly enough, when I go to the config for the mod, not all the fields are present. Only the first five fields...

wish I could get this to work....

Strange, it worked fine in the admin side but not on the user side.

are you still having a problem with this?