Jump to content

jeffreyice1

Members
  • Content count

    5
  • Joined

  • Last visited

2 Followers

Profile Information

  • Real Name
    Jeffrey Ice
  1. jeffreyice1

    USPS Rate V4, Intl Rate V2 (official support thread)

    Jetta, Can you tell me where to remove the extra ' (THAT DOES SOUND LIKE MY PROBLEM)!!! I need to know where to change in files!!
  2. jeffreyice1

    USPS Rate V4, Intl Rate V2 (official support thread)

    Jetta, I have done that and its not solved by the length... Its something in the insert that is not right.. Like an extra ) or ' or some other character that is not right under windows version of 3.2.1... or mysql under windows!
  3. jeffreyice1

    USPS Rate V4, Intl Rate V2 (official support thread)

    Jetta, Any info on my post above? Both Fields are Text. The issue is with Description. That was set to varchar(255) I modified it to varchar(510) and the module installs. BUT THEN You can not edit (Just disapears) an no functionality in products. To me it seems like to much data is being inserted into the description field by mistake and all other fields are now incorrect. Im installed on windows 7 with mysql 5. Could there be an issue in the sql command installing the module? Thanks PS I did a new install and database of 2.3.1 and updated the files for usps on the new install. And same problem
  4. jeffreyice1

    USPS Rate V4, Intl Rate V2 (official support thread)

    Jetta, Both Fields are Text. The issue is with Description. That was set to varchar(255) I modified it to varchar(510) and the module installs. BUT THEN You can not edit (Just disapears) an no functionality in products. To me it seems like to much data is being inserted into the description field by mistake and all other fields are now incorrect. Im installed on windows 7 with mysql 5. Could there be an issue in the sql command installing the module? Thanks PS I did a new install and database of 2.3.1 and updated the files for usps on the new install. And same problem.
  5. jeffreyice1

    USPS Rate V4, Intl Rate V2 (official support thread)

    Help with your Fix!!! I install 2.3.1 about 6 weeks ago and was having issues with international rates. I saw your post and since its a new install I copied the files and ran the script provided. Now I get the following error. Any Ideas on how to correct. Or script to modify configuration_description. I tried manualy through the SQL Manager UI but looks like it does not work... Thanks 1406 - Data too long for column 'configuration_description' at row 1 insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Shipping Methods (Domestic and International)', 'MODULE_SHIPPING_USPS_TYPES', '0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00, 0, 70, 0.00', 'Checkbox: Select the services to be offered Minimum Weight (lbs)first input field Maximum Weight (lbs):second input field USPS returns methods based on cart weights. These settings will allow further control (particularly helpful for flat rate methods) but will not override USPS limits', '6', '0', 'tep_cfg_usps_services(array(\'First-Class MailRM Large Envelope\', \'First-Class MailRM Parcel\', \'Media MailRM\', \'Parcel PostRM\', \'Priority MailRM\', \'Priority MailRM Flat Rate Envelope\', \'Priority MailRM Legal Flat Rate Envelope\', \'Priority MailRM Padded Flat Rate Envelope\', \'Priority MailRM Small Flat Rate Box\', \'Priority MailRM Medium Flat Rate Box\', \'Priority MailRM Large Flat Rate Box\', \'Priority MailRM Regional Rate Box A\', \'Priority MailRM Regional Rate Box B\', \'Priority MailRM Regional Rate Box C\', \'Express MailRM\', \'Express MailRM Flat Rate Envelope\', \'Express MailRM Legal Flat Rate Envelope\', \'Express MailRM Flat Rate Boxes\', \'First-Class MailRM International Large Envelope**\', \'First-Class MailRM International Parcel**\', \'Priority MailRM International\', \'Priority MailRM International Flat Rate Envelope**\', \'Priority MailRM International Small Flat Rate Box\', \'Priority MailRM International Medium Flat Rate Box\', \'Priority MailRM International Large Flat Rate Box\', \'Express MailRM International\', \'Express MailRM International Flat Rate Envelope\', \'Express MailRM International Flat Rate Boxes\', \'USPS GXGTM Envelopes**\', \'Global Express GuaranteedRM (GXG)**\'), ', now()) [TEP STOP]
×