[Mapbender-users] Problem using the Search Router (can't find table)

[Astrid Emde]

Hello Patrice,

Am 2017-07-01 16:15, schrieb Patrice:
> I am trying to use the Search Router bundle in an application, but it
> fails.
> 
> At first, it could not find the database, so I have setup the database
> in config.yml and parameters.yml.
> 
> Now, it can't find the table to search in.
> 
> Here is the error in prod.log:
> 
> [2017-07-01 14:04:54] request.CRITICAL: Uncaught PHP Exception
> Doctrine\DBAL\DBALException: "An exception occurred while executing
> 'SELECT t.objectid, t.code_proje, ST_AsGeoJSON(geom) as geom FROM
> data.aires_prot_priv t WHERE LOWER(t.code_proje) LIKE LOWER(?)' with
> params ["%tabi%"]:  SQLSTATE[HY000]: General error: 1 no such table:
> data.aires_prot_priv" at
> C:\ms4w\apps\mapbender3-3.0.5.3\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php
> line 91 {"exception":"[object] (Doctrine\\DBAL\\DBALException(code:
> 0): An exception occurred while executing 'SELECT t.objectid,
> t.code_proje, ST_AsGeoJSON(geom) as geom FROM data.aires_prot_priv t
> WHERE LOWER(t.code_proje) LIKE LOWER(?)' with params
> [\"%tabi%\"]:\n\nSQLSTATE[HY000]: General error: 1 no such table:
> data.aires_prot_priv at
> C:\\ms4w\\apps\\mapbender3-3.0.5.3\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\DBALException.php:91,
> PDOException(code: HY000): SQLSTATE[HY000]: General error: 1 no such
> table: data.aires_prot_priv at
> C:\\ms4w\\apps\\mapbender3-3.0.5.3\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php:691)"}
> []
> 
> The table "aires_prot_priv" does exist in the "data" schema and I have
> the necessary right to read from it (made the test with pgAdmin using
> the same credentials as specified in parameters.yml).
> 
> However, as my database and schema are already filled with the data I
> want to use, I didn't create the database and schema using
> "doctrine:database:create". Is this mandatory in order to use the
> search router?

No - this is not mandatory.


> What am I missing?

It looks like your database configuration is not right or your 
configuration.
You should ceck this again in parameters.yml and config.yml.

https://doc.mapbender3.org/en/book/database.html#using-multiple-databases

In the searchRouter configuration you have to use the name that you 
defined for your second database

Hope that helps

Astrid

> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

**********************************
AGIT 2017
5.-7. Juli 2017 in Salzburg
Besuchen Sie uns an Stand Nr. 31
www.agit.at
**********************************

  Astrid Emde
  WhereGroup GmbH & Co.KG
  Eifelstraße 7
  53119 Bonn
  Germany

  Fon: +49(0)228 90 90 38 - 22
  Fax: +49(0)228 90 90 38 - 11

  astrid.emde at wheregroup.com
  www.wheregroup.com

  Folgen Sie der WhereGroup auf twitter: 
http://twitter.com/WhereGroup_com

Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------