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

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

Open
bartdigitalpulse opened this issue Feb 25, 2022 · 0 comments
Open

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

bartdigitalpulse opened this issue Feb 25, 2022 · 0 comments
Assignees
@sjelfull
Labels
enhancement

Comments

@bartdigitalpulse
Copy link

Describe the bug
Some (spammy) userAgents can apparently be longer than 255 characters. This causes a SQL error when writing to the redirect log.

To Reproduce
Steps to reproduce the behavior:

  1. Enable logging
  2. User with userAgent string longer than 255 chars visits site

Expected behavior
Limit the characters to 255 or change column type to text. Would prefer to limit characters.

Screenshots

error.txt

Additional context

  • Craft version: Craft Pro 3.7.29
  • Country Redirect: 2.2.1
@sjelfull sjelfull changed the title String data, right truncated: 1406 Data too long for column 'userAgent' at row 1 String data, right truncated: 1406 Data too long for column 'userAgent' at row 1 May 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sjelfull sjelfull

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@sjelfull @bartdigitalpulse