<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Hello,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
yup it worked!</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Thanks,
<div>Marcin</div>
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Mapbender_users <mapbender_users-bounces@lists.osgeo.org> on behalf of Jörg Thomsen (WhereGroup) <joerg.thomsen@wheregroup.com><br>
<b>Sent:</b> Wednesday, August 2, 2023 2:45 PM<br>
<b>To:</b> mapbender_users@lists.osgeo.org <mapbender_users@lists.osgeo.org><br>
<b>Subject:</b> Re: [Mapbender-users] relation "mb_core_application" does not exist while trying to set up digitizer</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hello Marcin,<br>
<br>
an application working in dev-mode and not working in prod-mode is <br>
almost a hint to a cache-problem. Please delete the prod-cache.<br>
<br>
Jörg<br>
<br>
<br>
Am 02.08.23 um 14:17 schrieb Marcin Niemyjski:<br>
> Hello,<br>
> <br>
> as you suggested I corrected the parameters file, so now it looks the <br>
> way below:<br>
> <a href="https://pastecode.io/s/e0ab3z92">https://pastecode.io/s/e0ab3z92</a> <<a href="https://pastecode.io/s/e0ab3z92">https://pastecode.io/s/e0ab3z92</a>><br>
> I've also corrected the config.yml:<br>
> <a href="https://pastecode.io/s/8jytc37y">https://pastecode.io/s/8jytc37y</a> <<a href="https://pastecode.io/s/8jytc37y">https://pastecode.io/s/8jytc37y</a>> so it
<br>
> can use the second database - PostgreSQL.<br>
> <br>
> It worked! (Thanks Astrid!)<br>
> <br>
> However Digitizer seems to work but only in developer mode. I'm able to <br>
> create and edit points, lines and polygons 🙂<br>
> (Mapbender in developer mode returns no errors)<br>
> In localhost or by using Domen to connect I receive error 500. In <br>
> localhost I was able to retrieve some more log from console:<br>
> <a href="https://pasteboard.co/ZwYUvDQGr2vK.png">https://pasteboard.co/ZwYUvDQGr2vK.png</a>
<br>
> <<a href="https://pasteboard.co/ZwYUvDQGr2vK.png">https://pasteboard.co/ZwYUvDQGr2vK.png</a>><br>
> <br>
> Any suggestions?<br>
> Best,<br>
> Marcin<br>
> <br>
> <br>
> ------------------------------------------------------------------------<br>
> *From:* Mapbender_users <mapbender_users-bounces@lists.osgeo.org> on <br>
> behalf of Astrid Emde (WhereGroup) <astrid.emde@wheregroup.com><br>
> *Sent:* Tuesday, August 1, 2023 4:56 PM<br>
> *To:* Mapbender User List <mapbender_users@lists.osgeo.org><br>
> *Subject:* Re: [Mapbender-users] relation "mb_core_application" does not <br>
> exist while trying to set up digitizer<br>
> Hello Marcin,<br>
> <br>
> you created an empty PostgreSQL database for Mapbender.<br>
> <br>
> This database is empty at the beginning and you have to create the table<br>
> structure for Mapbender see<br>
> <br>
> <a href="https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional">
https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional</a> <<a href="https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional">https://doc.mapbender.org/en/installation/installation_ubuntu.html#optional</a>><br>
> <br>
> You have to run the commands to setup the structure.<br>
> <br>
> If you have an application in your former installation with sqlite you<br>
> could export it and import it again.<br>
> <br>
> Afterwards you should refer to a second database connection for your<br>
> geodata (mapbender and the geodata are not in one database).<br>
> <br>
> Check the workshop bundle for some example.<br>
> <br>
> <a href="https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml">
https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml</a> <<a href="https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml">https://github.com/mapbender/mapbender-workshop/blob/master/app/config/parameters.yml</a>><br>
> <a href="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</a> <<a href="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</a>><br>
> <br>
> You also find a database backup that you could use with the examples<br>
> <a href="https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup">
https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup</a> <<a href="https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup">https://github.com/mapbender/mapbender-workshop/blob/master/geobasis.backup</a>><br>
> <br>
> See you Astrid<br>
> <br>
> Am 2023-08-01 16:46, schrieb Marcin Niemyjski:<br>
>> Hello,<br>
>> <br>
>> I'm trying to set up the digitizer according to the instructions<br>
>> provided in<br>
>> <a href="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</a> <<a href="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</a>><br>
>> [1].<br>
>> <br>
>> I have already set up the sidepane element definition based on the<br>
>> instructions (I changed the connection to "default"). Then, in<br>
>> parameters.yaml, I overwrote the default database connection<br>
>> parameters with those of my PostgreSQL database.<br>
>> <br>
>> config.yaml -> remains the same<br>
>> <br>
>> parameters.yaml ->https://pastecode.io/s/2n9mt2ro<br>
>> <br>
>> Mapbender successfully connects to the database, but I encountered the<br>
>> following error in developer mode:<br>
>> <br>
>> '''<br>
>> An exception occurred while executing 'SELECT t0.id AS id_1, t0.title<br>
>> AS title_2, t0.slug AS slug_3, t0.description AS description_4,<br>
>> t0.template AS template_5, t0.map_engine_code AS map_engine_code_6,<br>
>> t0.persistent_view AS persistent_view_7, t0.published AS published_8,<br>
>> t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10,<br>
>> t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM<br>
>> mb_core_application t0 ORDER BY t0.title ASC':<br>
>> <br>
>> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation<br>
>> "mb_core_application" does not exist<br>
>> LINE 1: ...S updated_11, t0.custom_css AS custom_css_12 FROM<br>
>> mb_core_ap...<br>
>> ^<br>
>> '''<br>
>> <br>
>> Do you have any suggestions on how to overcome this issue? I've<br>
>> checked that over user struggled with same issue:<br>
>> <a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">https://marc.info/?l=mapbender-users&m=151602993622690&w=2</a>
<br>
> <<a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">https://marc.info/?l=mapbender-users&m=151602993622690&w=2</a>> [2]<br>
>> <br>
>> Best regards,<br>
>> <br>
>> Marcin<br>
>> <br>
>> <br>
>> Links:<br>
>> ------<br>
>> [1] <br>
>> <a href="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</a> <<a href="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</a>><br>
>> [2] <a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">
https://marc.info/?l=mapbender-users&m=151602993622690&w=2</a> <br>
> <<a href="https://marc.info/?l=mapbender-users&m=151602993622690&w=2">https://marc.info/?l=mapbender-users&m=151602993622690&w=2</a>><br>
>> _______________________________________________<br>
>> Mapbender_users mailing list<br>
>> Mapbender_users@lists.osgeo.org<br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a>
<br>
> <<a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a>><br>
> <br>
> -- <br>
> Mit freundlichen Grüßen<br>
> <br>
> Astrid Emde<br>
> GIS-Consultant<br>
> <br>
> **********************************<br>
> Aufwind durch Wissen!<br>
> Web-Seminare und Online-Schulungen<br>
> bei der <a href="http://www.foss-academy.com/">www.foss-academy.com/</a> <<a href="http://www.foss-academy.com/">http://www.foss-academy.com/</a>><br>
> **********************************<br>
> <br>
> Astrid Emde<br>
> WhereGroup GmbH<br>
> Eifelstraße 7<br>
> 53119 Bonn<br>
> Germany<br>
> <br>
> Tel: +49(0)228 90 90 38 - 22<br>
> Fax: +49(0)228 90 90 38 - 11<br>
> <br>
> astrid.emde@wheregroup.com<br>
> <a href="http://www.wheregroup.com">www.wheregroup.com</a> <<a href="http://www.wheregroup.com">http://www.wheregroup.com</a>><br>
> <br>
> Meinen PGP Public-Key können Sie unter pgp.mit.edu herunterladen:<br>
> <br>
> <a href="https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB">
https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB</a> <<a href="https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB">https://keys.openpgp.org/vks/v1/by-fingerprint/01F8152D36FC07C25EADDE86C5084ACC1C287CCB</a>><br>
> Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen<br>
> <br>
> Folgen Sie der WhereGroup auf twitter:<br>
> <a href="http://twitter.com/WhereGroup_com">http://twitter.com/WhereGroup_com</a> <<a href="http://twitter.com/WhereGroup_com">http://twitter.com/WhereGroup_com</a>><br>
> <br>
> Geschäftsführer:<br>
> Olaf Knopp, Peter Stamm<br>
> Amtsgericht Bonn, HRB 9885<br>
> -------------------------------<br>
> <br>
> _______________________________________________<br>
> Mapbender_users mailing list<br>
> Mapbender_users@lists.osgeo.org<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br>
-- <br>
Viele Grüße,<br>
Jörg Thomsen<br>
---------------------------------------------<br>
Aufwind durch Wissen!<br>
Web-Seminare und Online-Schulungen<br>
bei der <a href="http://www.foss-academy.com">www.foss-academy.com</a><br>
---------------------------------------------<br>
<br>
<br>
Jörg Thomsen<br>
WhereGroup GmbH<br>
Bundesallee 23<br>
10717 Berlin<br>
Germany<br>
<br>
Tel: +49 (0)30 / 5130 278 74<br>
Fax: +49 (0)30 / 5130 278 11 <br>
<br>
joerg.thomsen@wheregroup.com<br>
<a href="http://www.wheregroup.com">www.wheregroup.com</a><br>
<br>
Geschäftsführer:<br>
Olaf Knopp, Peter Stamm<br>
Amtsgericht Bonn, HRB 9885<br>
<br>
-------------------------------<br>
Folgen Sie der WhereGroup auf twitter: <a href="http://twitter.com/WhereGroup_com">
http://twitter.com/WhereGroup_com</a><br>
<br>
_______________________________________________<br>
Mapbender_users mailing list<br>
Mapbender_users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
</div>
</span></font></div>
</body>
</html>