warning: insert into `certificate` (...) - ER_DATA_TOO_LONG: Data too long for column 'nice_name' at row 1

[marrobHD]

Describe the bug

Occurs when too much Domain Names are configured in Proxy host and trying to create ssl cert.

Nginx Proxy Manager Version

v2.9.18

To Reproduce Steps to reproduce the behavior:

1. Create proxy host with 13 domains
2. Create new SSL certificate
3. See error in logs

Expected behavior Should insert fine in database.

Additional context

app_1  | [5/14/2022] [11:46:00 PM] [Express  ] › ⚠  warning   insert into `certificate` (`created_on`, `domain_names`, `expires_on`, `meta`, `modified_on`, `nice_name`, `owner_user_id`, `provider`) values (NOW(), '[\"DOMAINS Removed\"]', NOW(), '{\"letsencrypt_agree\":true,\"dns_challenge\":false,\"nginx_online\":true,\"nginx_err\":null,\"letsencrypt_email\":\"MAIL REMOVED\"}', NOW(), 'DOMAINS REMOVED', 1, 'letsencrypt') - ER_DATA_TOO_LONG: Data too long for column 'nice_name' at row 1

[nicoleonwien]

Is there any chance to get this fixed?

[Shocktrooper]

I just got this as well. I created a valid http redirect but when I tried to create a cert it complained.

[github-actions[bot]]

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

[Shocktrooper]

👍