Hi Armin, hi all,

I am trying to set up an attribute search on a postgis table.
A simple query works fine, but I get errors as soon as I add the Definition
tag, in order to have the suggest option working.

<searchitem name="tree" description="Tree">
    <layer type="postgis" name="tree">
       <field type="n" name="id_tree" description="Tree" wildcard="2">
          <definition type="suggest" connectiontype="db" minlength="1"
startleft="1" sort="asc">
          </definition>
       </field>
    </layer>
</searchitem>

[error] [client 127.0.0.1] PHP Fatal error:  require_once(): Failed opening
required 'MDB2.php' (include_path='.:/usr/share/php:/usr/share/pear')
 => apt-get install php-mdb2

[error] [client 127.0.0.1] ===== P.MAPPER: DB ERROR =====\nStandard
Message:   MDB2 Error: not found\nDBMS/Debug Message: unable to find
package 'MDB2_Driver_pgsql' file 'MDB2/Driver/pgsql.php'
 => apt-get install php-mdb2-driver-pgsql

[error] [client 127.0.0.1] ===== P.MAPPER: DB ERROR =====\nStandard
Message:   MDB2 Error: not found\nDBMS/Debug Message: *no RDBMS driver
specified *

Am I supposed to install something else or define something in the php.ini
file?


I tried to add the following into the Definition tag,
<dsn encoding="UTF-8">pgsql://user:pass@localhost/db_name</dsn>
but I get:
[error] [client 127.0.0.1] ===== P.MAPPER: DB ERROR =====\nStandard
Message:   MDB2 Error: unknown error\nDBMS/Debug Message: _doQuery: [Error
message: Could not execute statement]

Any help will be much appreciated!
Thx!

BaK
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to