search

nens / threedi-schematisation-editor

QGIS tool for editing schematisations
0 stars 0 forks source link

Sqlite schema version 207 compatibility #55

Closed leendertvanwolfswinkel closed 2 years ago

leendertvanwolfswinkel commented 2 years ago

I migrated a spatialite to 207 (Spatialite 4.3) and tried to open it with the Schematisation Editor.

The error I got is pasted below.

I think with the current migration the views are already included, so no longer any need to make them in the Schematisation Editor?

Er is een fout opgetreden bij het uitvoeren van Python code: 

sqlite3.IntegrityError: NOT NULL constraint failed: views_geometry_columns.read_only 
Traceback (most recent call last):
  File "C:\Users/leendert.vanwolfswin/AppData/Roaming/QGIS/QGIS3\profiles\test 3Di Toolbox 20220602/python/plugins\threedi_schematisation_editor\__init__.py", line 149, in load_from_spatialite
    create_3di_views(src_sqlite)
  File "C:\Users/leendert.vanwolfswin/AppData/Roaming/QGIS/QGIS3\profiles\test 3Di Toolbox 20220602/python/plugins\threedi_schematisation_editor\utils.py", line 697, in create_3di_views
    c.execute(
sqlite3.IntegrityError: NOT NULL constraint failed: views_geometry_columns.read_only

Python versie: 3.9.5 (tags/v3.9.5:0a7dcbd, May  3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] 
QGIS versie: 3.22.3-Białowieża Białowieża, 1628765ec7 

Python pad:
C:/PROGRA~1/QGIS32~1.3/apps/qgis/./python
C:/Users/leendert.vanwolfswin/AppData/Roaming/QGIS/QGIS3\profiles\test 3Di Toolbox 20220602/python
C:/Users/leendert.vanwolfswin/AppData/Roaming/QGIS/QGIS3\profiles\test 3Di Toolbox 20220602/python/plugins
C:/PROGRA~1/QGIS32~1.3/apps/qgis/./python/plugins
C:\Program Files\QGIS 3.22.3\bin\python39.zip
C:\PROGRA~1\QGIS32~1.3\apps\Python39\DLLs
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib
C:\Program Files\QGIS 3.22.3\bin
C:\PROGRA~1\QGIS32~1.3\apps\Python39
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib\site-packages
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib\site-packages\GDAL-3.4.1-py3.9-win-amd64.egg
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib\site-packages\win32
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib\site-packages\win32\lib
C:\PROGRA~1\QGIS32~1.3\apps\Python39\lib\site-packages\Pythonwin
.
C:\Users\leendert.vanwolfswin\AppData\Roaming\QGIS\QGIS3\profiles\test 3Di Toolbox 20220602\python\plugins\threedi_models_and_simulations\deps\PyJWT-1.7.1-py2.py3-none-any.whl
C:\Users\leendert.vanwolfswin\AppData\Roaming\QGIS\QGIS3\profiles\test 3Di Toolbox 20220602\python\plugins\threedi_models_and_simulations\deps\threedi_api_client-4.0.0-py2.py3-none-any.whl