nginx-proxy-manager icon indicating copy to clipboard operation
nginx-proxy-manager copied to clipboard

ER_DATA_TOO_LONG: Data too long for column 'forward_domain_name' at row 1

Open strickes opened this issue 2 years ago • 3 comments

Checklist

  • Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
    • Yes
  • Are you sure you're not using someone else's docker image?
    • No
  • Have you searched for similar issues (both open and closed)?
    • Yes

Describe the bug I'm using Nginx Proxy Manager as a forwarding service for long domain names. However we got one domain that seems to long for the "forward_domain_name" table :D (the forwarded Domain is 279 Chars long)

app_1 | [4/19/2022] [11:29:35 AM] [Express ] › ⚠ warning insert into `redirection_host` (`advanced_config`, `block_exploits`, `created_on`, `domain_names`, `forward_domain_name`, `forward_http_code`, `forward_scheme`, `hsts_enabled`, `hsts_subdomains`, `http2_support`, `meta`, `modified_on`, `owner_user_id`, `preserve_path`, `ssl_forced`) values ('', false, NOW(), '[\"REDACTED.de\"]', 'VERY_LONGURL.html', 301, '$scheme', false, false, false, '{\"letsencrypt_email\":\"REDACTED.de\",\"letsencrypt_agree\":true,\"dns_challenge\":false}', NOW(), 2, true, false) - ER_DATA_TOO_LONG: Data too long for column 'forward_domain_name' at row 1 

Nginx Proxy Manager Version 2.9.18

To Reproduce Steps to reproduce the behavior:

  1. Go to 'New Redirection Host'
  2. Click on 'Domain Names -> Enter Domain'
  3. Scroll down to 'Forward Domain -> Enter very long URL (e.g. 279 Chars)'
  4. See error (ER_DATA_TOO_LONG: Data too long for column 'forward_domain_name' at row 1 )
  5. Frontend Error: image

Expected behavior creation of the vhost with long forwarding URLs

Screenshots see frontend error

Operating System Ubuntu 20.04

Additional context n/a

strickes avatar Apr 25 '22 16:04 strickes

I noticed it just hang and crash (browser notification: wait or kill) when attempting to input a long name.

prashantsomashekar avatar Apr 26 '22 15:04 prashantsomashekar

any news? Seems like it's an issue with the column (https://stackoverflow.com/questions/18897420/data-too-long-for-column-why)

strickes avatar Jun 20 '22 11:06 strickes

Issue is now considered stale. If you want to keep it open, please comment :+1:

github-actions[bot] avatar Feb 17 '24 01:02 github-actions[bot]