danielbrendel / hortusfox-web

Self-hosted collaborative plant management and tracking system for plant enthusiasts
https://www.hortusfox.com
MIT License
674 stars 34 forks source link

WEather Forcast incorrect/corrupted #306

Open dghoti opened 4 days ago

dghoti commented 4 days ago

Describe the bug The weather is only showing as blank circles and no data/weather

To Reproduce Steps to reproduce the behavior:

  1. Configure and install a new, blank docker-compose file
  2. add existing and tested working weather api info
  3. click on "weather icon" on upper toolbar
  4. See error

Expected behavior To see a weather forcast (the weather/location name shows fine in corner of main page, as expected.

Screenshots image

Software: HortusFox v3.7 PHP Version: 8.3.0 MySQL Version: 11.5.2-MariaDB-ubu2404 Server: Linux #1 SMP PREEMPT Debian 1:6.6.51-1+rpt1 (2024-09-26) on aarch64 Timezone: 2024-11-17 19:08 (Europe/Dublin) Render time: 1.0942s

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context when enabling/disabling openweather info, I get the following error: image

danielbrendel commented 3 days ago

Hi, the fix for DST will be available in v3.8, so it is not available via the current version 3.7. But nonetheless you raised an important issue here in your screenshot!

Due to strict mode, mariadb fails to update the cache using 1970-01-01 00:00:00 as value for updated_at in the cache model, so as a result the cache will never be updated and as such you will keep seeing old weather data.

The v3.8 hotfix update is scheduled for the up-coming weekend (Friday or Saturday), so stay tuned! Unfortunately I can't release the hotfix version before since Mo-Thu are very busy days.

Thanks for reporting this issue!

dghoti commented 3 days ago

Thank you kindly!

On Mon, 18 Nov 2024, 10:53 Daniel Brendel, @.***> wrote:

Hi, the fix for DST will be available in v3.8, so it is not available via the current version 3.7. But nonetheless you raised an important issue here in your screenshot!

Due to strict mode, mariadb fails to update the cache using 1970-01-01 00:00:00 as value for updated_at in the cache model, so as a result the cache will never be updated and as such you will keep seeing old weather data.

The v3.8 hotfix update is scheduled for the up-coming weekend (Friday or Saturday), so stay tuned! Unfortunately I can't release the hotfix version before since Mo-Thu are very busy days.

Thanks for reporting this issue!

— Reply to this email directly, view it on GitHub https://github.com/danielbrendel/hortusfox-web/issues/306#issuecomment-2482677494, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEIPL6FQ5JEL4S67JOP5N2L2BHBLHAVCNFSM6AAAAABR6HMIG2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBSGY3TONBZGQ . You are receiving this because you authored the thread.Message ID: @.***>