[STDM-user] Problems with STDM out of the box

[John Gitau]

Hi Olivier,

Do not use the sql dump, create an empty postgres database and add the postgis extension then reload the plugin, it will automatically create the schema. All the best.

Regards,

John Gitau
Land and GLTN Unit, Urban Legislation, Land and Governance Branch | UN-HABITAT
NOF Block 3 Level 3 South Wing I P.O. Box 30030-00100 Nairobi, Kenya
Tel: + 254 20 762 3032 | +254 (0)722 945 556
Website:www.unhabitat.org | Partners' website:www.gltn.net


-----stdm-user-bounces at lists.osgeo.org wrote: -----
To: stdm-user <stdm-user at lists.osgeo.org>
From: Olivier Dalang 
Sent by: stdm-user-bounces at lists.osgeo.org
Date: 12/18/2014 07:15PM
Subject: [STDM-user] Problems with STDM out of the box

Dear list,

I've trouble using the STDM plugin with default setup.

I run QGIS 2.6.1 and Postgres 9.3. I installed STDM by :
- checking out the stdm-plugin repo (master) in my plugin's directory
- running template_stdm_database.sql in a fresh postgres database (from the stdm-database repo) 

I encountered a small SQL error : 
ERROR:  rule "geometry_columns_delete" for relation "geometry_columns" already exist
Which I solved by adding "OR REPLACE" on the rules creations.

Then, when opening QGIS and logging in the SDTM plugin (using the postgres admin account), I get this message :
Mapper Mapper|Party|party could not assemble any primary key columns for mapped table 'party'

I don't know if it's serious, but then, when I try to add content through the [+] button in Modules>Household, I get an empty form with only "ok" or "cancel". 

Note that I tried to install using the normal install, but had a message "Installation has failed". The error log was empty...
Anyways, I'd rather use my already existing QGIS/PostGIS installations.

Any idea on what's happening ? Is template_stdm_database.sql (from the stdm-database repo) up to date ?

Thanks a lot,

Olivier Dalang
_______________________________________________
STDM-user mailing list
STDM-user at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/stdm-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/stdm-user/attachments/20141219/13e0ebbd/attachment.html>