[Mapbender-users] relation "mb_core_application" does not exist while trying to set up digitizer

[Marcin Niemyjski]

Hello,

as you suggested I corrected the parameters file, so now it looks the way below:
https://pastecode.io/s/e0ab3z92
I've also corrected the config.yml:
https://pastecode.io/s/8jytc37y so it can use the second database - PostgreSQL.

It worked! (Thanks Astrid!)

However Digitizer seems to work but only in developer mode. I'm able to create and edit points, lines and polygons 🙂
(Mapbender in developer mode returns no errors)
In localhost or by using Domen to connect I receive error 500. In localhost I was able to retrieve some more log from console:
https://pasteboard.co/ZwYUvDQGr2vK.png

Any suggestions?
Best,
Marcin


________________________________
From: Mapbender_users <mapbender_users-bounces at lists.osgeo.org> on behalf of Astrid Emde (WhereGroup) <astrid.emde at wheregroup.com>
Sent: Tuesday, August 1, 2023 4:56 PM
To: Mapbender User List <mapbender_users at lists.osgeo.org>
Subject: Re: [Mapbender-users] relation "mb_core_application" does not exist while trying to set up digitizer

Hello Marcin,

you created an empty PostgreSQL database for Mapbender.

This database is empty at the beginning and you have to create the table
structure for Mapbender see

https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional

You have to run the commands to setup the structure.

If you have an application in your former installation with sqlite you
could export it and import it again.

Afterwards you should refer to a second database connection for your
geodata (mapbender and the geodata are not in one database).

Check the workshop bundle for some example.

https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml
https://github.com/mapbender/mapbender-workshop/blob/master/app/config/config.yml#L63

You also find a database backup that you could use with the examples
https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup

See you Astrid

Am 2023-08-01 16:46, schrieb Marcin Niemyjski:
> Hello,
>
> I'm trying to set up the digitizer according to the instructions
> provided in
> https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer
> [1].
>
> I have already set up the sidepane element definition based on the
> instructions (I changed the connection to "default"). Then, in
> parameters.yaml, I overwrote the default database connection
> parameters with those of my PostgreSQL database.
>
>  config.yaml -> remains the same
>
>  parameters.yaml ->https://pastecode.io/s/2n9mt2ro
>
> Mapbender successfully connects to the database, but I encountered the
> following error in developer mode:
>
>  '''
>  An exception occurred while executing 'SELECT t0.id AS id_1, t0.title
> AS title_2, t0.slug AS slug_3, t0.description AS description_4,
> t0.template AS template_5, t0.map_engine_code AS map_engine_code_6,
> t0.persistent_view AS persistent_view_7, t0.published AS published_8,
> t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10,
> t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM
> mb_core_application t0 ORDER BY t0.title ASC':
>
> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation
> "mb_core_application" does not exist
> LINE 1: ...S updated_11, t0.custom_css AS custom_css_12 FROM
> mb_core_ap...
> ^
>  '''
>
> Do you have any suggestions on how to overcome this issue? I've
> checked that over user struggled with same issue:
> https://marc.info/?l=mapbender-users&m=151602993622690&w=2 [2]
>
> Best regards,
>
> Marcin
>
>
> Links:
> ------
> [1]
> https://doc.mapbender.org/en/functions/editing/digitizer/digitizer_configuration.html#setting-up-of-digitizer
> [2] https://marc.info/?l=mapbender-users&m=151602993622690&w=2
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

--
Mit freundlichen Grüßen

Astrid Emde
GIS-Consultant

**********************************
Aufwind durch Wissen!
Web-Seminare und Online-Schulungen
bei der www.foss-academy.com/<http://www.foss-academy.com/>
**********************************

   Astrid Emde
   WhereGroup GmbH
   Eifelstraße 7
   53119 Bonn
   Germany

   Tel: +49(0)228 90 90 38 - 22
   Fax: +49(0)228 90 90 38 - 11

   astrid.emde at wheregroup.com
   www.wheregroup.com<http://www.wheregroup.com>

   Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:

https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB
   Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen

   Folgen Sie der WhereGroup auf twitter:
   http://twitter.com/WhereGroup_com

   Geschäftsführer:
   Olaf Knopp, Peter Stamm
   Amtsgericht Bonn, HRB 9885
-------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230802/6a604943/attachment-0001.htm>