FacilMap / facilmap

FacilMap is a privacy-friendly, open-source versatile online map that combines different services based on OpenStreetMap and makes it easy to find places, plan trips and add markers, lines and routes to custom maps with live collaboration.
https://facilmap.org/
GNU Affero General Public License v3.0
317 stars 21 forks source link

collaborative map doesn't exist after upgrade #291

Open seljuck opened 2 months ago

seljuck commented 2 months ago

Hello,

I did a docker compose pull on my Facilmap container last week, and now I get this error message trying to pull up a collaborative map

Error opening map This map does not exist.

image

Is there any way to get it back?

Thanks, Daniel

cdauth commented 2 months ago

That's strange! What database are you using?

In the latest image, the Pads table was renamed to Maps. Maybe something went wrong during the rename? Could you inspect your database and see whether the Pads database still exists and contains your maps?

seljuck commented 2 months ago

I'm just using the one that's called form the standard docker-compose.yml file, postgis

The Pads table does still exist, and there is no Maps table.

seljuck commented 2 months ago

Can I manually change the table name myself? Or is there a way automatically have the table name change?

cdauth commented 2 months ago

If you don't have a Maps table yet, you are still on v4. I'm not sure what could have gone wrong here. Could you just inspect the Pads table and see if you find your map there, and whether it still has the same id, writeId or adminId that you were using before?

seljuck commented 2 months ago

I'm in the psql cli and I use the command /d Pads It gives me the error "Did not find any relation Pads" In fact it gives me that error for any table in the Public Schema. But it will display tables that are in the tiger schema.

tio-trom commented 2 months ago

Same for me. I am using the Yunohost package https://github.com/YunoHost-Apps/facilmap_ynh - I have lost the saved maps unfortunately, all after the update.

cdauth commented 4 weeks ago

Have you found out anything new in the meantime? Has the problem maybe solved itself after pulling and updating again?

I find it pretty hard to investigate this remotely without having access to the database. Would it be an option for someone who has this problem to share their database? Maybe could you investigate the database a little bit? What tables are there, do they still contain the data of your lost maps?

tio-trom commented 3 weeks ago

The 4.1.2 fixed it for me! Yes! I can find the saved maps again! :)