Migration-Error on installing the project

[wfehr]

Error occured when trying to install the project with cms-4.1 and django-4.2 (see #256).

Also with django-4.1 this installation doesn't work.

Part of the trace:

File "/usr/local/lib/python3.11/site-packages/django/db/models/fields/init.py", line 925, in get_db_prep_save
return self.get_db_prep_value(value, connection=connection, prepared=False)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/django/db/models/fields/init.py", line 2704, in get_db_prep_value
value = connection.ops.validate_autopk_value(value)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/django/db/backends/mysql/operations.py", line 250, in validate_autopk_value
raise ValueError(
ValueError: The database backend does not accept 0 as a value for AutoField.

Relevant migration: djangocms_moderation.0003_auto_20180903_1206
There, a one-off-default of 0 for a new ForeignKey was set.

[wfehr]

The used database was mysql 8.0.31.

[fsbraun]

@wfehr Would you be interested to test #259 ?

[wfehr]

@wfehr Would you be interested to test #259 ?

Was hard to try out with my local setup and moderation currently not supporting django 4.2.
Installations with cms=4.0.1.x and trying django 4.0+ didn't work either.

But I installed it with the following:

• code from feat: Django 4.2 support #256
• migrations from fix: Squash migrations to remove intermediate state with auto field = 0 #259

-> Worked and migrations ran successfully!

[fsbraun]

Great! Thanks for the effort and the feedback!