well, your operating systems already tells you the commands for
installing the missing packages ("apt-get install....") ...in addition, you can search for MDB2 on the wiki, there you'll get e.g. a link to http://svn.pmapper.net/trac/wiki/UpgradeOlderVersions armin On Thu, Apr 12, 2012 at 1:13 PM, Chris forum <bak.fo...@gmail.com> wrote: > 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
