[Mapbender-users] Mapbender - digitizer error

Astrid Emde astrid.emde at wheregroup.com
Fri Feb 9 04:14:31 PST 2018


Hallo Clemens,

ist das Problem bereits gelöst? Oder wird noch Unterstützung benötigt?

Es sieht so aus, als wäre die Datenbankanbindung nicht korrekt.

Viele Grüße

Astrid Emde

Am 2018-01-11 10:53, schrieb Clemens Espunkt:
> 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: ~
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Mit freundlichen Grüßen

Astrid Emde
Senior GIS-Consultant

****************************************************************************
FOSS Academy Kompaktkurs Winterschule 2018
Grundwissen zum Aufbau von Geodateninfrastrukturen mit 
Open-Source-Software
https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule
****************************************************************************


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


More information about the Mapbender_users mailing list