Web based family history software

This Help forum is for issues relates to the latest release (1.7.9). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

Question Control panel - Web site access rules

  • rweinl
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Think twice
More
6 years 3 months ago #1 by rweinl
Hello,

This function still appears in the Website menu of the Control panel. Should it be suppressed or not in ver 1.7.9 ?

Result of the call to this function :
/webtrees/app/Database.php:242 SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query #0 /app/Database.php:242 PDOException("SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query") #1 /admin_site_access.php:119 exec('DELETE unknown FROM `wt_site_a…')

Robert
1. webtrees 2.1.18 on D'Alsace en Lorraine < www.robert-weinland.org/webtrees/ > (PHP 8.0.30 - MySQL 8.0.30 - Rural theme 2.1.18)
2. webtrees 2.1.18 on Familles de Chérence < www.cherence95-fr.org/webtrees/ > (PHP 7.4.29 - MySQL 7.4.33 - Rural theme 2.1.18)

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

More
6 years 3 months ago #2 by fisharebest
Replied by fisharebest on topic Control panel - Web site access rules
This is simply a time-out error. It may disappear if you try again.

If you update one rule so that it now covers existing rules, then the existing rules are deleted. e.g. if you have 500 different IP addresses from google, and you update one of the rules to match all IP addresses, then the other 499 rules are not needed and will be deleted.

If you keep having timeout errors, you can try to run the SQL statement directly in MySQL. Here is the statement:

DELETE unknown
FROM `wt_site_access_rule` AS unknown
JOIN `wt_site_access_rule` AS known ON (unknown.user_agent_pattern LIKE known.user_agent_pattern)
WHERE unknown.rule='unknown' AND known.rule<>'unknown'
AND unknown.ip_address_start BETWEEN known.ip_address_start AND known.ip_address_end

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

Powered by Kunena Forum
}