[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