SQL query to list all WordPress post revisions for archiving
Here's the SQL query to get all post revisions, which I do prior to cleaning them out of the database, which seems to make it much faster: SELECT p.* FROM…
Subfolders
Latest "Troubleshooting log" files
Speeding up rsnapshot (rsync) backups by removing wildcard paths from exclude
I removed a bunch of wildcard paths from rsnapshot.conf's exclude, and suddenly tonight my backup ran in a few minutes instead of taking over a day like it usually does.…
Performance troubleshooting & settings changes 2025aug29
Following several days of frequent freezes, I tried changing the following settings updated in : [opcache] original settings ;recommended by https://vpsfix.com/14433/virtualmin-post-installation-configuration-and-server-optimization-guide/ opcache.enable= opcache.memory_consumption= opcache.interned_strings_buffer= opcache.max_accelerated_files= opcache.validate_timestamps= opcache.revalidate_freq= opcache.save_comments= ;end recommendation…
Directory and File Locations particular to this server
PHP config - Includes: - opcache settings - error warnings PHP slow log setup is in PHP log - PHP error and slow logs by pool are in
Resolving an rsnapshot error — “rsync: –delete does not work without –recursive (-r) or –dirs (-d). rsync error: syntax or usage error (code 1) at main.c(1795)”
I discovered rsnapshot hadn't run in a few days. Checking /etc/rsnapshot.log, I found every recent day had this: rsync: --delete does not work without --recursive (-r) or --dirs (-d). rsync…
VMWare VM unreachable via IP after reboot, even from host machine
My VWWare VM lost internet connectivity after a reboot. Even the host machine could not access any service on it. Http/https got 523 errors. I powered down the VM, changed…
Reducing rsnapshot or rsync resource usage
I've had sporadic problems with clearing the WP cache causing the server to return 520 errors for a few minutes. Usually other sites on the same server are fine, it's…
Deactivating, deleting, and completely removing a plugin that WordPress won’t let you deactivate
I installed the WordPress plugin LWS Optimize, which turned out to be unusably broken (which is the reason I'm not linking to it) and made my site unusable. To make…
Website returns 503 server errors, but no errors in logs
Had a weird one today. Last one website of the several of on this server suddenly started returning 503 (service unavailable) errors. There was nothing in the PHP error log…
/Devlog
2025sep17Made new under construction popup fixed instead of absolute position2025sep16Add front-end message saying if I've worked on the site within the last few minutes.Add txt and js to allowed new…
