- This topic has 7 replies, 2 voices, and was last updated 6 years, 5 months ago by
aslanukva.
Tags: white screen
-
28th November 2015 at 4:53 am #5458
Site access rules white screen
-
28th November 2015 at 7:35 am #5460
Look for an error message in your web server error logs.
Nigel
My personal kiwitrees site is www.our-families.info -
28th November 2015 at 9:18 am #5461
this error
Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction’ in /var/www/noble/data/www/nobility.pro/genealogy/library/WT/DB.php:198 Stack trace: #0 /var/www/noble/data/www/nobility.pro/genealogy/library/WT/DB.php(198): PDO->exec(‘DELETE unknown …’) #1 /var/www/noble/data/www/nobility.pro/genealogy/admin_site_access.php(282): WT_DB::exec(‘DELETE unknown …’) #2 {main} thrown in /var/www/noble/data/www/nobility.pro/genealogy/library/WT/DB.php on line 198
-
28th November 2015 at 10:34 am #5462
OK, that helps.
Your MySQL has a time-out setting that is too low for the delete operation. There are a number of possible solutions:
1 – Try referring this to your web host and ask if they can increase the mysql lock wait timeout. But I suspect the answer will be no.
2 – The problem probably happens because your site_access table is grown too large. So delete some entries manually from the database.
I suggest you try 1. first as it is the safest solution. If you delete the wrong rows you will lock yourself out of the whole site! Perhaps your web host will increase it just temporarily so you can then use the kiwitrees delete to correctly remove entries. (This is something that should be done every few months).
If you must try 2. then take care.
- The table is xxx_site_access_rules
- ONLY delete rows that have the setting ‘rule’ = ‘unknown’. You can delete as many of these as you want.
- Do NOT delete any other rows.
Nigel
My personal kiwitrees site is www.our-families.info -
28th November 2015 at 10:44 am #5463
I will try to do what you said. Thanks a lot
-
28th November 2015 at 11:50 am #5465
happened! thank you
Yet what tables need to be cleaned? that the site worked faster -
28th November 2015 at 2:17 pm #5468
Yet what tables need to be cleaned? that the site worked faster
Cleaning the tables that can be cleaned will not make the site work faster. They are not ones used to display most pages.
Tables like site_access are rarely accessed so make no difference to normal use. slow site is more likely to be caused by lots of access to external resources (Google analytics, and any other similar add-ons). But you can test page loading speed with browser tools to find out what exactly makes your pages slow.
But it is still good to clean some tables a few times each year, just to avoid problems like today. So three other tables that grow are
xx_site_logs. Clean this in Administration > Site administration > Logs
xx_site_changes. Clean this in Administration > Site administration > Logs; and Administration > Family tree tools > Changes log.
xx_gedcom_chunk. This is only used during GEDCOM import. So once import is done, this table can be emptied. You need to do this directly on the table.Nigel
My personal kiwitrees site is www.our-families.info -
28th November 2015 at 11:15 pm #5469
Thank.
I did everything as the said
- The topic ‘Site access rules’ is closed to new replies.