[Mapbender-users] Mapbender - digitizer error
Clemens Espunkt
clemens.espunkt at gmail.com
Thu Jan 11 01:53:12 PST 2018
Liebe Mapbender Community,
ich teste Mapbender3 (3.0.6.3), versuche den Digitizer einzubinden und
bekomme über die app_dev.php folgende Fehlermeldung:
CRITICAL - Uncaught PHP Exception
Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred
while executing 'SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS
slug_2, m0_.description AS description_3, m0_.template AS template_4,
m0_.published AS published_5, m0_.screenshot AS screenshot_6,
m0_.extra_assets AS extra_assets_7, m0_.updated AS updated_8,
m0_.custom_css AS custom_css_9 FROM mb_core_application m0_ ORDER BY
m0_.title ASC': SQLSTATE[42P01]: Undefined table: 7 FEHLER: Relation
„mb_core_application“ existiert nicht LINE 1: ...AS updated_8,
m0_.custom_css AS custom_css_9 FROM mb_core_ap... ^" at
C:\mapbender3\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractPostgreSQLDriver.php
line 75
Wenn ich die Anwendung im Browser starte folgende Fehlermeldung angezeigt:
Feature API query error.”<!DOCTYPE html>\n<html>\n <head>\n <meta
charset=\”UTF-8\” />\n <titel>An Error Occured: Internal Server
Error</titel>\n </head>\n <body>\n <h1>Oops! An Error Occurred</h1>\n
<h2>The server returned a \”500 Internal Server Error\”.</h2>\n\n <div>\n
Something is broken. Please let us know what you were doing when this error
occurred.\n We will fix it as soon as possible. Sorry for any inconvenience
caused.\n </div>\n </body>\n</html>\n
Weiter unten füge ich die Parameters.yml und die config.yml an. Kann mir
jemand mit den Meldungen helfen - oder Tipps geben, woran es liegen könnte?
Vielen Dank und beste Grüße,
Clemens
______________________________________________________________________________
Dear Mapbender community,
I have a Mapbender3 (3.0.6.3) installation running and try to implement the
digitizer. But in the app_dev.php i receive the following error:
CRITICAL - Uncaught PHP Exception
Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred
while executing 'SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS
slug_2, m0_.description AS description_3, m0_.template AS template_4,
m0_.published AS published_5, m0_.screenshot AS screenshot_6,
m0_.extra_assets AS extra_assets_7, m0_.updated AS updated_8,
m0_.custom_css AS custom_css_9 FROM mb_core_application m0_ ORDER BY
m0_.title ASC': SQLSTATE[42P01]: Undefined table: 7 FEHLER: Relation
„mb_core_application“ existiert nicht LINE 1: ...AS updated_8,
m0_.custom_css AS custom_css_9 FROM mb_core_ap... ^" at
C:\mapbender3\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractPostgreSQLDriver.php
line 75
If i open the application in a browser i receive the following error:
Feature API query error.”<!DOCTYPE html>\n<html>\n <head>\n <meta
charset=\”UTF-8\” />\n <titel>An Error Occured: Internal Server
Error</titel>\n </head>\n <body>\n <h1>Oops! An Error Occurred</h1>\n
<h2>The server returned a \”500 Internal Server Error\”.</h2>\n\n <div>\n
Something is broken. Please let us know what you were doing when this error
occurred.\n We will fix it as soon as possible. Sorry for any inconvenience
caused.\n </div>\n </body>\n</html>\n”
Down below, there are the parameters.yml and config.yml. Do anybody know
how to solve these problems?
Thank you for your help and best regards,
Clemens
Config.yml
imports:
- { resource: parameters.yml }
- { resource: security.yml }
framework:
#esi: ~
translator: { fallback: %fallback_locale% }
secret: %secret%
router:
resource: "%kernel.root_dir%/config/routing.yml"
strict_requirements: %kernel.debug%
form: true
csrf_protection: true
validation: { enable_annotations: true }
templating: { engines: ['twig'] } #assets_version: SomeVersionScheme
default_locale: %locale%
session:
cookie_httponly: true
cookie_secure: %cookie_secure%
cookie_lifetime: %cookie_lifetime%
# Twig Configuration
twig:
debug: %kernel.debug%
strict_variables: %kernel.debug%
globals:
fom: %fom%
form:
resources:
- 'FOMCoreBundle:Form:fields.html.twig'
# Assetic Configuration
assetic:
debug: %kernel.debug%
use_controller: true
filters:
cssrewrite: ~
sass: ~
# Doctrine Configuration
doctrine:
dbal:
default_connection: default
connections:
default:
driver: %database_driver%
host: %database_host%
port: %database_port%
dbname: %database_name%
path: %database_path%
user: %database_user%
password: %database_password%
persistent: true
charset: UTF8
logging: %kernel.debug%
profiling: %kernel.debug%
#Datenbankverbindung "search_router"
search_router:
driver: %database2_driver%
host: %database2_host%
port: %database2_port%
dbname: %database2_name%
path: %database2_path%
user: %database2_user%
password: %database2_password%
charset: UTF8
logging: %kernel.debug%
profiling: %kernel.debug%
#Datenbankverbindung "digitizer"
digitizer:
driver: %database3_driver%
host: %database3_host%
port: %database3_port%
dbname: %database3_name%
path: %database3_path%
user: %database3_user%
password: %database3_password%
charset: UTF8
logging: %kernel.debug%
profiling: %kernel.debug%
orm:
auto_generate_proxy_classes: %kernel.debug%
auto_mapping: true
# Swiftmailer Configuration
swiftmailer:
transport: %mailer_transport%
host: %mailer_host%
username: %mailer_user%
password: %mailer_password%
spool: { type: memory }
# FOM Manager Configuration
fom_manager:
route_prefix: /manager
# FOM User Configuration
fom_user:
selfregister: false
reset_password: true
max_registration_time: 1
max_reset_time: 1
mail_from_address: wizard at oz.net
mail_from_name: Wizard of Oz
profile_entity: FOM\UserBundle\Entity\BasicProfile
profile_formtype: FOM\UserBundle\Form\Type\BasicProfileType
profile_template: FOMUserBundle:User:basic_profile.html.twig
self_registration_groups:
- Self Registered
- Demo Group
# Allow to create user log table on the fly if the table doesn't exits.
# Default: true
auto_create_log_table: false
# Time between to check login tries
login_check_log_time: "-5 minutes"
# Login attemps before delay starts
login_attempts_before_delay: 3
# Login delay after all attemps are failed
login_delay_after_fail: 5 # Seconds
# OWSProxy Configuration
ows_proxy3_core:
logging: %ows_proxy3_logging%
obfuscate_client_ip: %ows_proxy3_obfuscate_client_ip%
proxy:
host: %ows_proxy3_host%
port: %ows_proxy3_port%
connecttimeout: %ows_proxy3_connecttimeout%
timeout: %ows_proxy3_timeout%
user: %ows_proxy3_user%
password: %ows_proxy3_password%
checkssl: true
noproxy: %ows_proxy3_noproxy%
# Mapbender Configuration
mapbender_core: ~
parameters.yml
parameters:
# Datenbankverbindung "default"
database_driver: pdo_pgsql
database_host: localhost
database_port: 5432
database_name: mapbender3
database_path: ~
database_user: postgres
database_password: ---
# Datenbankverbindung "search_router"
database2_driver: pdo_pgsql
database2_host: localhost
database2_port: 5432
database2_name: search_db
database2_path: ~
database2_user: postgres
database2_password: ---
# Datenbankverbindung "digitizer"
database3_driver: pdo_pgsql
database3_host: localhost
database3_port: 5432
database3_name: digitizer
database3_path: ~
database3_user: postgres
database3_password: ---
mailer_transport: smtp
mailer_host: localhost
mailer_user: ~
mailer_password: ~
# locale en, de, it, es, ru, nl, pt are available
fallback_locale: en
locale: en
secret: ThisTokenIsNotSoSecretChangeIt
fom:
server_name: Mapbender3
server_version: 3.0.6.3
server_logo: bundles/mapbendercore/image/logo_mb3.pngg
# framework :
http://symfony.com/doc/2.8/reference/configuration/framework.html#cookie-lifetime
cookie_secure: false
cookie_lifetime: 3600
# OWSProxy Configuration
ows_proxy3_logging: false
ows_proxy3_obfuscate_client_ip: true
ows_proxy3_host: ~
ows_proxy3_port: ~
ows_proxy3_connecttimeout: 60
ows_proxy3_timeout: 90
ows_proxy3_user: ~
ows_proxy3_password: ~
ows_proxy3_noproxy: ~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20180111/f703da45/attachment-0001.html>
More information about the Mapbender_users
mailing list