Page 20 of 83 FirstFirst ... 1018192021223070 ... LastLast
Results 191 to 200 of 827
  1. #191
    Join Date
    Feb 2007
    Posts
    64
    Plugin Contributions
    0

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

    Keep up the good work. I still can use it when the order more than 13 ounces. We do have some heavy stuff and it will definitely come in handy.

    Just a note. I've been using filezilla to upload my files and I've been having problems with the files not updating on the server. I had issues with the USPS Click n Ship and also the Paypal Patch. For some reason when I would drag the whole file structure over some of these files weren't being moved. I got both contributions to work yesterday by moving the individual files over. It might just be me, but check the dates of your files on your server to make sure they have changed when you uploaded your files.

    Scott

  2. #192
    Join Date
    Feb 2004
    Posts
    1,774
    Plugin Contributions
    14

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

    Quote Originally Posted by Sbross View Post
    Keep up the good work. I still can use it when the order more than 13 ounces. We do have some heavy stuff and it will definitely come in handy.

    Just a note. I've been using filezilla to upload my files and I've been having problems with the files not updating on the server. I had issues with the USPS Click n Ship and also the Paypal Patch. For some reason when I would drag the whole file structure over some of these files weren't being moved. I got both contributions to work yesterday by moving the individual files over. It might just be me, but check the dates of your files on your server to make sure they have changed when you uploaded your files.

    Scott
    Good tip.
    Also check your ftp client settings. Some of them have a setting to overwrite or leave by default.

  3. #193
    Join Date
    Mar 2007
    Location
    Hatch, NM
    Posts
    23
    Plugin Contributions
    1

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

    I am recieving the following errors when I try to istal this module.

    Parse error: syntax error, unexpected '}' in /home/berridge/public_html/admin/super_orders.php on line 1417

    in super orders and

    Parse error: syntax error, unexpected '}' in /home/berridge/public_html/admin/orders.php on line 882

    I am sure all files are in the correct locations and I have correctly installed the sql patch. What exactly is causing this?

  4. #194
    Join Date
    Aug 2005
    Posts
    112
    Plugin Contributions
    0

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

    i am trying to install this on 1.37 and am getting an error when i try to put in the sql file. You info says if you have a problem to try the other sql file...but there is only 1 in the zip.....Does this contrib still work?

  5. #195
    Join Date
    Feb 2004
    Posts
    1,774
    Plugin Contributions
    14

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

    Quote Originally Posted by mfreund View Post
    i am trying to install this on 1.37 and am getting an error when i try to put in the sql file. You info says if you have a problem to try the other sql file...but there is only 1 in the zip.....Does this contrib still work?
    Contrib works fine. Are you using a prefix in your database?

    If so, edit the sql file and change:
    Code:
    SELECT @gid := configuration_group_id 
    FROM configuration_group where configuration_group_title LIKE '%USPS Auto-Fill Config%';
    to

    Code:
    SELECT @gid := configuration_group_id 
    FROM prefix_configuration_group where configuration_group_title LIKE '%USPS Auto-Fill Config%';

  6. #196
    Join Date
    Aug 2005
    Posts
    112
    Plugin Contributions
    0

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

    hmm not to sound dumb...but not sure how to find it.....usually i delete the prefix but this time i guess i forgot my prefix is zen_



    Not sure how to find field you are talking about in phpmyadmin



    any help is appreciated

  7. #197
    Join Date
    Aug 2005
    Posts
    112
    Plugin Contributions
    0

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

    i keep looking have no idea how to do it


    can you help?

  8. #198
    Join Date
    Aug 2005
    Posts
    112
    Plugin Contributions
    0

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

    here is the error i am getting when i try to import the sql file


    BTW i renamed all the tables so there is nomore prefix...thought that would fix it but no luck....here is the error when i try to put in the sql file


    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 'total' or 'subtotal' if you want to use that order value for the declaration val' at line 1
    in:
    [INSERT INTO configuration VALUES ('', 'Return: Full Name', 'USPS_RETURN_FULLNAME', '', 'Set this to your return address Full Name', @gid, '5', now(), now(), NULL, NULL), ('', 'Return: Company Name', 'USPS_RETURN_COMPANY_NAME', '', 'Set this to your return address Company Name', @gid, '10', now(), now(), NULL, NULL), ('', 'Return: Address 1', 'USPS_RETURN_ADDRESSONE', '', 'Set this to your return address street 1', @gid, '15', now(), now(), NULL, NULL), ('', 'Return: Address 2', 'USPS_RETURN_ADDRESSTWO', '', 'Set this to your return address street 2', @gid, '20', now(), now(), NULL, NULL), ('', 'Return: City', 'USPS_RETURN_CITY', '', 'Set this to your return address city', @gid, '25', now(), now(), NULL, NULL), ('', 'Return: State', 'USPS_RETURN_STATE', '', 'Set this to your return address state. NOTE: THIS MUST BE IN A 2 LETTER ABBREVIATED FORMAT (i.e. AZ, KY, MI)', @gid, '30', now(), now(), NULL, NULL), ('', 'Return: ZipCode', 'USPS_RETURN_ZIPCODE', '', 'Set this to your return address zipcode', @gid, '35', now(), now(), NULL, NULL), ('', 'Return: Phone Number', 'USPS_RETURN_PHONENUMBER', '', 'Set this to your company phone number for International Shipping. (no dashes: 4041234567)', @gid, '40', now(), now(), NULL, NULL), ('', 'Delivery: Default Notify via Email', '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'),"), ('', 'Delivery: Default Contents Value', 'USPS_DELIVERY_DEFAULT_CONTENTS_VALUE', '10.00', '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), ('', 'Delivery: Default Weight (Pounds)', 'USPS_DELIVERY_DEFAULT_WEIGHTS_POUNDS', '1', '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), ('', '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), ('', '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'),"), ('', 'Delivery: Default Shipping from Other ZipCode (If Radio Button set to Other)', 'USPS_DELIVERY_OTHER_ZIPCODE', '00000', '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), ('', '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), ('', 'Delivery: Default Non-Delivery Checkbox (Return-to-Sender)', 'USPS_DELIVERY_DEFAULT_NONDELIVERY', 'Y', 'Set this to Y if you want the checkbox for Return-To-Sender to be checked by default (International Packages Only)', @gid, '80', now(), now(), NULL, "zen_cfg_select_option(array('N', 'Y'),"), ('', 'Delivery: Default Privacy Acknowledge Checkbox', 'USPS_DELIVERY_DEFAULT_ACKNOWLEDGE', 'on', 'Set this to on if you want the Acknowledge checkbox to be checked by default (International Packages Only)', @gid, '85', now(), now(), NULL, "zen_cfg_select_option(array('off', 'on'),");]
    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.

  9. #199
    Join Date
    Aug 2005
    Posts
    112
    Plugin Contributions
    0

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

    Well the removing the prefix helped all the other contribs i was having problems with so i tried a re import of your usps 1.1 sql file through phpmyadmin and i am getting this error


    ALTER TABLE `orders` DROP `total_weight` ;

    MySQL said: Documentation
    #1091 - Can't DROP 'total_weight'; check that column/key exists



    what do you suggest? I would really like to get this working



    thanks


    Matt

  10. #200
    Join Date
    Feb 2004
    Posts
    1,774
    Plugin Contributions
    14

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

    Quote Originally Posted by mfreund View Post
    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 'total' or 'subtotal' if you want to use that order value for the declaration val' at line 1
    OK, this error was supposed to be fixed with 1.1b but apparently I fixed it in one file and uploaded the other. So I've fixed (and i checked 3 times to be sure) and reuploaded the file to the downloads area. It is still 1.1b but it should have a different correction message when they approve it. That will fix the 'total' thing.

    The last error you got is fine. It is just trying to drop a table that doesn't exist.

    Sorry for the confusion.

    For now, try this:
    Last edited by qhome; 9 Apr 2008 at 03:37 AM.

 

 
Page 20 of 83 FirstFirst ... 1018192021223070 ... LastLast

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

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR