fresh project runs into `ERROR: value too long for type character varying(50)` about cookiecutter-django HOT 3 CLOSED

It fails to create a row in one table, because one CharField value is too long for the column in the database.

You haven't shared a lot of logs, so we don't see which migration fails. However, since you're claiming that it's a fresh project and that the size of the column is 50, I bet it's failing on sites.0003_set_site_domain_and_name, which creates the site into the DB table from Django's sites framework:

The name is 50 char long:

Did you redact the value of your project name by any chance? Is the actual value longer than 50 char? If that's the case, I suggest you to edit the name of the site in your migration sites.0003_set_site_domain_and_name. AFAIK, it's just an internal alias for you project name within the admin, it doesn't affect what the users will see. Let me know it it fixes your issue.

As for a fix to the template itself, we could limit the length of the value in the migration:

def update_site_forward(apps, schema_editor):
    """Set site domain and name."""
    Site = apps.get_model("sites", "Site")
    _update_or_create_site_with_sequence(
        Site,
        schema_editor.connection,
        "{{cookiecutter.domain_name}}",
-       "{{cookiecutter.project_name}}",
+       "{{cookiecutter.project_name[:50]}}",
    )

from cookiecutter-django.

alright, just a quick update. I've created another project with the same settings but a different project name (shorter).

The above error is gone and I have 26 passing tests.

I'll investigate it further later today or tomorrow to make sure it was related to the length of the project name, just FYI the exception was thrown on multiple occasions including your suspected sites app.

so far, thx for the response.

from cookiecutter-django.

now I've recreated the project with exactly the same inputs as yesterday but I couldn't reproduce the issue. so whatever it was, it was fixed by one of the last commits in between my try yesterday and today.

since I'm not able anymore to reproduce I'll just close this issue.

from cookiecutter-django.