Bug report #12785
Adding spatialite layer to project data gets corrupted(?)
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider/SpatiaLite | ||
| Affected QGIS version: | master | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 20884 |
Description
New description:
--------------
Take the attached SL database, examine the "test" table with DB Manager, it has a "Identifiant_EVV" integer column with positive values. Add the layer to QGIS project (with DB manager, the Add SL layer dialog, QGIS browser or else) and the table of attributes will show different (negative) values.
--------------
Old Description:
importing data into Qsartialite with the "load in QGIS" converts some data
Related issues
Associated revisions
spatialite provider: load 64bit integers (fixes #12785)
spatialite provider: load 64bit integers (fixes #12785)
(cherry picked from commit b736317005c2417ffc037bbc3969a2b180c49dd7)
History
#1
Updated by Saber Razmjooei over 9 years ago
Something wrong with your table. Here is ogrinfo output:ERROR 1: Unable to query table draaf082014 for column definitions : no such table: draaf082014.
ERROR 1: Unable to query table parcelle for column definitions : no such table:parcelle.
ERROR 1: Unable to query table draaf for column definitions : no such table: draaf.
#2
Updated by gontran casella over 9 years ago
this is not the troubleshooting, data (1 GB). This is an extraction(mydraaf.sqlite).
The problem is that the information in the database are transformed when asked display in QGIS.
#3
Updated by Saber Razmjooei over 9 years ago
- Category changed from C++ Plugins to Data Provider
#4
Updated by Saber Razmjooei over 9 years ago
- Target version changed from Future Release - High Priority to Future Release - Lower Priority
- Operating System changed from w to Windows
Could you copy some of the error messages you get from QGIS log message.
Also could you run ogrinfo on the master file and post the output here.
#5
Updated by gontran casella over 9 years ago
- File test_qgis.bmp added
this is not an error but rather a data transformation
#6
Updated by Saber Razmjooei over 9 years ago
- Status changed from Open to Feedback
Are you sure the CRS is set correctly?
#7
Updated by gontran casella over 9 years ago
the plots are good, that is the data paths (identifiant_EVV) is false
#8
Updated by Giovanni Manghi over 9 years ago
isn't this about a 3rd party plugin?
#9
Updated by gontran casella over 9 years ago
The same problem arises when inserting a layer qspartialite
#10
Updated by Giovanni Manghi over 9 years ago
gontran casella wrote:
The same problem arises when inserting a layer qspartialite
if the issue is about the "qspatialite" plugin it should be moved here
https://github.com/romain974/qspatialite/issues
please confirm.
#11
Updated by gontran casella over 9 years ago
can be, but this happens on own base QSLITE I carry directly with the function add a layer startialite
#12
Updated by gontran casella over 9 years ago
a question:
My problem you play on your computer or server?
#13
Updated by Giovanni Manghi over 9 years ago
- Category changed from Data Provider to Data Provider/SpatiaLite
- Status changed from Feedback to Open
- Operating System deleted (
Windows) - Affected QGIS version changed from 2.8.2 to master
- OS version deleted (
7) - Subject changed from qspatialite import data to qgis to Adding spatialite layer to project data gets corrupted(?)
#14
Updated by gontran casella over 9 years ago
all versions are affected
#15
Updated by Jürgen Fischer over 9 years ago
- Status changed from Open to Closed
Fixed in changeset b736317005c2417ffc037bbc3969a2b180c49dd7.