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

Wed Aug 2 05:45:25 PDT 2023

Hello Marcin,

an application working in dev-mode and not working in prod-mode is 
almost a hint to a cache-problem. Please delete the prod-cache.

Jörg

Am 02.08.23 um 14:17 schrieb Marcin Niemyjski:
> Hello,
> 
> as you suggested I corrected the parameters file, so now it looks the 
> way below:
> https://pastecode.io/s/e0ab3z92 <https://pastecode.io/s/e0ab3z92>
> I've also corrected the config.yml:
> https://pastecode.io/s/8jytc37y <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 
> <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 <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/parameters.yml>
> https://github.com/mapbender/mapbender-workshop/blob/master/app/config/config.yml#L63 <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 <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 <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 
> <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 <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 
> <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 
> <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 <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 <http://twitter.com/WhereGroup_com>
> 
>     Geschäftsführer:
>     Olaf Knopp, Peter Stamm
>     Amtsgericht Bonn, HRB 9885
> -------------------------------
> 
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users

-- 
Viele Grüße,
Jörg Thomsen
---------------------------------------------
Aufwind durch Wissen!
Web-Seminare und Online-Schulungen
bei der www.foss-academy.com
---------------------------------------------

Jörg Thomsen
WhereGroup GmbH
Bundesallee 23
10717 Berlin
Germany

Tel: +49 (0)30 / 5130 278 74
Fax: +49 (0)30 / 5130 278 11	

joerg.thomsen at wheregroup.com
www.wheregroup.com

Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885

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