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

[Gunnar Oehmichen]

Heres a link to the project file:

https://app.box.com/s/fqn5xja5r6bmw6frpybv31leovdelo9a

Thanks,

Gunnar
> 
> 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,
>