Windows Vista - Error saving project - missing datasource params at qgs file

[luigibr]

I use qgis 0.91 for windows avaliable at www.qgis.org I have a project with 4 postgis layer's. I do some thematic work and save the project. When i was loading that project, a message appers saying that some layer's cannot be found. So I open the project file (*.qgs) and the information about the schema was missing at node datasource (inside maplayer node). To correct the file, i write the information and the project open without problems. So i think the problem is when the QGIS write the information about db connection at project file (qgs file).

---

.....
 <projectlayers layercount="4" >
        <maplayer minScale="1" maxScale="1e+08" scaleBasedVisibilityFlag="0" geometry="Point" type="vector" >
            <id>_public___table_v2___the_geom___sql_20080226164351311</id>
            <datasource>dbname=db host=192.168.0.100 port=5432 user=postgres password='******' table=*here-is-missing-the-squema*"table_v2" (the_geom) sql=</datasource>
            <layername>table_v2</layername>
            <srs>  
............

---

and

---

.....
 <projectlayers layercount="4" >
        <maplayer minScale="1" maxScale="1e+08" scaleBasedVisibilityFlag="0" geometry="Point" type="vector" >
            <id>_public___table_v2___the_geom___sql_20080226164351311</id>
            <datasource>dbname=db host=192.168.0.100 port=5432 user=postgres password='******' table="public"."table_v2" (the_geom) sql=</datasource>
            <layername>table_v2</layername>
            <srs> 
...

---

i put "public". before "table_v2" at table description.

[marcopx]

Replying to luigibr:

I use qgis 0.91 for windows avaliable at www.qgis.org I have a project with 4 postgis layer's. I do some thematic work and save the project. When i was loading that project, a message appers saying that some layer's cannot be found. So I open the project file (*.qgs) and the information about the schema was missing at node datasource (inside maplayer node). To correct the file, i write the information and the project open without problems. So i think the problem is when the QGIS write the information about db connection at project file (qgs file).

---

.....
 <projectlayers layercount="4" >
        <maplayer minScale="1" maxScale="1e+08" scaleBasedVisibilityFlag="0" geometry="Point" type="vector" >
            <id>_public___table_v2___the_geom___sql_20080226164351311</id>
            <datasource>dbname=db host=192.168.0.100 port=5432 user=postgres password='******' table=*here-is-missing-the-squema*"table_v2" (the_geom) sql=</datasource>
            <layername>table_v2</layername>
            <srs>  
............

---

and

---

.....
 <projectlayers layercount="4" >
        <maplayer minScale="1" maxScale="1e+08" scaleBasedVisibilityFlag="0" geometry="Point" type="vector" >
            <id>_public___table_v2___the_geom___sql_20080226164351311</id>
            <datasource>dbname=db host=192.168.0.100 port=5432 user=postgres password='******' table="public"."table_v2" (the_geom) sql=</datasource>
            <layername>table_v2</layername>
            <srs> 
...

---

i put "public". before "table_v2" at table description.

could you please test that bug with 0.11.0? Thanks,

Marco

[luigibr]

Hello Marco,

i have tested QGIS 0.11.0 with one postgis layer, one shp layer and one csv layer and all function without problem. I think the problem is solved.

Very thanks :D

[(none)]

Milestone Version 1.0.0 deleted