<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I am trying to use the Search Router bundle in an application, but
it fails.<br>
<br>
At first, it could not find the database, so I have setup the
database in config.yml and parameters.yml.<br>
<br>
Now, it can't find the table to search in.<br>
<br>
<br>
Here is the error in prod.log:<br>
<br>
[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)"}
[]<br>
<br>
<br>
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).<br>
<br>
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 "<code
class="docutils literal"><span class="pre">doctrine:database:create</span></code>".
Is this mandatory in order to use the search router?<br>
<br>
What am I missing?<br>
</body>
</html>