Can't retrieve full history of spots

jgeusebroek / docker-spotweb

A docker image running ubuntu/20.04 Linux and Spotweb

47 stars 27 forks source link

Can't retrieve full history of spots #59

Closed Rebelder closed 11 months ago

Rebelder commented 1 year ago

Hi there, I've been using your docker image on a Syno NAS and have just moved it to a Ubuntu server (22.04). In both cases I have been unable to retrieve the full history of spots in the config>settings>retrieve part of Spotweb. I'm wondering if it's me or if there is an underlying issue.

Steps I'm taking:

go to retrieve settings
choose date 24-11-2010 (also tried it with 01-08-2022, same result)
click "change"
click "retrieve" in maintenance

After that, only the latest spots are retrieved, not older ones.

Hope you can help, either by redirecting my query somewhere else or investigating it.

rb2k5 commented 12 months ago

You may need to reset the database and run retrieve.php

https://github.com/jgeusebroek/docker-spotweb/issues/59

php bin/upgrade.php --reset-db
in GUI go to settings --> retrieve
set "retention on spots" to 0 (keep all spots)
set desired date
php retrieve.php

alternatively -

https://drfrankenstein.co.uk/spotweb-not-backfilling/

Rebelder commented 11 months ago

Thanks a lot for the response, unfortunately I don't seem to be capable enough to execute either of the options. There is no upgrade.php (or upgrade-db.php) in either the spotweb docker or the mariaDB docker. Using PHPMyAdmin I haven't been able to connect to the DB (yet). @rb2k5 Can you maybe shed some light on the first solution you've given? Where should I find this php script, if it's not in the /bin folder?

Edit: never mind, got phpMyAdmin working. Will try that way and post results

Rebelder commented 11 months ago

Update: actually both options worked (I had 2 instances of spotweb running)! Thanks a bunch @rb2k5