don`t see photos on map

[ad-tomsk]

Hi. i cant install map (0.1.9) on Nextcloud 21.0.3. Scan photos doesnt work. When start manually
sudo -u www-data php /var/www/nextcloud/occ maps:scan-photos
I see problem:

In ExceptionConverter.php line 47:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table
or view not found: 1146 Table 'nextcloud.oc_maps_photos' doesn't exist
In Exception.php line 26:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_map
s_photos' doesn't exist
In Statement.php line 82:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_map
s_photos' doesn't exist

i resolved problem by #566 (comment)
install 0.1.9.8 nightly (but in apps i see 0.1.9)
start manual scan
sudo -u www-data php /var/www/nextcloud/occ maps:scan-photos
In terminal i saw that my photos added, but not shown in the map. Why?
thank you in advance

[mawa1105]

Same for me!

[GAS85]

Meet the same issue, #651 photos appears after few hours.

[mawa1105]

For me, not after months!
What hardware do you use?

[GAS85]

AMD Ryzen 3 3200G, 4x 3.60GHz with 16 GB RAM. Scan itself was finished with a lot of CPU utilization, but only after that job was finished photos popping up on the map with a huge delay.
Somehow new photos (since ticket was opened) are not on the map jet...

[mawa1105]

Okay, maybe my CPU is the problem.... ( Cortex-A55)
I think the delay could be decades for me... Sad, because the foto on the maps function is a qiuet nice one!!

maybe someone will take pity and redesign the function?! :-)

[GAS85]

Not sure, there seems a cron job problem as per #516.
Can you see data in a oc_maps_photos? I have 100k+ entries there, basically all of the photos from all of the users, some of them a with GPS coordinates.

[mawa1105]

Sorry, how can I check that?!

[GAS85]

This is in DB, you need to login to your DB and run SQL query command, e.g. :

select * from `oc_maps_photos` where `lat` > 0 limit 0,25

You will see first 25 Photos with GPS coordinates.

[mawa1105]

Yes!
There are files from 80 to 89 and from 114 to 128... (wired!) And yes, they have "lat" and "lng" values.

When i click on Fotos in maps, i get a warning "Failed to load photos" after 1-2 minutes :-(

I have no idea!

[schanceee]

Hi,

I have tried to scan my photos using the command:
first: sudo -u www-data php occ maps:scan-photos
and then: sudo -u www-data php occ maps:scan-photos userid

Each time, the nextcloud logs show the following errors:
Required parameter $end follows optional parameter $deviceIdList at /var/www/nextcloud/apps/maps/lib/Controller/DevicesController.php#175
Required parameter $end follows optional parameter $categoryList at /var/www/nextcloud/apps/maps/lib/Controller/FavoritesController.php#216

I have a setup with 3 external storages folders from my qnap nas. From what I read in other issues, this seems to be the problem. However I cannot figure out how to solve it.

Do you know what I should do to fix it?