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

[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?

What am I missing?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20170701/ae1a0b4d/attachment.html>