[1.6-rc.1] Project import raises 500 error

[jmfrenzel]

Importing an project raises 500 error.

The issue appears to be a bunch of SQL constraint violations like these:

psycopg2.errors.NotNullViolation: null value in column "set_prefix" violates not-null constraint
DETAIL:  Failing row contains (3959, 2021-08-31 15:04:49.027327+00, 2021-08-31 15:39:39.574062+00, 0, 0, lorem ipsum, 3, null, null, 50, , text, , , null).

Steps to reproduce

1. Login into an instance running https://github.com/rdmorganiser/rdmo/releases/tag/1.6-rc.1 , e.g. rdmo.aip.de
2. export a project (new or existing one)
3. import project

Note:

• Importing an project that was exported with an older rdmo version works just fine.
• no error on rdmo with Sqlite3 db.

References

• https://github.com/rdmorganiser/rdmo/releases/tag/1.6-rc.1

Spotted by @hardfalcon, reproduced @jmfrenzel

[jochenklar]

Fixed.