[4303] Married names
Brought to you by:
canajun2eh,
yalnifj
Menu
▾
▴
#2353 [4303] Married names
The problem was in 2 parts:
The Admin menu batch update to include married names hung, giving :
Fatal error: Maximum execution time of 60 seconds exceeded in /home/xxxx/yyyy/WWW/phpGedView2/includes/functions.php on line 2905
so I restarted PGV, tried to accept updates, and got :
Fatal error: Maximum execution time of 60 seconds exceeded in /home/xxxx/yyyy/WWW/phpGedView2/DB/mysql.php on line 30 (this might not be the fault of PGV, but an outcome of the first stoppage)
This is in a sandbox, so no harm done. I've no idea how many married names got proposed/accepted (there are 2600 families in the file, 8300 indi's).
Paul
A bit more detail.
The first "married name" batch update stopped at about Indi 6000 (out of 8000). It tried to accept them all, but that also stopped. So I accepted maybe 20 changes one by one, and then accepted all changes again, and it worked!
I then went back to the admin menu, did the batch update request again. Away it went, got the rest (everyone between 6000 and 8000), and all were able to be accepted. So it's not a terminal situation when it stops working...
Paul
If you are auto-accepting, then the batch-update was designed to that when it times-out, you can resume by refreshing the page in your browser. This appears to be working OK.
But, if you don't auto-accept, then you can generate a huge number of pending updates and the batch-update needs to merge all of these before processing.
This is not just a issue with the batch-update, but with PGV as a whole - the pending changes can also overload the system on any page that processes a large number of records (e.g. indilist, famlist, etc.)
I'm not sure this is really a bug - it's all working as I'd expect.
OK. I accept that. And it is possibly a fairly extreme case.
But I don't accept that the best advice is an error message, with no obvious place to go...! :-)
Paul
The trouble is, once PHP hits the time limit, it takes control away from the script, so we can't display our own error message, even if we wanted to.