Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Calgary, Alberta
    Posts
    290
    Plugin Contributions
    1

    Default error on using shipping methhod: to be calc'd later

    When selected this causes the following error to occur. I have edited the data to make it more generic

    1406 Data too long for column 'shipping_method' at row 1
    in:
    [INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('11', 'Ww', '', '111', '', 'Calgary', 'H0H 0H0', 'Alberta', 'Canada', '403-000-0000', '[email protected]', '1', 'Wr', '', '111', '', 'Calgary', 'T2A 0W5', 'Alberta', 'Canada', '1', 'Wa', '', '111', '', 'Calgary', 'TTT TTT', 'Alberta', 'Canada', '1', 'Check/Money Order', 'moneyorder', 'Shipping to be Calculated Later (Shipping Calculated Later - please describe choice (post, express, courier (Fed-ex, DHL, UPS) or truck))', 'manualcalcshipping', '', '', '', '', '', now(), '1', '355.01', '19.81', 'CAD', '1.00000000', '68.146.241.17 - 68.146.241.17')]

  2. #2
    Join Date
    Jan 2009
    Location
    Macclesfield, South Australia
    Posts
    102
    Plugin Contributions
    0

    Default Re: error on using shipping methhod: to be calc'd later

    Right, well this is an old post but Im having the same problem.
    Same error on the Order Complete Page but only when using Direct Bank Deposit payment method.
    Apparently its something to do with shipping_method varchar(128)

    How and where do I change this setting and what value should it be set to ?

 

 

Similar Threads

  1. conditional based attributes to calc shipping?
    By shewhorn in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 16 Feb 2010, 03:18 AM
  2. Using phpBB now or later
    By rbarnold in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 24 Aug 2008, 05:37 AM
  3. DHL shipping calc error for "next afternoon"
    By wynnesome in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 21 May 2007, 05:17 AM
  4. urgent - live store with sudden problem calc shipping
    By ginginca in forum General Questions
    Replies: 12
    Last Post: 23 Mar 2007, 12:30 AM
  5. Replies: 2
    Last Post: 13 Aug 2006, 11:46 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