Zen Follower
- Join Date:
- Mar 2004
- Location:
- Calgary, Alberta
- Posts:
- 289
- Plugin Contributions:
- 0
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')]
