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:everyth...@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
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
