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

[Astrid Emde (WhereGroup)]

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

   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

   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 --------------
A non-text attachment was scrubbed...
Name: 0x1C287CCB.asc
Type: application/pgp-keys
Size: 1574 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230801/82f264c6/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20230801/82f264c6/attachment.sig>