Django 5 related issues

[tcely]

After #765, the Django version jumped from 3.2 to the current latest (5.1). Along with this change, the minimum Python version is now 3.8.

Anyone seeking to add code, to this repository, should skim the link below to see the new features and syntax available from this minimum Python version:

https://docs.python.org/3/whatsnew/3.8.html

So, despite things working for the most part some issues related to the most recent version of Django have been reported:

• CSRF verification failed. Request aborted. #772
• Cant se my upcoming channel updates #781
• Manually refreshing channel gives error #782
• Error on reset-tasks : Data too long for column 'uuid' at row 1 #789

Django CSRF verification failure

The Django 5.1 CSRF verification failure was solved by passing headers for Django to use from nginx and enabling the settings to use those headers. (More details: #786)

MariaDB UUID Support

MariaDB had a specific problem with UUIDField because the column type used by the database tables was changed. This required manual changes to the database tables.

Useful links for more information:

• https://mariadb.com/kb/en/uuid-data-type/
• https://docs.djangoproject.com/en/5.0/releases/5.0/#migrating-uuidfield

[tcely]

MariaDB has a UUID database column type. Django marked that feature as available and switched from using char for UUIDField with a translation as a hex string; to using an untranslated string.

Updating the schema from char to UUID wasn't handled by the software.

Converting the database columns may need to be done manually.

UPDATE: There is now a command to help with this:

python3 /app/manage.py fix-mariadb --uuid-columns --dry-run

Without --dry-run it will execute the SQL statements against your database connection.

ALTER TABLE `sync_media` 
DROP FOREIGN KEY `sync_media_source_id_36827e1d_fk_sync_source_uuid`;

ALTER TABLE `sync_media` 
MODIFY COLUMN `uuid` UUID NOT NULL;

ALTER TABLE `sync_media` 
MODIFY COLUMN `source_id` UUID NOT NULL;

ALTER TABLE `sync_source` 
MODIFY COLUMN `uuid` UUID NOT NULL;

ALTER TABLE `sync_media`
ADD CONSTRAINT `sync_media_source_id_36827e1d_fk_sync_source_uuid`
FOREIGN KEY (`source_id`) REFERENCES `sync_source` (`uuid`);

From: #789 (comment)