[Qgis-user] QGIS 2.10.1 not loading PostGIS Data displayed in earlier Versions

[Gunnar Oehmichen]

Hello there,

We are using QGIS 2.10.1 on Ubuntu 14.04 with a PostgreSQl 9.1, PostGIS
2.0 Database ("POSTGIS="2.0.2 r10789" GEOS="3.4.2-CAPI-1.8.2 r3921"
PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER").

After upgrading to QGIS 2.10. several of our .qgs projects using PostGIS
tables and joins don't display all or only a part of the included layers.

Projects were build in QGIS 2.4.0

One projects consists of two layers:

A Multipolygon Layer based on a PostGIS table without further sql. This
layer is displayed properly.

A second layer is not displayed. This is based on a Multipoint table
joined with a non geometric table. Tables were joined to display the
information of the non geometric table in diagramms.

part of the .qgs for the join:

            <vectorjoins>
                <join joinFieldName="gem_schl"
targetFieldName="gem_schl" memoryCache="1"
joinLayerId="basis_energie20141031105805636"/>
            </vectorjoins>

The PostGIS Log gives several Errors repeated for each row in the joined
non geometric table (sorry for the german messages. QGIS' language is
set to english but installed on a german system):

2015-09-22T18:28:15	1	Query: DECLARE qgis_3 BINARY CURSOR FOR SELECT
"id","stromverb2"::text,"heizw_rmev"::text,"stromverb3"::text,"w_rmeverbr"::text,"energiever"::text,"gesamtener"::text
FROM "planee_neu"."basis_energie" WHERE (("gem_schl"=7313002) AND
st_srid("")=-2147483648) returned 7 [FEHLER:  Bezeichner in
Anführungszeichen hat Länge null bei »""«
			LINE 1: ..._energie" WHERE (("gem_schl"=7313002) AND
st_srid("")=-21474...
			                                                             ^
			]
2015-09-22T18:28:15	1	1 cursor states lost.
			SQL: DECLARE qgis_3 BINARY CURSOR FOR SELECT
"id","stromverb2"::text,"heizw_rmev"::text,"stromverb3"::text,"w_rmeverbr"::text,"energiever"::text,"gesamtener"::text
FROM "planee_neu"."basis_energie" WHERE (("gem_schl"=7313002) AND
st_srid("")=-2147483648)
			Result: 7 (FEHLER:  Bezeichner in Anführungszeichen hat Länge null
bei »""«
			LINE 1: ..._energie" WHERE (("gem_schl"=7313002) AND
st_srid("")=-21474...
			                                                             ^
			)

Is there any possibility to "save" the project files for proper display
in 2.10.1 or must they be created from start?

Btw are you recommending the use of 2.10.1 on Ubuntu 14.04?

Thank you very much,
-- 
Gunnar Oehmichen
Quantitative Landscape Ecology
Institute for Environmental Sciences
University Koblenz-Landau
Fortstrasse 7
76829 Landau

http://www.uni-koblenz-landau.de/campus-landau/faculty7/environmental-sciences/landscape-ecology/Staff/gunnaroehmichen