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.

Sign up for GitHub

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

Jump to bottom

Shipping zones Zip Code Condition: Data too long #1138

Closed
rbrv opened this issue Nov 20, 2019 · 1 comment
Closed

Shipping zones Zip Code Condition: Data too long #1138

rbrv opened this issue Nov 20, 2019 · 1 comment

Comments

@rbrv
Copy link

rbrv commented Nov 20, 2019

Description

The length of the Zip Code Condition Formula is limited to varchar(255), triggering an SQL error when adding a longer string:

Database Exception – yii\db\Exception

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

Workaround

Manually alter the column type of commerce_shippingzones.zipCodeConditionFormula to TEXT

Additional info

  • Craft version: 3.3
  • Craft Commerce: 2.2.7
  • Database driver & version: MySQL 5.5.5
@nfourtythree
Copy link
Contributor

Hey @rbrv

Have pushed an update for this it will be included in the next release.

Thanks.

@goraxan goraxan mentioned this issue Apr 1, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@nfourtythree @rbrv