SRS error for new SpatiaLite layer in old SL DBs

[qgib]

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 5486
Affected QGIS version: master
Redmine category:data_provider
Assignee: Giuseppe Sucameli

---

When creating a new Spatialite vector, selecting a SRS results in an error:

Impossible to load SRIDS: no such table: spatial_ref_sys

No problem with shp. Master from yesterday.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

This should affect also the code frozen for the 1.8 release, so I'll tag this as blocker as is a regression.

---

• priority_id was changed from Normal to Severe/Regression

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Is the real message "Failed to load SRIDS"?

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

Yes, it was my dummy backtranslation from the IT GUI.The real message is:

Failed to load SRIDS: no such table: spatial_ref_sys

as you guessed.
Sorry.

[qgib]

Author Name: Marco Hugentobler (@mhugent)

---

I can create a new spatialite layer without SRS problem (master branch from today). Is the ticket still valid?

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

Just checked, with today's master, same error.
Self packaged on Debian testing with master debian/rules

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

works fine on ubuntu 11.04 and qgis master from the nightly build repo.

[qgib]

Author Name: Salvatore Larosa (@slarosa)

---

same here on Debian/wheezy and QGIS master (173e9ad), everything works fine!

[qgib]

Author Name: Marco Hugentobler (@mhugent)

---

Looks like a package problem to me then.

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

It was not due to compilation, but to a change in SL provider, I think: spatial_ref_sys of old SL db are not recognized. This could be a bug in itself.

---

• subject was changed from SRS error for new SpatiaLite layer to SRS error for new SpatiaLite layer in old SL DBs
• assigned_to_id was configured as Giuseppe Sucameli
• status_id was changed from Closed to Reopened
• category_id was changed from Projection Support to Data Provider

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

• priority_id was changed from Severe/Regression to Normal

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Unable to reproduce it. Probably the problem depends on the used database (old or what?).
Could you provide a small dataset to reproduce it?

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

See subject and comment #9: yes, this is due to old DBs

[qgib]

Author Name: Giuseppe Sucameli (@brushtyler)

---

Probably that db has no spatial_ref_sys table and then it's an invalid SL database.

---

• resolution was changed from to invalid
• status_id was changed from Reopened to Closed