Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

String data, right truncated: 1406 Data too long for column 'description' at row 1 #5

Closed
klemenb opened this issue Aug 25, 2020 · 0 comments
Labels
bug Something isn't working

Comments

@klemenb
Copy link

klemenb commented Aug 25, 2020

Description

PDOException gets triggered because of too long TaxJar category descriptions:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1

description column on the craft_commerce_taxcategories table is defined as VARCHAR(255) and some descriptions are too long:

An over-the-counter drug is a substance that contains a label identifying it as a drug and including a "drug facts" panel or a statement of active ingredients, that can be obtained without a prescription. A drug can be intended for internal (ingestible, implant, injectable) or external (topical) application to the human body.

Steps to reproduce

  1. Go to "Commerce" -> "Tax" in the admin panel
  2. Click "Sync TaxJar Categories"

Additional info

  • Craft version: 3.5
  • PHP version: 7.4
  • Plugins & versions: Craft Commerce 3.2
@klemenb klemenb added the bug Something isn't working label Aug 25, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant