Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1
  • 2

TOPIC: Most viewed pages with unbeleavable scores

Most viewed pages with unbeleavable scores 3 weeks 3 days ago #21

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
Your screendump (post #12) shows a home-page block.

Hit counters are also shown at the bottom of pages.

Do you see problems at the bottom of pages - or just in the block?

Also, is the screendump a "Most visited pages" block, or is it an HTML block?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Most viewed pages with unbeleavable scores 3 weeks 3 days ago #22

  • Andreas
  • Andreas's Avatar Topic Author
  • Offline
  • Frequent
  • Frequent
  • Posts: 560
The incredibly high numbers appeared in both places. As well in the block, and also in the footer of the page to which it refers,

In the meantime I cleaned the table for the third time by deleting all high scores, like Bertkoor told me.

Since this cleaning all seems fine. I'll watch the phenomenon

Please Log in or Create an account to join the conversation.

Last edit: by Andreas.

Most viewed pages with unbeleavable scores 2 weeks 5 days ago #23

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
> In the meantime I cleaned the table for the third time by deleting all high scores, like Bertkoor told me.

Did you look at the data that you deleted?
Just one row?
One row per tree?
All exactly the same number?
etc.

There may have been patterns in the data that would give us a clue.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Most viewed pages with unbeleavable scores 2 weeks 5 days ago #24

  • Andreas
  • Andreas's Avatar Topic Author
  • Offline
  • Frequent
  • Frequent
  • Posts: 560
Sorry but I didn't care about the content before running the SQL call that Bertkoor gave me.

bertkoor wrote: There is a table hit_counter with column page_count that needs to be set to zero again.

update wt_hit_counter
    set page_count = 0
   where page_count > 10000;

Your table names might have a different prefix than wt_

But maybe its a good idea to firsr have a look in the actual content of that table.


I remember that all amounts of hits were exactly the same.

For the moment all seems to be ok.

I suppose that someone or a bad piece of code tried to fill the table. It didn't seem to be dangerous.

Please Log in or Create an account to join the conversation.

Most viewed pages with unbeleavable scores 2 weeks 3 days ago #25

  • Andreas
  • Andreas's Avatar Topic Author
  • Offline
  • Frequent
  • Frequent
  • Posts: 560

fisharebest wrote: > In the meantime I cleaned the table for the third time by deleting all high scores, like Bertkoor told me.

Did you look at the data that you deleted?
Just one row?
One row per tree?
All exactly the same number?
etc.

There may have been patterns in the data that would give us a clue.


This morning the server was very slow and I noticed that the scores raised again.






The webtrees log doesn't show any errors for the last three days.


The servers error log schows this
[Sun May 10 04:17:00 2020] [error] [client 39.101.128.217] [host wt.rauhut.eu] AH01797: client denied by server configuration: /homez.769/rauhut/wt201/data/admin
[Sun May 10 08:47:55 2020] [error] [client 94.134.179.39] [host wt.rauhut.eu] End of script output before headers: index.php, referer: https://wt.rauhut.eu/tree/GAC.ged/individual/I19154/Anna-Rosina-Waehner
[Sun May 10 19:16:54 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:17:01 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:17:08 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:18:42 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:19:14 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:20:39 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:20:45 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 19:22:56 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 22:00:24 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 22:02:33 2020] [error] [client 93.6.243.166] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/Gasnier/report/descendancy_report?xref=I6916
[Sun May 10 22:52:22 2020] [error] [client 88.78.188.72] [host wt.rauhut.eu] Script timed out before returning headers: index.php, referer: https://wt.rauhut.eu/tree/GAC.ged/individual/I15035/Friedrich-Wilhelm-Rauhut

[Mon May 11 05:11:45 2020] [error] [client 158.101.18.36] [host www.rauhut.eu] AH00687: Negotiation: discovered file(s) matching request: /homez.769/rauhut/www/web (None could be negotiated)

[Tue May 12 09:20:39 2020] [error] [client 111.202.103.87] [host wt1.rauhut.eu] AH10141: FastCGI: comm with server "/homez.769/rauhut/wt/indilist.php" aborted: idle timeout (160 sec)
[Tue May 12 09:20:39 2020] [error] [client 111.202.103.87] [host wt1.rauhut.eu] AH00524: Handler for fastcgi-script returned invalid result code 1
[Tue May 12 09:38:54 2020] [error] [client 111.202.103.87] [host wt1.rauhut.eu] AH10141: FastCGI: comm with server "/homez.769/rauhut/wt/indilist.php" aborted: idle timeout (160 sec)
[Tue May 12 09:38:54 2020] [error] [client 111.202.103.87] [host wt1.rauhut.eu] AH00524: Handler for fastcgi-script returned invalid result code 1

PhpMyAdmin showed me that most individuals have 18881/18880, families 490 & medias 5 hits. There are only some objects with less hits.
I copied the table wt_hit_counter (43929 rows).

This attachment is hidden for guests.
Please log in or register to see it.
Attachments:

Please Log in or Create an account to join the conversation.

Last edit: by Andreas.

Most viewed pages with unbeleavable scores 2 weeks 1 day ago #26

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 12929
Thanks for this data file!

Seeing the patterns in the data led me straight to the problem...

When we merge two records, we merge the hit counters.
i.e. we add the two values, and copy them to record we will keep.

But a bug here means that we copy them to *every* record of the same type.

It's a one line fix.

github.com/fisharebest/webtrees/commit/4...fc4e99c0e61bcafda068
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Most viewed pages with unbeleavable scores 1 week 3 days ago #27

  • Andreas
  • Andreas's Avatar Topic Author
  • Offline
  • Frequent
  • Frequent
  • Posts: 560

fisharebest wrote: Thanks for this data file!

Seeing the patterns in the data led me straight to the problem...

When we merge two records, we merge the hit counters.
i.e. we add the two values, and copy them to record we will keep.

But a bug here means that we copy them to *every* record of the same type.

It's a one line fix.

github.com/fisharebest/webtrees/commit/4...fc4e99c0e61bcafda068


So it's me, when merging records, I raised myself the hit counter !!!
Damned. Thank's for the patch. I will insert it immediately, after cleaning the tables.

Please Log in or Create an account to join the conversation.

Last edit: by Andreas.
  • Page:
  • 1
  • 2
Powered by Kunena Forum