(My NextCloud Version: “21.0.1.1”)
With NextCloud you can store all of your photos with geo-tags and then conveniently view your photos by location on a map.
My first NextCloud installation was done via SNAP and all mapping worked fine. After realizing that I didn’t want to deal with a SNAP for the life of my NextCloud, I created a NextCloud instance natively, without SNAP. After doing the native install, a few things didn’t work. Specifically, the mapping feature.
After uninstalling and reinstalling, scouring the forums, etc., nothing worked. I noticed that when I performed a scan for photos and phone tracks, it gave errors like this:
Table 'nextcloud.oc_maps_tracks' doesn't exist
Table 'nextcloud.oc_maps_photos' doesn't exist
So, it was telling me that my database was the issue. I went nuclear and granted ALL PRIVILEGES to my NextCloud account in MySQL. I figured that if the tables weren’t getting created then it must be having a permissions issue. This, however, did nothing.
Finally, I figured out what to do. I scripted out the database from yet another SNAP instance I had running and picked out the maps tables. Then, I ran those scripts in my native NextCloud instance (the one that I wanted to use), thus creating the tables that the error messages were complaining about. After that, I did a photo and phone track scan, and 💥 BOOM!, it started working.
Here are the scripts that I used to create the tables:
After creating the tables, go to your NextCloud directory, where you run your OCC commands, and update your map and phone track info.
cd /var/www/html/nextcloud
sudo -u www-data php occ maps:scan-tracks
sudo -u www-data php occ maps:scan-photos
And now, it all works. 😁
