id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35387	Django's Spatialite backend throws errors with Spatialite 5.0.1	Nikolas N	nobody	"Spatialite 5.0.1 contains a bug which causes the `SELECT InitSpatialMetaDataFull(1)` statement called by django's database wrapper to fail with the error:
{{{
django.db.utils.OperationalError: error in trigger ISO_metadata_reference_row_id_value_insert: no such column: rowid
}}}

Although this is primarily a bug in Spatialite, it is expected for Django to be compatible with this version of Spatialite, as it is shipping in many current distributions, and upgrading to Spatialite 5.1 is not always straightforward.

There is a patch for this issue here: https://github.com/django/django/pull/18083

I was told patches aren't accepted for closed tickets (https://code.djangoproject.com/ticket/32935), so I am opening this new ticket, as the core issue here with Django + Spatialite 5.0.1 remains unresolved."	Bug	closed	Database layer (models, ORM)	5.0	Normal	duplicate	spatialite		Unreviewed	1	0	0	0	0	0