Mapbender - digitizer error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Mapbender - digitizer error

clmns.spkt

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: [hidden email]

   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
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users
Reply | Threaded
Open this post in threaded view
|

Re: Mapbender - digitizer error

Astrid Emde (WhereGroup)
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: [hidden email]
>
>     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
> [hidden email]
> 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

  [hidden email]
  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
-------------------------------
_______________________________________________
Mapbender_users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapbender_users