FIXED! Nextcloud – Maps and PhoneTrack Not Working (tables not created in database)

(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. 😁