search

simon04 / whodidit

OpenStreetMap Changeset Analyzer
https://simon04.dev.openstreetmap.org/whodidit/
70 stars 10 forks source link

Whodidit does not work right now #60

Open vmicho opened 7 months ago

vmicho commented 7 months ago

At least the website doe not show anything since like a week :( Something crashed?

DonKult commented 7 months ago

@asg7443 reported a while ago in a closed issue that was about a similar problem, that the RSS feed is currently broken.

The web interface seems to have the same problem for ~a week by now. 2 requests for data seem to be made, one is for https://simon04.dev.openstreetmap.org/whodidit/scripts/changeset.php?latest=1 with the reply expected to be JSON, but:

<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: Table './simon04/wdi_changesets' is marked as crashed and last (automatic?) repair failed in /home/simon04/whodidit_prod/scripts/changeset.php:20
Stack trace:
#0 /home/simon04/whodidit_prod/scripts/changeset.php(20): mysqli-&gt;query()
#1 {main}
  thrown in <b>/home/simon04/whodidit_prod/scripts/changeset.php</b> on line <b>20</b><br />

and similarly a request with the actual filter parameters against tiles.php also expect JSON and getting the similar:

<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: Table './simon04/wdi_tiles' is marked as crashed and last (automatic?) repair failed in /home/simon04/whodidit_prod/scripts/tiles.php:104
Stack trace:
#0 /home/simon04/whodidit_prod/scripts/tiles.php(104): mysqli-&gt;query()
#1 {main}
  thrown in <b>/home/simon04/whodidit_prod/scripts/tiles.php</b> on line <b>104</b><br />

Looks like the database(s) are toast, currently.

Not sure what a random user like me could do, if anything at the moment, beside wishing the maintainer(s) good health & best of luck in restoring the service!

hungerburg commented 7 months ago

Simon get UP! I want to see what happens! In the community forum they talk about Blockwarts, Hell yes, I am simply a wart and just interested into what my fellow companions are about and perhaps welcome newbies.

EvansMike commented 7 months ago

I'm running the same code at home and it works fine so I concur that the DB is broken.

bloerwald commented 7 months ago

61 (or using the fork at https://github.com/bloerwald/whodidit/tree/master) simplifies setting up the code at home. If you're using my fork to catch up your changes, you'll will want to

GITMichaelK commented 5 months ago

I have been using this application for a long time and would appreciate, if it could be fixed. Thank you.

cayenne17 commented 5 months ago

Incidentally, I've found an alternative that I've been using for a while now: https://resultmaps.neis-one.org/osm-edits-tile/

GITMichaelK commented 5 months ago

Thank you @cayenne17,

https://resultmaps.neis-one.org/osm-edits-tile/

works, but is missing the bounding box, so the area is a bit to small for my area of interest.

dex2000 commented 3 months ago

looks like it works again, but last data are from april (if i see correctly)

GITMichaelK commented 3 months ago

Thank you @dex2000, you are right! For full results, I had to modify the RSS-URL.

aswerkljh commented 2 months ago

Thank you @dex2000, you are right! For full results, I had to modify the RSS-URL.

Can you please explain what you did? The link you posted just points at the main site.

dex2000 commented 2 months ago

here is an feed-url for example: https://simon04.dev.openstreetmap.org/whodidit/scripts/rss.php?bbox=11.498847,50.847004,11.678748,50.964779 you can see, the last is from april

GITMichaelK commented 2 months ago

Thank you @dex2000, you are right! For full results, I had to modify the RSS-URL.

Can you please explain what you did? The link you posted just points at the main site.

The main site is correct, I draw "my" bonding box and pressed "Get RSS-URL". BUT: The site as been workinf for a day or two, actually it seems to be down again.

dex2000 commented 2 months ago

For me is it online.

GITMichaelK commented 2 months ago

Yes it is online all time, but as you mentioned already here, actual changes are not reported right now. This has been working for a short time during last days ...