Results 1 to 10 of 827

Hybrid View

  1. #1
    Join Date
    Apr 2006
    Location
    Midland TX
    Posts
    428
    Plugin Contributions
    0

    Default Re: usps.com Click-n-ship AutoFill Button Contrib

    Quote Originally Posted by sailsport1 View Post
    The sql patch doesn't work for me. Refreshing doesn't help and I get no configuration settings.
    Here's the error I get:
    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 'ALTER TABLE orders DROP total_weight' at line 1
    in:
    [INSERT INTO configuration VALUES (NULL, 'Return: Tracking Email', 'USPS_RETURN_TRACKING_EMAIL', '', 'Set this to the email address used for receiving tracking updates. ', @gid, '41', now(), now(), NULL, NULL), (NULL, 'Return: Tracking Notify via Email (checkbox)', 'USPS_RETURN_TRACKING_EMAIL_NOTIFY', 'false', 'Set this to true if you want to check the tracking notifications checkbox to receive tracking updates to the email specified.', @gid, '42', now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),"), (NULL, 'Delivery: Default Notify via Email (checkbox)', 'USPS_DELIVERY_DEFAULT_EMAIL_NOTIFY', 'true', 'Set this to true if you want the Notify By Email checkbox checked by default', @gid, '45', now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),"), (NULL, 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '', 'Set this to total or subtotal if you want to use that order value for the declaration value, or set this to a price if you want a default contents value for International shipping, or leave blank to not use it', @gid, '50', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Pounds)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '', 'Set this to the default weight in pounds. Useful if you sell only one type of item. Leave blank if using the order total weight', @gid, '55', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Weight (Ounces)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_OUNCES', '', 'Set this to the default weight in ounces. Useful if you sell only one type of item. Leave blank if using the order total weight', @gid, '60', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Shipping from Same ZipCode (Radio Button)', 'USPS_DELIVERY_SAME_ZIPCODE', 'same', 'Set this to same if you want to have your Return Address Zipcode as the default Ship-From zipcode. If set to Other, then enter in your default Ship-From zipcode in the next setting', @gid, '65', now(), now(), NULL, "zen_cfg_select_option(array('same', 'other'),"), (NULL, 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '', 'Set the default ZipCode you would like as your Ship-From zipcode. Only if the above setting is set to Other', @gid, '70', now(), now(), NULL, NULL), (NULL, 'Delivery: Default Insurance Value', 'USPS_DELIVERY_INSURANCE_VALUE', '', 'Set to total or subtotal if you want to use that order value for the insurance value, or set to a price (i.e. 5.25) if you want to use a preset price. Or leave blank to not use it', @gid, '75', now(), now(), NULL, NULL), ALTER TABLE orders DROP total_weight;]
    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.
    Go to you Data Base and remove USPS from Configure and Configure group.
    Next install the sql file again.

  2. #2
    Join Date
    Apr 2006
    Location
    Midland TX
    Posts
    428
    Plugin Contributions
    0

    Default Re: usps.com Click-n-ship AutoFill Button Contrib

    Shipping International Error

    You will get an "error Return: phone number" when creating a label with Click-n-Ship. This is not an error in the USPS Click-n-Ship Config Mod.

    This is on the USPS side and they are starting today to work on it. Just click on edit and manually enter your phone number.

  3. #3
    Join Date
    Oct 2008
    Posts
    29
    Plugin Contributions
    0

    Default Re: usps.com Click-n-ship AutoFill Button Contrib

    Quote Originally Posted by EZorb View Post
    Go to you Data Base and remove USPS from Configure and Configure group.
    Next install the sql file again.
    Remove which USPS? I tried removing 1 from each that had reference to click-n-ship, but no luck. Same results.

 

 

Similar Threads

  1. v139h Fill the total_weight table without having to click on the USPS click-in-Ship Mod
    By bradlawson25 in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 4 Dec 2013, 06:11 PM
  2. Replies: 1
    Last Post: 11 Jun 2010, 05:46 PM
  3. autoclick usps click-n-ship button missing?
    By fattyfat in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 24 Sep 2009, 02:52 AM
  4. usps.com Click-n-ship AutoFill stopped working?
    By EZorb in forum Addon Shipping Modules
    Replies: 1
    Last Post: 12 Jul 2009, 09:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg