Hello all,
.. I'm getting this error on the
Order Complete Page when using
Direct Bank Deposit payment method.:
1406 Data too long for column 'shipping_method' at row 1
in:
[INSERT INTO zc1_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 ('2', 'Hoho Hoe', '', '55', 'ggggw Rd', 'Mgggggld', '5144', 'South Australia', 'Australia', '5555555', '
[email protected]', '1', 'Hoho Hoe', '', '55', 'Hilggggw Rd', 'Mgggggd', '5144', 'South Australia', 'Australia', '1', 'Hoho Hoe', '', 'sec 2755', 'Hsseffw Rd', 'Maggggd', '5144', 'South Australia', 'Australia', '1', 'Direct Bank Deposit', 'dirbank', 'AustPost (\"Registered 3 \"days)', 'austpost', '', '', '', '', '', now(), '1', '183.35', '15.445454545455', 'AUD', '1.00000000', '127.0.0.1 - 127.0.0.1')]
(Some of the values changed for security reasons)
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 ?
Bookmarks