Maps: How to regenerate oc_maps table

Created on 23 Jul 2019  路  7Comments  路  Source: nextcloud/maps

Hi
After a first installation of nextcloud/maps i made a - maps:scan-photos - with a big network folder shared to all users. The result was a very big confusion :-D

Then i thought to try to uninstall and reinstall to have a 'vanilla' maps environment that not have the big data generated by scanning a big network folder for all users, but it seems the db structure was the same before the reinstallation.

So i decide to try to delete all oc_maps* postgres tables (and oc_appdata mas records), thinking that the reinstall process will recreate, but now the installation process don't recreate missing tables.

So i am asking here how to regenerate oc_maps table or what i have to delete for forcing recreation of the db app environment ?

Thanks

question

All 7 comments

Now i have fixed db problems and while i am reindexing the photo with sudo -u www-data ./occ maps:scan-photos , i noticed that the process is indexing external file mounted with
Prewiew false property (in external_file).

I suggest if possible to not index photo on external folders when preview flag is false.

How did you regenerate DB schema again? By triggering all migration steps manually?

Preview false property (in external_file)

What do you mean by that? Is it a setting?

I agree it seems wise to avoid showing photos for which it's impossible to generate previews. Maybe we're still going to index them...

How did you regenerate DB schema again? By triggering all migration steps manually?

  • the only way i found is to get them from a backup :-D. A command like occ map:reset_db can be usefoul for testing an analising

What do you mean by that? Is it a setting?

  • External_folders, when configuring shares to mount has a property for disabling preview in gallery app. So gallery do not show preview for that big network shares, it can be right.

immagine

I sow instead that nextcloud/maps when made a - occ maps:scan - is indexing those big shared folder. I think it can be usefoul to make the same that gallery do.

Thanks to all

Right. Such external storages are not explored anymore. Thanks for the suggestion!

Thanks for the code :-D

Is there anything left do do here? :)

I don't think so.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

pilsnerbeer picture pilsnerbeer  路  10Comments

vwbusguy picture vwbusguy  路  6Comments

jakobroehrl picture jakobroehrl  路  13Comments

piiskop picture piiskop  路  6Comments

jancborchardt picture jancborchardt  路  11Comments