Hi,

This would be a PHP issue, not anything with MySQL. You might want to try moving up to PHP 7.4 or down to PHP 7.2 and see if that helps. Obviously, no PHP script should be able to make the interpreter (and thus the web server into which it is embedded – I'm assuming that you're running PHP as an Apache module here) crash. These crashes usually are issues in a specific version of PHP itself, and updating to another minor version is often enough to resolve the problem. In your case that's not working, so it might be a larger issue with 7.3 generally.

If upgrading or downgrading doesn't resolve this, or isn't possible, then the next thing to look at is the metadata on the media being viewed. Various versions of PHP have behaved badly with certain entries of EXIF data from specific devices. Sometimes the errors are silent (Eg. json_encode() returning null with no error set) and sometimes loud (Eg. your segfault). A quick way to test if it's EXIF data triggering the crash is to edit

commenting out lines 1204-1206:

if ($vs_extracted_metadata = caFormatMediaMetadata(caSanitizeArray(caUnserializeForDatabase($va_rep['media_metadata']), array('removeNonCharacterData' => true)))) { $vs_extracted_metadata = "<h3>"._t('Extracted metadata').":</h3>\n{$vs_extracted_metadata}\n"; }

If the pages load when this code is removed at least we'll know where the problem is.

If possible, please send me the media from a crashy record, so I can try and reproduce the issue on a different install and server.

Seth