# Bug OP-13083 - Seeding in French fails because of database constraint on name length

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-13083

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 13.0.0 |
| Observed in versions |  |
| Sprint | 13.0.0 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  Install a new OpenProject instance using the packaged installer.
2.  On the language selection screen of the installer, choose French.

### What is the buggy behavior?

*   The installation fails during the seeding phase with error `ActiveRecord::ValueTooLong: PG::StringDataRightTruncation: ERROR:  value too long for type character varying(30)`.
    *   The `name` field of the `roles` table is limited to 30 characters. Text "Personnel et gestionnaire de projets" (French for "Staff and projects manager") is exceeding this limit.
    *   This bug was only half-fixed in [https://github.com/opf/openproject/commit/fb6c2964288ef4bcdd9a49ef028f254b8a336bc5](https://github.com/opf/openproject/commit/fb6c2964288ef4bcdd9a49ef028f254b8a336bc5) as it changed the model validation limits but did not change the database constraint limits.
    *   There may be other occurences where the model limits and the db limits are out-of-sync. They should be checked.

### What is the expected behavior?

1.  It should install flawlessly in any languages

### Environment information

**OpenProject installation type**

*   [ ] Hosted cloud edition
*   [ ] Packaged installation
    *   What distribution?
*   [ ] Docker All-in-one container
*   [ ] Docker-compose installation
*   [x] Other (please specify)
    *   [x] pre-13.0 from this pull request [https://github.com/opf/openproject/pull/13387](https://github.com/opf/openproject/pull/13387) where the role names are correctly translated.