Erreur d'accès à la Variable sql

[CPFPaul]

Description du bug

Bonjour, j'utilise le plugin cadastre pour le boulot et je rencontre un problème avec les ordinateurs portable du travail. J'utilise le plugin depuis mon ordinateur personnel qui est plus puissant et tout fonctionne. Lorsque j'essaye avec mon ordinateur portable du travail ou ceux des autres technicien un message d'erreur apparait.

Je tiens à préciser que entre mon ordinateur personnel et ceux professionnel il n'y a pas de différence de version QGis ou de données sources (données du cadastre).

Reproduire le bug

1. Ouvrir la fentre d'import de données et remplir les champs nécessaires à l'import
2. Lancer l'import...

Log

Veuillez sélectionner le chemin vers les fichiers à importer !
Le chemin spécifié pour les fichiers EDIGEO n'existe pas
Le chemin spécifié pour les fichiers MAJIC n'existe pas


INITIALISATION
* Copie du répertoire C:\Users\Christophe\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\cadastre\scripts/plugin 
0 s 
STRUCTURATION BDD
Création des tables 
Création des tables edigeo 
Erreur rencontrée pour la requête: 
-- Creation des tables EDIGEO CREATE TABLE batiment_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, dur character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('batiment_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE borne_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('borne_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE boulon_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, ori double precision, creat_date integer, update_date integer ); SELECT AddGeometryColumn('boulon_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE commune_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, idu character varying, tex2 character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('commune_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE croix_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('croix_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE id_s_obj_z_1_2_2 ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, fon character varying, hei double precision, tyu character varying, cef double precision, csp double precision, di1 double precision, di2 double precision, di3 double precision, di4 double precision, tpa character varying, hta character varying, vta character varying, atr character varying, ogr_obj_lnk character varying, ogr_obj_lnk_layer character varying, ogr_atr_val character varying, ogr_angle double precision, ogr_font_size double precision ); SELECT AddGeometryColumn('id_s_obj_z_1_2_2', 'geom', RGF93LAMB93, 'POINT', 2); CREATE TABLE lieudit_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex10 character varying, tex2 character varying, tex3 character varying, tex4 character varying, tex5 character varying, tex6 character varying, tex7 character varying, tex8 character varying, tex9 character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('lieudit_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE numvoie_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('numvoie_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE parcelle_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, coar character varying, codm character varying, idu character varying, indp character varying, supf double precision, tex2 character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('parcelle_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE ptcanv_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, can character varying, idu character varying, map character varying, palt character varying, ppln character varying, sym character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('ptcanv_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE section_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, idu character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('section_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE subdfisc_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('subdfisc_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE subdsect_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, copl character varying, dedi character varying, dis character varying, dred character varying, eor character varying, icl double precision, idu character varying, inp character varying, qupl character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('subdsect_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE symblim_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, ori double precision, sym character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('symblim_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE tline_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, sym character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('tline_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE tpoint_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, ori double precision, sym character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('tpoint_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE tronfluv_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex10 character varying, tex2 character varying, tex3 character varying, tex4 character varying, tex5 character varying, tex6 character varying, tex7 character varying, tex8 character varying, tex9 character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('tronfluv_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE tronroute_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, rcad character varying, tex10 character varying, tex2 character varying, tex3 character varying, tex4 character varying, tex5 character varying, tex6 character varying, tex7 character varying, tex8 character varying, tex9 character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('tronroute_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE tsurf_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, sym character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('tsurf_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE voiep_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('voiep_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); CREATE TABLE zoncommuni_id ( ogc_fid INTEGER PRIMARY KEY AUTOINCREMENT, object_rid character varying, tex10 character varying, tex2 character varying, tex3 character varying, tex4 character varying, tex5 character varying, tex6 character varying, tex7 character varying, tex8 character varying, tex9 character varying, tex character varying, creat_date integer, update_date integer ); SELECT AddGeometryColumn('zoncommuni_id', 'geom', RGF93LAMB93, 'GEOMETRY', 2); 
Erreur 
no such column: RGF93LAMB93
MAJIC
FINALISATION

INITIALISATION
* Copie du répertoire C:\Users\Christophe\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\cadastre\scripts/plugin 
0 s 
MAJIC
Suppression des contraintes 
0 s 
- SUPPRESSION DES CONTRAINTES D'INTEGRITEES : DEBUT 
0 s 
- suppression clefs primaires 
0 s 
Suppression des indexes 
0 s 
Import des fichiers majic 
E:/Cadastre NOMS/majic/131/13096\bati.txt 
E:/Cadastre NOMS/majic/131/13096\fan.txt 
E:/Cadastre NOMS/majic/131/13096\lloc.txt 
E:/Cadastre NOMS/majic/131/13096\nbat.txt 
E:/Cadastre NOMS/majic/131/13096\pdll.txt 
E:/Cadastre NOMS/majic/131/13096\prop.txt 
5 s 
Mise en forme des données 
5 s 
- FORMATAGE DONNEES : DEBUT 
5 s 
- Traitement: parcelle 
5 s 
- Traitement: suf 
6 s 
- Traitement: sufexoneration 
6 s 
- Traitement: suftaxation 
6 s 
- Traitement: local00 
6 s 
- Traitement: local10 
6 s 
- Traitement: pev 
6 s 
- Traitement: pevexoneration 
6 s 
- Traitement: pevexoneration_imposable 
6 s 
- Traitement: pevexoneration_imposee 
6 s 
- Traitement: pevtaxation 
6 s 
- Traitement: pevprincipale 
6 s 
- Traitement: pevprofessionnelle 
6 s 
- Traitement: 
6 s 
- Traitement: pevdependances 
6 s 
- Traitement: commune_majic 
6 s 
- Traitement: proprietaire 
7 s 
- création: comptecommunal à partir de proprietaire 
7 s 
- Traitement: pdl 
7 s 
- Traitement: parcellecomposante 
7 s 
- Traitement: lots 
7 s 
- Traitement: lotslocaux 
7 s 
- Traitement: commune 
7 s 
- Traitement: voie 
7 s 
- purge des doublons : voie 
7 s 
- INDEXES 
7 s 
- ANALYSES 
7 s 
- FORMATAGE DONNEES : FIN 
7 s 
Purge des données brutes 
7 s 
EDIGEO
Type de base : spatialite, Connexion: Christophe'.sqlite, Schéma: 
* Décompression des fichiers 
* Recherche des fichiers .bz2 
95 fichier(s) .bz2 dans E:/Cadastre NOMS/pci/131/13096 
95 fichier(s) .bz2 dans C:\Users\CHRIST~1\AppData\Local\Temp\cad_edigeo_plain_ga40m6j3 
13 s 
Suppression des contraintes 
13 s 
- SUPPRESSION DES CONTRAINTES D'INTEGRITEES : DEBUT 
13 s 
- suppression clefs primaires 
13 s 
* Import des fichiers EDIGEO dans la base 
- Import des fichiers via ogr2ogr 
- Import des relations (*.vec) 

Recopier ci-dessous l'erreur Python de QGIS

Une erreur est survenue lors de l'exécution du code Python : 

UnboundLocalError: cannot access local variable 'sql' where it is not associated with a value 
Traceback (most recent call last):
  File "C:\Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\cadastre\cadastre_import.py", line 1509, in importEdigeoVecToDatabase
    c.executemany(query, [(item[0], item[1], item[2]) for item in l])
sqlite3.OperationalError: no such table: edigeo_rel

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\cadastre\dialogs\import_dialog.py", line 327, in processImport
    qi.importEdigeo()
  File "C:\Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\cadastre\cadastre_import.py", line 713, in importEdigeo
    self.importAllEdigeoToDatabase()
  File "C:\Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\cadastre\cadastre_import.py", line 1356, in importAllEdigeoToDatabase
    self.importEdigeoVecToDatabase(vec)
  File "C:\Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\cadastre\cadastre_import.py", line 1512, in importEdigeoVecToDatabase
    self.qc.updateLog('Erreurs pendant la requête : %s' % sql)
                                                                 ^^^
UnboundLocalError: cannot access local variable 'sql' where it is not associated with a value


Version de Python : 3.12.7 (main, Oct 25 2024, 11:18:09) [MSC v.1938 64 bit (AMD64)] 
Version de QGIS : 3.34.13-Prizren Prizren, 222b5995 

Chemin Python :
C:/PROGRA~1/QGIS33~1.13/apps/qgis-ltr/./python
C:/Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python
C:/Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins
C:/PROGRA~1/QGIS33~1.13/apps/qgis-ltr/./python/plugins
C:\PROGRA~1\QGIS33~1.13\apps\grass\grass84\etc\python
C:\Users\Christophe\Documents
C:\Program Files\QGIS 3.34.13\bin\python312.zip
C:\PROGRA~1\QGIS33~1.13\apps\Python312\DLLs
C:\PROGRA~1\QGIS33~1.13\apps\Python312\Lib
C:\Program Files\QGIS 3.34.13\bin
C:\PROGRA~1\QGIS33~1.13\apps\Python312
C:\PROGRA~1\QGIS33~1.13\apps\Python312\Lib\site-packages
C:\PROGRA~1\QGIS33~1.13\apps\Python312\Lib\site-packages\win32
C:\PROGRA~1\QGIS33~1.13\apps\Python312\Lib\site-packages\win32\lib
C:\PROGRA~1\QGIS33~1.13\apps\Python312\Lib\site-packages\Pythonwin
C:/Users/Christophe/AppData/Roaming/QGIS/QGIS3\profiles\default/python

Environnement

• OS: Windows 11 Pro
• Version de QGIS : 3.34.13
• Version du plugin : 1.20.0