{"action":"created","issue":{"url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/6","labels_url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/6/comments","events_url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/6/events","html_url":"https://github.com/Oslandia/qgis-versioning/issues/6","id":56818480,"number":6,"title":"qgis 2.6 & spatialite","user":{"login":"andrei4002","id":475334,"avatar_url":"https://avatars.githubusercontent.com/u/475334?v=3","gravatar_id":"","url":"https://api.github.com/users/andrei4002","html_url":"https://github.com/andrei4002","followers_url":"https://api.github.com/users/andrei4002/followers","following_url":"https://api.github.com/users/andrei4002/following{/other_user}","gists_url":"https://api.github.com/users/andrei4002/gists{/gist_id}","starred_url":"https://api.github.com/users/andrei4002/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrei4002/subscriptions","organizations_url":"https://api.github.com/users/andrei4002/orgs","repos_url":"https://api.github.com/users/andrei4002/repos","events_url":"https://api.github.com/users/andrei4002/events{/privacy}","received_events_url":"https://api.github.com/users/andrei4002/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-02-06T14:34:25Z","updated_at":"2015-08-02T00:48:51Z","closed_at":null,"body":"I'm trying to do a checkout operation in a sqlite store, but it gives me some weird error \"insert on views_geometry_columns violates constraint: f_geometry_column value must be lower case\" \r\n\r\nis it a spatialite issue? any ideas on this?"},"comment":{"url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/comments/126967852","html_url":"https://github.com/Oslandia/qgis-versioning/issues/6#issuecomment-126967852","issue_url":"https://api.github.com/repos/Oslandia/qgis-versioning/issues/6","id":126967852,"user":{"login":"gignacnic","id":5321940,"avatar_url":"https://avatars.githubusercontent.com/u/5321940?v=3","gravatar_id":"","url":"https://api.github.com/users/gignacnic","html_url":"https://github.com/gignacnic","followers_url":"https://api.github.com/users/gignacnic/followers","following_url":"https://api.github.com/users/gignacnic/following{/other_user}","gists_url":"https://api.github.com/users/gignacnic/gists{/gist_id}","starred_url":"https://api.github.com/users/gignacnic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gignacnic/subscriptions","organizations_url":"https://api.github.com/users/gignacnic/orgs","repos_url":"https://api.github.com/users/gignacnic/repos","events_url":"https://api.github.com/users/gignacnic/events{/privacy}","received_events_url":"https://api.github.com/users/gignacnic/received_events","type":"User","site_admin":false},"created_at":"2015-08-02T00:48:51Z","updated_at":"2015-08-02T00:48:51Z","body":"@vmora : we found the problem it was not ogr2ogr problem, but a change I made at line 711:  geom = sql.find('geometry') != -1 that was not appropriate, which did not create the INSERT in the metadata geometry_columns in spatialite as suppose, just before the ogr2ogr command to PG. A PR has been to include fix for spatiality 4.x version include in the latest QGIS 2.8 version: https://github.com/Oslandia/qgis-versioning/pull/10"}}