You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
PHP Fatal error: MySQL error 1406: Data too long for column 'address_zip' at row 1 ::
INSERT INTO paypal
(order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo)
VALUES ....
Yes this was a long postcode: 4445-649 ERMESINDE from Portugal.
From Wikipedia for Portugal
".... is formed by four digits, a hyphen, then three digits, followed by a postal location of up to 25 characters in capitals."
Sounds like the "postcode" could be longer than the address!!
Default address_book and paypal postcode fields are 10 characters.
I find that my address_book has long been 34 characters, but I'd never changed the paypal one.
PHP Fatal error: MySQL error 1406: Data too long for column 'address_zip' at row 1 ::
INSERT INTO paypal
(order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo)
VALUES ....
Yes this was a long postcode: 4445-649 ERMESINDE from Portugal.
From Wikipedia for Portugal
".... is formed by four digits, a hyphen, then three digits, followed by a postal location of up to 25 characters in capitals."
Sounds like the "postcode" could be longer than the address!!
Default address_book and paypal postcode fields are 10 characters.
I find that my address_book has long been 34 characters, but I'd never changed the paypal one.
Obviously not a common problem...
https://www.zen-cart.com/showthread.php?186400-How-to-change-the-maximum-length-for-postcode
The text was updated successfully, but these errors were encountered: