Re: [pmapper-users] DB error :Unknown error, in digitize points plugin

[Armin B. <arm...@gm...>]

I don't know the plugin, but looking at the code the only part that 
could spit out this error is line 61 in digitizepoints.php.

try to substitute the line

if (DB::isError($db)) die ($db->getMessage());
with
if (DB::isError($db)) die ($db->getDebugInfo());

and check the error message, probably is sort of wrong connection 
string, user/password, port, server, etc

It's generally recommended not to use the getMessage() function since it 
reports most of the time not enough details for debugging.

armin

On 26/05/2010 16:15, Daniel Mwaura wrote:
>
> Hello everyone i am trying to work on a pmaaper application and i want to utilize the digitize points plugin
>
> I have installed pear DB but when i click on the layer to digitize onthe map the pop uot windows comes out fine but with an error>>>>>DB error :Unknown error.
>
> I have tried checking to see if the connection is ok and it is and i am able to use the suggest and options to layers.
>
> Has any one got some help for me i am really stuck because i dont know where the prob could be.
>
> mapfile section
> LAYER
>      NAME 'school'
>      TYPE POINT
>      EXTENT 37.024848 -2.003234 55.376815 12.326384
>      CONNECTIONTYPE postgis
>      CONNECTION "dbname=SEEDS host=localhost port=5432 user=postgres password='everything'"
>      DATA 'the_geom FROM school'
>      METADATA
>        'ows_title' 'school'
>      END
>      STATUS OFF
>      TRANSPARENCY 100
>      PROJECTION
>      'proj=longlat'
>      'ellps=WGS84'
>      'datum=WGS84'
>      'no_defs'
>      END
>      CLASSITEM 'region_code'
>      CLASS
>        NAME 'Maroodi jeex'
>        EXPRESSION 'mj'
>        STYLE
>          SYMBOL "circle"
>           SIZE 7.0
>           OUTLINECOLOR 0 0 0
>           COLOR 191 45 220
>         END
>      END
>      CLASS
>        NAME 'togdheer'
>        EXPRESSION 'td'
>        STYLE
>          SYMBOL "circle"
>           SIZE 7.0
>           OUTLINECOLOR 0 0 0
>           COLOR 182 131 78
>         END
>      END
>      TEMPLATE VOID
>    END
>    LAYER
>
> config section
> <?php
>
> //-------------------------------------------------------------------------
> // Digitizepoint plugin configuration.
> //-------------------------------------------------------------------------
> $dsn        = 'pgsql://postgres:everything@localhost:5432/SEEDS';
> $db_table   = 'school';       // Table name.
> $pkey       = 'oid';              // Table's primary key.
> $the_geom   = 'the_geom';        // Table's geometry field, type POINT.
> $srid_geom  = 4326;              // SRID of the geometry.
> $srid_map   = 4326;              // SRID of the map (clicked screen point).
> $tolerance  = 500;               // Distance in meteres to pick existing point for editing.
> $hide_fields = array('oid');      // Table fields not displayed in the edit form.
>
> ?>
>
> I will appreciate very much
>
>
> Daniel Mwaura
>
> JKUAT
>
> Dept of Gomatics Engineering and Geospatial Information Systems
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>