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