search

3liz / QgisCadastrePlugin

A QGIS plugin which helps users to import the french land registry ('cadastre') data into a database. It is meant to ease the use of the data in QGIS by providing search tools and appropriate layer symbology.
GNU General Public License v2.0
60 stars 41 forks source link

ERREUR : Colonne manquante lors de la création de la table pevlissage #354

Open tevrard opened 2 years ago

tevrard commented 2 years ago

Bonjour,

je rencontre l'erreur suivante lorsque je réalise un import EDIGEO + MAJIC 2021 via une base spatialite:

- Traitement: 
Erreur rencontrée pour la requête: 
-- Traitement: INSERT INTO pevlissage ( pevlissage, annee, ccodep, ccodir, ccocom, invar, dnupev, mlbcom, mlbsyn, mlbcu , mlbdep, mlbts1, mlbts2, mlbtas, mlbgem, mlbtom, tbfpas, mlbtfc, pev, lot ) SELECT DISTINCT REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pevlissage, '2021', SUBSTR(tmp,1,2) AS ccodep, SUBSTR(tmp,3,1) AS ccodir, SUBSTR(tmp,4,3) AS ccocom, SUBSTR(tmp,7,10) AS invar, SUBSTR(tmp,28,3) AS dnupev, CASE WHEN trim(SUBSTR(tmp,36,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,36,11) AS float) END AS mlbcom, CASE WHEN trim(SUBSTR(tmp,48,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,48,11) AS float) END AS mlbsyn, CASE WHEN trim(SUBSTR(tmp,60,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,60,11) AS float) END AS mlbcu, CASE WHEN trim(SUBSTR(tmp,72,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,72,11) AS float) END AS mlbdep, CASE WHEN trim(SUBSTR(tmp,84,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,84,11) AS float) END AS mlbts1, CASE WHEN trim(SUBSTR(tmp,96,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,96,11) AS float) END AS mlbts2, CASE WHEN trim(SUBSTR(tmp,108,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,108,11) AS float) END AS mlbtas, CASE WHEN trim(SUBSTR(tmp,120,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,120,11) AS float) END AS mlbgem, CASE WHEN trim(SUBSTR(tmp,132,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,132,11) AS float) END AS mlbtom, CASE WHEN trim(SUBSTR(tmp,144,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,144,11) AS float) END AS tbfpas, CASE WHEN trim(SUBSTR(tmp,168,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,168,11) AS float) END AS mlbtfc, REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pev, '71' AS lot FROM bati WHERE SUBSTR(tmp,31,2) ='52'
Erreur 
table pevlissage has no column named mlbtfc
FINALISATION

J'imagine que mon paramétrage n'est pas bon mais je ne sais pas identifier ou est mon erreur au vu de ce message. Si quelqu'un peut m'aiguiller...

Merci d'avance ! Thomas

MaelREBOUX commented 1 year ago

Bonjour @tevrard

Pouvez-vous SVP re-tester avec la dernière version 1.15.0 ou la version 1.14.2 ?

Et donner un peu plus de détails sur votre configuration / environnement ?

cdt